I'm using Office 2003 and Windows XP. It seems to me that data entry should be clearly separated from data edit, or editing records. I have done this by...

In Access 2002 Bible, page 86, second paragraph, it says: "It's also a good idea to create a separate datatbase for just your tables. By separating your...

Whenever I've created junction tables in the past, I always made the PK of the junction table the combined pks from the two other tables. Ex: Table1 PK=A;...

My database is broken down as such: 1. Surveys 2. Clinical data collected for each person 3. Checklists I have received info from Duane H. regarding the...

I am having to import demographic records where the first and last names are in one field. I know how to separate the first and last names by using a search...

I am building a new application that will require linking to tables in another database. The tables the new application require are in a back end...

Im trying to figure out if I should create two forms, one for inputing/editing data using drop-down menu's, and one for displaying/deleting data not using...

I am playing with a barcode reader in my database. and from what i can figure out standard procedure is to set focus to a control then read the scanner. i...

I have a column that contains the first and last name. How can I seperate into two columns, one for first name and one for last name?

I have two tables : Expense Reports , Expense Details just simillar to the tables in the sample db , Expense reports but with more fields I am using db to...

Dear Fye, I posted this question somtime ago and the below was your answer, I tried today to add it in different places and in different format but it...

Hi let's say i have 2 tables with identical structure, date and value for example. These 2 tables contains overlapping data for example, the first table ends...

Hi Guys, Looking for help with this issue. I have an invoice form with a field and want, on save, to create a sequential number. If user cancels the...

I have to create a database of our clients. They each have their own file number, i.e C1234. From reading all the other posts I understand that I am not...

I have a table/query/form with a field containing a number, i.e. 2006-111. I need this number to automatically go the the next sequential number with...

I need help with design of a database I am writing to keep track of procedures that I do on patients. For each patient, one or more procedures can be done....

Hi All, I am looking to redesign our server database to deal with clusters and virtual servers better than the existing one does. My problem is that whatever...

I have not split my one database yet although I'm going to. Just a question. Right now I have the MDB file on a simple file server that everyone uses. It is...

We've just updated from Access 2000 to 2007. We've recomplied the code and all is working normally. Our problem is our back-end database on the server is...

I am trying to set focus to a list box. The listbox is accepting bar code font data. I am trying to only allow parts in the list box when the operator...