I am using Access 2003 I have a table of nearly 10,000 records which I have transferred from Excel to Access. The table consists of contact names, company...

Hello All, When I query a table for duplicate records I get two records that are very similar but are not the same as duplicates. is there a way to fix this?...

I am currently designing a database that will be used on a LAN and a number of remote laptops that may or may not have access to the internet. I would like to...

Actually, my question is probably very simple, but I can't figure out where/how to do it ! Here is my problem: I have a table, with a field called "item" and...

Hi, I have a database with a table of employees. tblEmployees numEmployeeID (autonumber) PK strEmpLastName We need to keep track of total hours worked in 5...

In previsous versions of Access (97, 2000) I used to be able to link to a second table in the same database using a hyperlink field pointing to the table. In...

See responses in .TablesdbDesign If you decide that you want to post questions to multiple newsgroups, you should post just one message, directed to all the...

I am using VB6 to create and load a table in an Access .mdb database. The table is very wide (6000 bytes wide) and when I load data there are about 200 rows...

I am btrying to put together a database that will track rental and how many additional copies I have available Order table has the item to be rented and a...

I have an unbound form that I have set up to give me date parameters for different reports ie I have text boxes with start and end date and command buttons for...

Hi, Fairly new to this so hoping someone can stop me wasting time going down the wrong road. Trying to produce a table of country info, (several columns -...

Hello: I am considering a redesign of my tables. Currently I use an Autonumber field called Book_ID, to identify records in my library table...

Wondering if anyone can tell me if and how it is possible to link a table or subtable to a record in a field of another table. For instance the parent table...

I have a A2K database with a table which seems to have a corrupt index on a memo field. The corruption shows as garbage characters when the memo field is used...

Hi I'm trying to print some queries and respective relationships in Access 2000. I Know i can use the printscreen shortcut but I would rather print it directly...

Can't seem to get either of these combo boxes to work. Both are on the same form and I have been playing around with them, but can seem to get them to pull up...

I need to create a validation rule with the following parameters. It is a text field with numeric characters and it is required to be 9 characters long. Here...

Please forgive me for asking about a calculated field in a table. I know it shouldn't be done but I'm getting leaned on to figure out how to do this. The...

How can you create indexes programmatically on Access tables using db?

hi folks. recently - last week or two, i think - somebody a question about tables or possibly about trying to secure the database. there were a number of...