Hello -
We are running Access 2002 app, but our mdb files are still Access 2000.
I have imported data from our business system where the primary key is case sensitive - lowercase is unique...
I have created lots of Access databases and I want to create custom shortcut for each database. Can anyone recommend some good software or templates for cutom shortcut?
Thanks
I have a Dart League Database I have inherited... My question is I have a Query, based on the PlayerStats table that is supposed to return results of the lowest PPD (Points Per Dart) in a sin...
I am looking to create a survey type database. There are 7 different surveys some with the some of the same questions.
At times some of the questions will change but went to keep the histo...
Hi there.
I have a situation that can be described as the following:
I am developing a .net 3.5 winforms application for PC that interfaces with an access database. Ideally I'd like to u...
Hi,
In Access 2007 I'm trying to add values to a table field with a data type of Number, format set to standard, decimal places set to 2. No matter what i do, if I type the value into that ...
Hey Experts!
Can you help me please?
I have a few inventory tables in a database;
Table1 has columns: user name, pc asset number, laptop asset number, location and dept
Table2 has colum...
hi all
Some of my queries do not fit in portratit, but only landscape, so each time i need to print i have to go in to page set up and change the settings from portratit to landscape. may i...
I have a database that was created in ACCESS 2003 (working database). This database works off linked tables in another database. We recently went form ACCESS 2003 to ACCESS 2007. The linked...
Hello, I am fairly new at Access relationship building. I know forms and reports quite well though. I hope I dont confuse with my explanation as I dont understand proper relationships that...
Our HR Database is currently experiencing issues whilst running over Citrix.
This is the application location command line in the Citrix Program Neighbourhood:
"M:\Program Files\Microsoft ...
I want to setup an mde file with user level security. I have made the mdw file for the mdb database but how do I make the mdw file for the mde database?
I have used the user lever security ...
I've chosen to sort the table in a split view form by
1. date of creation (newest on top)
2. and then by the time item was last selected (newest on top).
Question: In the table portion...
I have a pretty fancy Access 2003 Database that I've created, with all those fancy forms, reports, and what have you.... then I learn about the user limitation of the Access backend. Apparent...
I have an access database that has already been split to frontend and backend. However we are going to now need to access the database through the WAN which is obviously too slow. So I am goin...
Hi all
I have created a table in Sybase
I have created a table in Transact SQL using the following code
CREATE TABLE lktblALSCallType
(
ALSCallTypeID INTEGER NOT NULL UNIQUE,
A...
I have a project where there are some very large text fields to enter data (descriptive paragraphs)
The first thing we are having problems with is while typing in one of the text boxes, usi...
Here is the scenario:
I have customers, who have monthly accounts with me for their vehicles.
The vehicles take product from me on daily basis and i issue them a credit memo.
The prices...
Currently, I have a Microsoft Access Database 2007. Multiple people need to access the application at one time, but receive "Read Only" accesss. Is there anyway to allow multiple users full ...
I have a table called Document containing various info on each different document (primary key is an autonum DocumentID). I want to link two documents to each other to be known as Like Docume...
When I set a required field and it displays an error if no data is entered the message is cryptic to the layman. How can you change this error handling message to display a more userfriendly m...
How can I change the name of a query to include 'qry' at the beginning (i.e. qryName) without breaking it's dependencies?
I have this crop up all the time. I find myself wanting to change ...
I am working on my table design for an MS Access 2002 financial database. I am having problems setting up my tables. I have set one to many and referential integrity, but data does not seem to...
Hello Experts,
OK... this is a multi-tiered question.
I have a database that needs to filter down to single record and I have provided a rudimentary example. The progression needs to work th...
I would like to setup a criteria in an Access Query with a specific date range. Here's some sample data in the different fields.
C1 C2 C3 C4
1/1/08 Name ...
