I have a report bound to a crosstab query. The problem is that under
different conditions crosstab returns different column headings. This causes
problems with binding of fields on report. Is there any way to make the
column headings fixed in the crosstab query so the field names ...

Is there any way to find out what database object or table was corrupt after
a repair has run in Access 2000? If I can find this out I may find out why
the corruption is happening.
Any help would be appreciated.

I have some users that continuously end task on my database when a search
takes to long. In turn corrupting the application. Is there any way to
prevent this? The Microsoft KB for Methods That Can Be Used to Prevent
Corruption suggests not  allowing Task Manager to shut down the ...

I have a table 'LeadHistory' which has among others, the following
fields.
Salesman(Text)
SalesmanAssmntDate(Date/Time)

Hi - I'm trying to work out a way to loop through (or just get a list
of) all of the tables in an SQL Server (2005) database from Access.
Based on the name of the table,  I will then proceed to do some action
with it. I want to use a DSNless connection. I have searched but

I need to write a query that has a criteria of two separate fields (one
compared to another, then a seperate one)  but I can't figure out how
to do it.  Let me first explain the table
id (primary ID)

I have a query that has a prompt for date as
Between [Enter Start Date - Format "MM/DD/YYYY:] And [Enter End Date -
Format "MM/DD/YYYY:]
This database is hosted on a share drive.  About half of my user's are

I have 3 tables with 1 field in each.  The third table has half a
million rows in it so I can do this with excel.  What I want to do is
create an array that I can export to Excel.  The data is as follows:
Table 1: C1, C2

I have an office with approx 8 people. I have used Access with a Form on my
personal PC for client records. I was wondering if I could put the Access
table on a server and put shortcuts on each work station to allow users to
view, update records?

My form has an image control linked to (.bmp & .jpg) files.
Each type of file will display correctly on the form and propery fill
out the ImageControl, however, when I PRINT the form, the (.jpg) file
prints normally (ie as the size it is displayed as in the image

hii..i'm  new here and dummies in access..i create one form that count total
salary.i have 3 field.let say a,b and c.c is auto calculate and will show the
total of a and b.my problem is when i look at  table
there is no value in table c.anyone can help me..

I'm in a form. I click a button to open a form. Within the onclick sub
there is code to open a form. I want that sub to wait until the user
completes his work on the newly opened form, then continue running the
sub. Does this make sense?

I have a function which caculates the number of years from a certain
date.  The function works great if the date is not null however when
the date is null I recieve a type mismatch error.  The code is below.
Any assistance is appreciated. Thanks!!

I have created a form in Access 2003 which I use to add, delete, change,
etc. records in a table. The form consists of a few textboxes (first name,
last name, etc. ). In addition, I have placed some buttons on the form (add
record, delete, etc. ) When I click the add record ...

I am working with Access 2003 on a computer running XP.  I am new at
using Access.  I have a Db with a date field stored as mm/dd/yyyy.  I
need a Query that will prompt for the month, ie. 6 for June, and will
return all records in that month.