I have most of my tables in my front-end Access 'linked' to a sql server back- end. I have some reports that take a couple of minutes to run (sql reports, not...

Hi, I’m having problems conceptualizing the correct structure for my database and/or invoice form. I think the solution lies in both the database...

I am a VERY novice Access user and attempting to build my company's first database. I've created three tables to track our consultants: Consultant Contact...

I have a Combo Box based on a look up table for a percentage field. The percentage field has been set up as follows: Field Name: Percent Data Type: ...

I am trying to run a scheduled task to run a macro with updates, but have to enter my Password as soon as Access opens, is there a way around this so it can...

I tried multiple different changes, but without any luck maybe someone here can help out on what I am doing wrong. I keep getting a message: The changes you...

We have a database for our valves & hydrants for which I'm attempting to improve in many areas. One such area is the location field can contain a lot of...

Hi, Hope someone can help. Here's the scenario: I have two MSAccess tables MainTab and SubTab. MainTab has an autonumber 'id' column as primary key. ...

When I update a feild in MS Word, Access opens up to get the proper information, but does not close when it is finished. Essentially, every time I update a...

Hello I want to design my database for inserting records in 2 separate tables and after make search event for searching in both tables and retrieve...

I'm looking for guidance on Indexing in Access 2003. Background: I'm working with an Access database shared over a network, about 20 users and it has been...

I have a small database and I want to record, in a table field, the date at which a record is added (but not edited). I want this to be permanent. Should I...

I am trying to design a budget database and I want to have consistent categories and expense. I have a table with Category and Expense It looks something like...

Hi all Access 2003: I have an existing Access table, containing 10,000+ rows called "Printing" and I have decided to insert a new column called "Financial...

On Tue, 8 Feb 2005 05:07:53 -0800, "Jeff Boyce" -DISCARD_HYPHEN_TO_END wrote: If I remember correctly, the kind of indexing that speeds...

Microsoft Office Evolves Community as Part of Office 2010 Launch: As you know, this is a big year for Microsoft as we are launching the latest version of...

For an example, I have been using MS Northwind example. One problem I have run into is adding the same item twice in an order. I am keeping track of time in...

I thought it best to start new from the thread "Items Table help" that I originally posted. Original Post: I have a photography business that I am setting...

Hi I am trying to learn how to design a relational database. I have designed one database in access 97 but it was a flat database file since I didn't know how...

I have an Access 2003 database to split into a front and back end. I expect to use the wizard to accomplish that task. The database is on one computer on my...