I have a file I'm trying to drop in an OLE field so I can use it like
an attachment with a record. Problem is when I double click on it in
Access it does not recognize what application to start up. If I double
click it from Windows it works fine its only inside of Access. The

I am creatng a form and using wizard to automate some things.
I want the user to be able to Duplicate a record so I set this up behind a
command button on the form.  THe wizard did all the work.
But I guess since it is using docmd commands which is basically a copy and

Am I trying to do something that is impossible with access 97?
I want to write an address book application.
I have exported (from a Casio BOSS organiser) all my contact information
and it is now in a file called addresses.mdb I can edit this file using

Why do you use the word public in a function, when the function is fully
accessible without the word public in front of it.
I read the help, but did not really get it.
Cheers

Thanks for the help before I even start...
I'm working in Access and I have right now 1024 records. We have a field
set to Autonum that gives each new record a new file number. The
problem? We have had a number of records deleted and even though our

I'm trying to put a string to a key. (for instance ALT+F11)
In an field the user has to type that key and in the field the date and
username must be inserted.
Can anybody help me with this.

i have a novice question.
is Access multi-user?  can multiple users access the same database?

Have a couple of question from a newbie.  Thanks in advance.
How do I print Report called from a Form (or SubForm) using the current
record on the Form (or SubForm).
How can I do a multiple Form do display current record.  Am having problem

I took my Access 2000 db in to a school last week as a demo.
The V.P.'s notebook was using Access 2003.
Access 2003 complained when it tried to load the .mde file, prompting
for this that and the other before outright refusing to load the file.

I wrote a routine for somebody yesterday.  When I compare datStart to
datEnd in the DoWhile comamnd, when the date/times match they don't.
For example, 1:00:00 PM does not match 1:00:00 PM.
I guess this may be due to precision, or imprecision, of the value

I have a query that pulls information for a report. Sometimes the report is in
tact and works wonderful; other times the report gives me a syntax error. The
information is only different in one field where - (dashes) are used to
hyphenate Primary ID's for Animals.

i have a question regarding the DateDiff function.  I am quite new to access
and seem to have hit a snag with this function.  My problem is as follows:
I have a table field that list a persons DateOfBirth. The standard format
for this field is yy.mm.dd (ie- 73.02.01). And on the ...

Thank you in advance for any and all assistance. It is greatly appreciated.
Is there a way to know which form was navigated from when opening a form with a
command button, and then to renavigate back to the same form? I'm currently
using a macro that navigates back to a Main Form, ...

I have an issue that's driving me batty!  I have a report, whose record
source is SQL based on a normalized set of tables.  There are no nested
queries and no dlookups in this record source.  When I run this record
source on it's own, it functions normally with no errors.

For the 2 weeks or so, I need to keep one mdb, in which I am working on a
project,  in sync with another mdb in which I need to make ongoing changes.
At the end, I will take out the old mdb and install the new one, so the new
mdb will contain the new project, plus all of the ongoing ...