I need to create a new database from/similar to an existing one. The existing one is very intense with many things no longer need (or never were needed)....

I need to include the year value as precedent to an autonumber in table design Can anyone help?

I am using Access 2003. I created a main database with several small db tables to use for look-ups. Ex: JobTitle in the main Db is a drop down menu to look up...

I am having trouble figuring out how to track dates in my database. Tables = tblProgram Program_ID PK LOC_ID FK Contact_ID FK Agency_ID FK

I have been working on a survey database and between AYS, advice here, research and reading books, it is coming along quite nicely. tblQuestionnaires ...

We had the same experiences with bad quality humaneyes. No after sell services, it's really sucks.

Hi.. I think I might be going around this the wrong way - but this is where Im at.. I have 2 tables of tbl-Products and tbl-StateID. The products has a...

Hey, I have another problem that never happened before. The form keeps blinking. Does anyone have an idea why it does that and how I can resolve it? Thank you

I'm maintaining a large complex database that has existed since version 2.0. I know there are lots of redundant objects and many tables and columns that are...

How do you formula a cell that will show the result (Pass or Fail) according the information given from the other cells? For example, on the column D will...

Hello, I need an assistance please. I have a subform with the following: Item Number Quantity Pulled (Check Box) 001-00000000C ...

I am using Access 2000 and XP and attempting to append a record in VB6. The statement: Adodc1.Recordset.Update is giving me an error message: Index or...

I have a phone log database, (i may have posted this b4, but i cannot find it) heres the setup: date time For ( drop down table, single column) Calling (drop...

Hi all, I am currently creating a networking database and i have a textfield for "subnet mask" within a table and have correctly setup the input mask...

I have a database where the designer linked tables by the Social Security Number. I want to change that to an autonumber field in the names table and a same...

Test only

Hi all, I am currently creating a networking database and i have a field for "subnet mask" within a table and have correctly setup the input mask -...

I am creating a master database which will be re-used for entering attendees etc for various meetings. How can I set something up that will show the meeting...

I am trying to build a patient scheduling program using Access 2003. I would like to setup a reoccuring function so that a patient is scheduled for the same...

I am developing an acess 2003 database on winXP pro and have hit what appears to be a stonewall. Right now, I have the user check a check box to select an...