When I try to run the crosstab query wizard in Access 2003 the following
error appears:
The expression On Resize you entered as the event property setting produced
the following error: The expression you entered has a function name that

Does anyone have a simple way of watching an Access file and letting the
user know when no one has that file opened?  Excel has that ability with
shared files - it will let you know when the file is available for exclusive
access.

Getting the  message is:  " A program is trying to send e-mail on your
behalf.....  Do you wnat to continue?  YES  NO"
Using Access to generate the email and have to click YES on this message for
each and every email.  Kind of negates the value of sending invoices by email.

I have a church accounting program developed on Access 2002 with over 100
different churches using it.  It is distributed as cbw5.mde, and the tables
are cbw5_be.mdb.  About half of the users have Access 2002 or later, and the
others have Runtime Access 2002.  One of the major ...

I am building a database using access for the HR dep at my company, i need to
add in a table for attendance which will need to be used on a daily basis by
the reception team to enter if the employee is present/holiday/sick etc. I
have built a database where each employee has a ...

I am having problems trying to populate textboxes in a form from a
table.    I have a form with textboxes labeled Text1, Text2, Text3....
I get an error on the "Me.[TextNo] = ![FieldName]" line
I have verified the TextNo and FieldName variables contain the correct

I am setting up a table and then a fill-in form to duplicate a paper survey
that we conducted of participants in a trade show.  Some of the questions can
have mutiple answers.  How do I accomodate that in the table and/or form?
Sub form?  Nested form?  Lookup tables?  

I want my application to have a little dialog box that pops up to ask for a
user name and password before the application is opened. Does anyone know how
to create this?

Hello People,
I´m a question for you:
Can I change the size of my grids in a formulary? I have a grid in a
formulary to show a result for a query in DB.

I defined something below in General Declarations,
Dim FILE1 As Database
Dim TABLE1 As Recordset
Dim SSQL1 As QueryDef

I have a field on my form called "description" that can list a number of
insects. I want to create a query (and ultimately a report) that will ask
"Enter the Insect" and every record with that particular insect as part of
its description will come up (similar idea as searching ...

Hi
How do i increase the columns in MSAccess from 255 to 1000 when runing a
query off two tables i need to merge? There are 525 columns I need to combine
into one table. I keep on getting an err 'Too many fields defined" (Error

I am having a problem with my update query.
Reading.value is a combo box on the same form as the button that executes
this query.  It executes an insert query first which works fine, and then an
update query which also works fine.  The update query below then returns

fast typing quizes i want to 1 now

I've created a form but I want the final results to be outputted onto an
excel spreadsheet. Is there a way to do that?