I have imported data where in one field (Invent#) leading spaces and perhaps also trailing ones appear. I tried to get rid of these by first creating a new...

Please can you help with code for following problem? I have this table, short example, where the discount matrix lists the various discount structure. I need...

Using access 2000 (because that is what client has). I have a table with a large # of fields, 209 at present but it will come down a few when test fields are...

I am having quite a problem regarding a database I am trying to put together from linked tables in our inventory program, Mas 200. I am using 4 different...

I have an Access 97 database with two Tables on has only two Fields "Officer" "Location" I use this Table in a Combo Box for the Officer to enter their name...

I have an Access 2003 database. Two workstations use it from one location (root on d drive on one of the two computers). I split it and copied the FE to the...

I created my database application on one machine, then split the database on that machine. I then moved the front and back ends to another machine (this will...

I have created a bunch of employee records in my data base. I would like to have a Drop-down menu that has all of the last names of the employees and a button...

i'm trying to get dlookup to pull a value from a query in the details section of my report. this way, it will reflect the value i need it to as the groupings...

Hi All, I would like to have a field on the data entry user's form, to enter an employee badge number. Based on selected badge number the persons name,...

Am reallly confused on combo/list box. If i go as per guidllines, bound coulmn means value from row source and column count means column displayes. When i...

I can't seem to set up a many-to-many relationship. These are my tables: Customer - Customer ID (Primary Key) Last Name First Name Etc. Items - Item #...

I can't figure out what the rules are for foreign keys in tables. For example, M:M is easy -- the table includes the PKs of the two related tables. In a 1:M...

Greetings We are developing a complex system, which will run on Oracle, MS SQL Server and MS Access databases. All the databases are to be replicated. We are...

Still stuck.... A truck (truckId.field) drives into my warehouse today (date.field) The same truck can make a dilervery next week so the truckId and Date...

Newbie question: I'm creatinga database for incident reporting. I've got a table for each question, with records for each response. I'll link these to the...

I want to create a custom icon for the main Access icon for a particular database, in order for users to easily differentiate between databases. Is this...

I am designing a database that needs to track information from different questionniares (some of the information maybe the same and some maybe different...

I have a large database that is going to be upsized to SQL Server. The tables were designed using a lot of lookup fields containing links to other tables or...

I went to startup options and turned off all the choices. Now all I see is the woprking switchboard but can't make any changes. No longer see menu options or...