In Access 2K, I have a table with some 200,000 records. The table has one field that is used to sequence the entries named "SEQ". It is a Primary Key indexed...

I am putting together a database to track various information about equipment. Among the information being tracked is an inspection checklist. The...

With the help of this forum, I am trying to correctly design my tables to be normalized. I would like to break my design down into sections to work on just...

I am looking to create a database which will keep track of a warehouse inventory as well as inventory on sales trucks and track customer sales. Want to link...

How do I get a field in a table to hold zeros before the number, example 083121555-01 I have tried double, single, integer and non hold the 0 at the...

Hello Everyone, I have spent time online doing training and have just finished Oreilly's Missing Manual for Access 2007. While I am better now than when I...

I need help in linking several columns. If the first column is on thing then that determines the contents of 3 other columns. How do you link them?

I have a lot of queries, reports, modules in a database and I need to rename a table. Is there a way to get a list of queries, reports and module where that...

Hello NG I have a huge access database that is maintained with a rather old application (VB6). The way the data is maintained is by using RecordSet.AddNew...

Does anyone know if mappoint will allow me to import a list of locations and draw me a route in the order in which they are stored/imported in the table;...

Hi Guys, A question that I have is what do you believe is the best way to design a timesheet for a week. The form design is to have the task on the left...

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.

I have a database with Ins Company info. I have set up a combo box but would like to have all other fields auto fill once I lookup the Insurance...

I have two tables, one called Country with one field, country ID (e.g. Philippines), the other called Province with several fields, but the primary key is...

Do you have a copy of a Microsoft Access 2003 DB for the Construction Business?? I would like to use it as a template for my business.

After downloading Microsoft Access templates, I could not enter a valid postal code and phone number here in Australia? How do I change the default fields?

I recently split our database using the Utility. Not sure if it went the way it was supposed to? The be and fe are still on the server and occasionally one of...

This connection string I copied from "ASP.NET and ADO.NET" by Esposito is very interesting (see below). It works when my perl programs are not trying to use...

I have a report with 691 clients with each assigned one Account Officer (AO). There are 74 Account Officers. I currently have a query based report that prompts...

I am trying to secure my application and I just noticed there is a group of icons in lower right side of window which will allow entry into design mode if...