Is there a standard protocal for setting defaults in a table to avoid Null values from occurring? I'm thinking that all numeric fields should have a default...

I am working on an existing database that has over 500 forms in the front-end and is linked to various back-end databases (some Access, some SQL Server, some...

I am setting up a series of look up tables. Users will be restricted to the lookup table list via a combo box in a form. the data being listed is text. On...

How do I set the value of a list box control on a form base on the value from a combo box on the same form? Thanks

I need to have a column that only numbers 1-20, with a repeat numerical system of 1 - 20 for a database of 200. The project: breaking down 200 employees into...

I have a very large table. In a database by itself its about 340mb. When I try to set the primary key it says "Changing field data types" then gives me an...

I have a database that has linked tables to another database. I have an absolute path set right now, but will be distrubuting to customers. Can the linked...

Hello there I have huge database on access 2003 with 400 tables on it (most of them are linked to sql server) When i convert it from access 97 the...

All, I'm trying to have the focus of a subform go to a new record when the subform gets focus. I've tried the two combinations below but they don't seem to...

I have created a form that contains 4 tab control pages. I am trying to set the tab order to go from the last in one page to the first in the next. I'm...

Hi Is it possible to set Allow Zero Length = Yes property for all relevant fields automatically via code? Thanks Regards

When I first started working in Access, I would set relationships for all the tables. THen when I got "clever" and began writing lots of queries, I noticed...

I read all the previously posted questions, but this time mine is different. I need high precision since I use the column for calculation. I have a column ...

Hi - I have a field in a table which simply inserts the current date and time using the now() function. However this is now based on the server is the Us...

Hi all :-) Access 2007 - Vista SP1 I have a field in a table for an appointment time, but, I want to have an input mask for it set to 00:00 P (or A), having...

Im keeping Stats for a baseball team, currently im doing this in excel but I would like to set Access up so that I could do it all in there. Currently I have...

I'm trying to set up a simple billing database which works off a form to check off medical procedures, which in turn calculates (I assume from a pricing table)...

I need a database for 6 different types of training that must be taken by all members of a purchase card program. Some training must be taken annually, some...

Hi - I need to setup some kind of a database that we update monthly but use the data in Excel and want to find the most effecient way to do this. The data...

Hi. Hoping someone can help with my dilema. I have an Access database with a field called DEPOSIT DATE (format is MM/DD/YYYY) and another field titled DUES...