I've been developing with Access '97 for quite some time. But now that we've
moved all of our customers to Access 2003 I'm going to do all of the
development with that tool. I have a macro which worked great in '97. The
macro was invoked by using the keystroke combination Ctrl-E. ...

Have a transferdatabase macro which used to import several tables but now
won't import past the first row. I've also tried creating an individual macro
for each import, then adding the several run macro lines to a single macro
and it still won't run past the first row. Please ...

I will like to create a IIF statement, because if there is no records
entered, between a starting date and a ending date, I will like that
my report show something like this: "No records for this period"
Hope that somebody can help me with this...

At work, quite some time ago, I downloaded some clip art from the Microsoft
collection and received with it the Clip Art Organizer and I really really
liked it.
When the powers that be decided to upgrade my office PC, I *thought* we did

In:
http://groups.google.com/group/microsoft.public.access/msg/a9f226e2a28bfb24
I said:
BTW, aislebyaisle.com was registered with one of the buried contact

We are experiencing an issue where multiple users are connected to a shared
Access DB on a network resource; while these users are working in the DB they
randomly get the message: \\server\share\accessDBname.accdb is not a valid
path.

Okay,
I've got a form for filling in data.  One of the fields in
the form refers to a table of colors.  I've restricted the
field so the user can ONLY select a value from that field

I have a checkbox called "noplay". If that box is selected I would like the
value of the textbox "formationid" to equal 29 and "playid" to equal 10

I have a form that displays records from a query. The form is "continuous"
and I have an event procedure written for the "On Current" event, which
should fire when the record changes. I'm manipulating the dynaset columns to
populate unbound controls in the form. However, the ...

I have a Dlls stored in an OLE Object field in my database that i put there
by copy/paste into the table.  What I want to do is check to see if the file
exists in the folder with the database at main form open and if not write the
file from the database to the folder.  I have ...

When trying to change font color or to a bold font I get a error message
"No more nes fonts may be applied to this workbook"

I have a table with an autonumber primary key. I have been using it for bogus
data while I've been working on the database design, but now I've deleted the
data, but I can't reset the autonumber so that it starts at 1 again.
Can someone tell me how to do this?

I'm looking to right a query to return the amount we should be billing our
customers for freight.
I have a table in which each record is a package. Each record contains our
job number, a normal freight amount, a discounted freight amount and a

I have a textbox that will be populated with an "S" and the last two
numbers of the year. How can I make this default to that?
Thanks in advance,
Dave

Hey Guys (and Gals),
What I would like is if an Associate has more than one activity on any
single day it should show them all.  (This end result shows in a calendar
style report.)  Right ow it only shows the first activity.  I have marked