I've got a question about preserving existing data when a lookup value changes. If I have a Product table which includes Product ID, Product Description and...

It is hard to find a human resources database to hold personnel information on each employee, plus handle benefits and deductions. Any help in obtaining a...

New to Access.... Does anyone have a template I could use to schedule different machines in a production environment that would allow me to determine machine...

I work for a drum store and every year I watch the staff go through a laborious method of collecting an inventory of stock onto separate Excel spreadsheets....

Hi I'm used to using lookups and forms etc but need to do something that I think links queries, VBA (completely new to) and forms: I have a form for...

Hi All, I have cross referenced this question in general section but it has not been answered! I have a database in Access 2003 which keeps track of in and...

When I set up a new table and include a Number field, the Field Size defaults to "Long Integer", Decimal Places is "Auto", and Default Value is 0. When a...

I'm currently using excel to compile reports and would like to set it up in access. I would like to know how to set up the tables

Hello I have built a forecasting spreadheet with 20 tabs in Excel but am convincved a database would be a better vehicle, the data included and required is...

Please Help Anyone I have a Form in an application that I am working on that works great. How ever I cannot make any changes to it (the form itself nor...

I am having a problem with Access. Whenever I am in 'Design Mode' in a Report, Access crashes when I click Save or try to Preview the report. There is not an...

ITEM DESCRIPTION ____ _____________ item1 item1 description item2 item2 description item3 item3...

Hello, I'm not so great with access and am looking for a template for a database that i can keep track of my research articles library. With search strings...

Hello, I added a textbox to a form and selected Rich Text as the format type. The selection was Plain Text or Rich Text. I got a message saying something...

Is there a way to have an automatic date stamp when some enters data into a record. -- Rose

How would you write an input mask that limits the possible data entry of day between 1 to 31, and month 1 to 12? Bill

I have a database set up with FY07 data. I would like to continue to use this database, but add in FY08 data without changing the old records. What's my...

Hello, I have a relational database well written if I do say so myself :) About 75,000 records in one table, linked to an examinations table with details of...

Hello: I work for a govt. agency and developed a database that is split into an application.mdb and a table.mdb. Obviously all of the tables are stored in...

"Robin Donald" wrote: Thanks for jumping in and, yes - I forgot that bit. Each user (4 max) had an mdb front end which he runs from a local copy on ...