I get an error I can't seem to fix when I try to go to the switchboard editor
it says
"The expression On Exit you entered as the event property setting produced
the following error: The object you referenced in the VB procedure as an OLE

im trying to create multiple selection combo boxes, ie if format = a use
combo box 1, if format = b use combo box 2 and so on. anyone know if this is
possible

I have an existing Access 2000 database with internal tables and existing
forms, reports, etc that use those tables. I want to dump the data out to SQL
which I know how to do. The questikon is: Is there a painless way to switch
the existing forms and reports to use the linked ...

I am creating a table that is being used to collect recipes.
Each recipe has a varying list of incredients.
Are my only two options
A Combo Box

I am an experienced Access user.  I am on Office XP, Office 2003.  Access
won't let me save design changes on certain forms.  HELP!  I am stumped.
Thanks.

I have a database that is the design master.
I had copied a table (i assume the parent)and pasted it(table 2). It was
redesigned  to fit my needs.  I then created another table(table 3) from the
make-a-table query.  What I want to be able to do is to make corrections in

I am a bit confused on table construction. I thought I was ok with Access
but here is my question.
I want to create a form based on a table. Simple...yes.
BUT here is my source of confusion.

In one of my tables there is a field defined as date/time. When I add a
record for example 07-12-2004 12:15:00 this is ok.
but when I add a record with 07-12-2004 00:00:00 it goes wrong. The only
thing that after input that is displayed is 07-12-2004.

I know little about access..have dabbled a bit but definitely a novice. What
I'd like to do is build a simple database where I can input entries that
include: Servername, downtime in minutes, date of downtime. Then at the end
of the week, I'd like to run a report that will give ...

I copied a database that I have used for years. It has always worked on these
two computers.
I made some minor changes to a form using Access 97 SP2.
Everyhing worked fine except my date field.

Can someone give me the URL for the MSAccess
 (1) SQL documentation?
 (2) The documentation on DAO
 (3) Specifically functions for fetching and storing the attributes (such

my tables in the relations window (A2003) are displaced (to much above), the
scroll bar is so above as it is possible, although the tables are to much
above and it is not possible to pull them under. Does anybody the solution
for this problem ?

I would like have a control button to perform a comprehensive search for
names, dates, number, etc.  I am able to search specific queries based on
matching 'names' or 'dates', but I would like to have a search available
similar to a yahoo, where you can input anything and results ...

Folks,
I am not sure how many of you encountered this issue.  The rocket scientists
at Microsoft decided to change the default for Text columns' allow zero
length string attribute to Yes, from No.  This broke many of my existing

Currently I use dateserial function to convert number to the date/time format
using query and its work.
UPDATE billing SET billing_date =
dateserial(left$(maint_date,4),Mid$(maint_date,5,2),right$(maint_date,2));