I am a bit new in ms access. Can you help me create a code so I can filter a
particular date of the database "from this date" - "to this date" method
avoiding the use of parameters. Actually, what I just want to do is to filter
a particular MONTH.

Hi all i need help using 'Format'. when ever i use format in my codes example
below:
Me.Lodgement_No = Format(fpart + 1, "000") & "/" & Format(daynoW, "00")
If i try searching in the field for the string created, it dont come up in

I've just finished the first phase of my database and want to create an MDE
file so others on the network can use it whether or not they have access.
When I try to create an mde file I get the error message "Access cannot
create an mde file."

Isn't there a docmd command that will force an edited record to be updated
(ie, changes saved)?
I have a form where a user checks off which records are to be processed,
then clicks a button to proceed with the processing.  Problem is, the system

If anyone can help out here I would like to know if it's possible to run a
qry within a database at a set time every day.  
Would the database need to be open and the script to be written in a module?
Or can a .vbs be set to run at the shceduled time in the Windows Task

I am working on upsizing our MS Access application to an adp.  On only one of
the forms am I having problems:  I can update and delete records, but when I
try to insert a record, I get this message:
   Invalid input parameter values. Check the status values for detail.

Hello.  I need to change the following to first check where the Access
application is depending on if it is 2000 or 2003.  The 2003 would be in
C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE, so I would need a
DIR command I believe to see if the folder exists.  My code ...

Hello,  I have a query that has all the fields required in it.  I then made a
report from that query and grouped it on a field "Processor".  What I would
loke to do is run the report for each processor in the query and have it save
the file as an excel document with the name ...

What code do I write to open the Access 2007 Options form ?

How can I determine in code the machine name and user name that are accessing
one of my databases? I am using Access 2003. Thank you.

I have a lot of text (in memo fields) that contain foreign language letters
such as '&ecute;' (as in Cafe where the 'e' has a pointy thing on it).
My website uses "charset=windows-1252" and 'cafe' appears correct. But on
another website that uses "charset=utf-8" it comes out as ...

I'm currently opening a form to do data entry. The data entry is in two
tables with records that relate.
The tables are Attendee and Registration. On opening the Data Entry I would
like to have the Registration Table have a record created that has a

I hope somebody can help me. Here is my problem.
I have 2 forms.
the first form contains specific data about a person (id-person
(autonumbering field),Name, first name, number, ....)

Hello, I am creating a form where I could input data to my access database. I
also have this "Export" button in my form such that whenever I click on it,
the data on the form would be transferred to a pre-formatted Excel file.
After this, the changes  on the file will be saved, ...

I have a image control on a form. I scan an image into
the control.  This works fine.  What I would like to do
is be able to double click on the image and have it
display in full screen or at least larger than the