hello, i would like to know the easier way to implement in a database, a category, sub category structure. like i have products, that are categorized like...

I have a report that has a blank page before every new entry... it's driving me nuts! Is there a way of getting rid of it?

Dear Sirs, how is it possible to print posting labels for selected records in a table.

I current use this to test if a table exists in the front end: If DCount("*", "MsysObjects", "='tblTempXLS'") 0 Then 'Table Exists How Would I amend this...

I have spent way tooo much time trying to make this function work. I've searched the groups, and read ADH 97, but to no avail. I am looking to populate a...

Hi all, First of all I'd like to thank every body who sent me a useful info, I heared a lot that a databse made by Microsoft Access gets damaged easily...

Dear all, I'd like to control the number of open forms in my database,I'd like to keep it always one form "other that the dialog boxes" ,so in the task...

On this page I found code for compacting the database. http://www.mvps.org/access/general/gen0041.htm Im not too sure whether it is code for VBA or a module....

Under Options, Edit/Find.. I've already unchecked the three boxes under Confirm, but I'm still getting confirmation pop-ups when running queries. I don't...

I have no trouble printing a stack of customer invoices at month end. I can then sort them out and mail them. I am having problems getting my head around how I...

I have a database that 5 people will be using. There is a field "txtName" that pulls the nt login of the user. I want to create a form that has a drop down...

Hi, I have a made query with the following criteria in the date field of the Table = now when I execute I get box with a header titled "Enter Parameter...

Greetings. I was trying out the ADP. Our office moved we all got new PC's. I copied the ADP file to disk, but the tables, forms etc. do not exist. I am...

Dear all, I have made a lengthy query based on that I made a report, but in the report I have taken out some fields fit results on an A4 Landscape paper -...

How can I use a table of zip codes which needs to link to multiple tables? For example, A list of businesses links to it and so does a list of individual...

How can I use a table of zip codes which needs to link to multiple tables? For example, A list of businesses links to it and so does a list of individual...

is there any way to copy the results of an access query without including field names? i am trying to copy and then paste in another program but one of my...

This is my first database and I am learning from scratch and the Microsoft help options a lot. I cant figure out how to type telephone numbers starting with...

Warning to Access Developers about ACE. DON'T use multivalued fields (MVF) they are worse than LookUp fields and SubDatasheets, in fact they (MVFs) are a...

I create several records using my form and the records save in my table . Several of my options within my records are combo boxes linked to other tables...