Hi all, I am designing a simple database and can't decide or figure out how exactly to design a certain aspect. I have started it 2 different ways so...

The database I'm working on manages Medication Assistance Programs, and I would like to be able to create one big Client Medication Profile form that...

Hi, im a begginner in Access so please be ready for my question . Im designing a table, and have a data field, i want to be able to make a criteria so the...

I have a few people in my office that are building a new database. A few of the tables they do not have a primary key set. These tables are very minor and...

I am importing data into MS Access 2003 from an external source. the dat format is numeric 0digit number. ie: 107017 is Jan 17, 2007. Any Idea how I can get...

Hi All, I have an ID field that is an AutoNumber. This database has been working well. Know all of the sudden the AutoNumber is trying to re-assigning...

I am using Access 2003 I want to created a field in a Db design that only shows me the month and year. What is the input mask I use to get only the month and...

I would like a field in a table to be recorded as a julian date for the date entered. So whether I enter a date from 2003 or 2007, the field would record the...

I'm not sure what would be the proper normalized format for this: I am storing vehicles to be sold; I have a table that stores the vehicle ID(PK), year, make,...

I've created a form with several subforms. If I input data into a subform field and hit the tab key, the data disappears and the cursor does not move to the...

In the OpenEvent of the new form it won't accept Me!= Forms!! When I go in to DeBug it is highlighted in yellow and when hovering over Me! the cursor...

I am trying to design a database that keeps track of where our customers fields are. We are trying to do this in a StateCountyTownship fashion. How can I...

I've just found these discussion groups and have noticed that responses to questions by novices and newbies are really informative, helpful and generous,...

I need to create visit records that track who visited what work site. The visitors' information already exists as records in my databse. I need to select...

I've inherited a db that has fields for each of 11 subtests of a test (the record). Every subtest has a value, so there are no empty fields for records; the...

I have a table, EMPL_ISH, that is created automatically and I need to change the definition of one its fields, EMPL_NBR from a Number\Double to...

When I'm creating a table, I'd like to make the Primary Key an autonumber that is the date and time the record is added ie. yymmddhhmmss I don't want this...

I am using Access 2003 I have just created a Preventative Maintenance Db. The computer this program will be on is in a area that a lot of people have access...

www.Brandon-Lands.com

Inventory/stock control template or HELP. I have been playing with the standard inventory wizard template which deals with ordering and selling single...