I need to increment a key value by "1" with each new record and the "1" needs to be a text field so that the format of it can be "L0001", "L0002",..... Using...

My database has a calculated date when calibrations are due again, for example, =date()+90 from the last calibration date. My problem is, the calibration can...

I am trying to create an IIf statement that will generate the sentence "Your account balance is $XX.XXX" for customers who have a balance due. Balance is...

Hello, I have a large database I am palnning designing in Excel (Thousands of fields, etc). For each table I have all the fields, data types and field...

I am setting up an Asset Tracking database that will need to track the assets weekly. The assets move around to different locations during the week. I am...

Does anyone know if there is an update yet for Access 2007 that will allow design of tables in a project database that is connected to a SQLEXPRESS...

Hi, does anybody know if there is a Visual Database Tools update in order to modify/edit objects when Access 2007 is connected to a SQL 2008 Server? Office...

I have a time sheet application I am developing and have a question about how to set up billable vs. non-billable time codes. In this application, users...

I am building a database to track offense reports. I want to know if i can lock specific fields so that only authorized personnel have access to change the...

Hello, I'm in a position of having to develop some type of training db for my company. I must admit I'm not the most enthusiastic MS Access person but have...

I am using an Access database to fill in and print claim forms. The claim form itself is embedded as a bitmap to the background of the report. This has made...

Hello: I have created an employee table with a primary key: employee_number. I also have two fields: Last_name and First_name. How can I avoid allowing people...

Dear friends, I am in the process of developing a database for a dancing school, in which many students will be recorded and each student will have to pay...

I need to make a database for a Career Day coming up soon at my school. There will be 300-350 students making 5 choices of 20 different presentations. However,...

I am designing a Components database to analyse forecast costings of parts based on quotes. I have two tables that appear to have a Many-to-Many...

Wondering if there's any way I can use the "Wrap Text" feature just like in excel for the Memo field in Access form? I have an "Employee List" form with one...

I have a table built with names, control no. and notes. I do not want to duplicate the names, control no. and notes in that table. I have another table...

Every month I get a Zipfile with over 300,000 records in it, which I go get and put into an Access database. Everything works great except the date. There is...

Hi, I am trying to develop a small database within which I have two fields: called 'Drop off time' and 'pick up time', these are used to calculate a feild...

So, I have been reading that it is impossible to create a "revision history" table for a set of records that use multi-valued fields. But I am a believer in...