BlankI have "compact on close" general option set for both my front and back-end dbs. I do a lot of table add, delete, change activity, from the front-end, on...

Hi Folks - Here's my problem. I have a table with a phone number field. Data entry for this field was not controlled or validated. I have manually 'cleaned up'...

Hi, I need to create a customer quotation database but cannot find what I need. Basically need something like the Invoice database but just to produce a...

jag letar efter syntaxen för "W"för att kunna få automatiskt veckonummer i min formulär

How do I set up a form that automatically fills certain fields once one piece of related information is inputted? An example would be from a table with an ID...

How do I add field to a back-end table that already has existing data in it? Basically I am trying to add another field to make the record inacvtive so that...

Which is used to produce more attractive output?

How do I get a drop down list to function in a parameter query. I want to restrict queries to a select list with precise spellings to avoid operator/user error.

Hi, i am having some trouble decided how to design this database. I have attached an excel spreadsheet with all the requirements. So far this is what i have...

I'm have to recreate ~ 100 replicated tables to remove the replication info fields ("s_..." fields). Certain field properties such as "Allow Zero Length" were...

Greetings: I am no programmer and I am a novice Access user at best. My boss is extremely cheap, however, so I have been tasked with designing a...

I am the tech guy at an elementary school. A few years ago when I got this position, I decided to track the work I did in a database. I had never kept a...

I need to track bank statement data. Statements must be grouped in the following order: by customer, bank, account, statement date, statement data. I already...

How can I take information from one workbook which contains a list, and using one or 2 lines from that list to complete a form in another workbook? I have a...

Does anyone know of a website that explains nested sets and how they are set up?

Please see 'dumb blondes' post in the queries newsgroup and add your two cents if you have any sugestions. She wants to store Month and Date only. Currently...

Hi, I need to design a model where we need to provide custom fields based on the customer. E.g; customer A may have 10 contact fields while customer B...

I distribute my A2K mdb to collegues. At times to implement improvements I have to modify the back end tables, which is a pain in itself to do programatically...

I have added the 2002 Template Wizard to Excel and I'm creating records in an excel database but I can't create records in an Access database. The...

How can I link two tables within Access so that records entered into one are automatically entered into the other?