I have a mainform and a subform (these two forms are NOT linked).
When a selection is made on the main form, it gets added to the subform (the
subform only lists very basic details).
What I am trying to do is when the user double clicks a record in the

I'm getting the Error #52, Bad File Name or Number.
FileCopy "C:\PROSERV\DB\Restore.mdb",
"C:\PROSERV\BU\Format(Date,""yyyymmdd"") & "".mdb"
The file defintely exisits.  Could it be the format part thats not right.

I want to name a file with the contents of a Text Field.
It's a date.
FileCopy "C:\PROSERV\DB\Restore.mdb",
"C:\PROSERV\BU\Forms!frmFXEOD!TxtBizDate" & ".mdb"

Hi, and thanks in advance :-). Maybe I did this the wrong way, not sure. I
have a form that pops up when I open the database that sets a default value
called MarketID.
The user chooses the market from a form and when they click the command

How do I do a DATEDIFF calculation but ignoring Saturdays and Sundays?

Graphic styles from Access 2003 to 2007 seem quite different.
Is there a way to configure Access 2007 to use 2003 styles?
Some other way to convert form styles (graphics) between them?
Thanks

I have received a request to hide the checkboxes next to record where the
'Form name' field contains the word 'Divider'.  I can do this if the Form
Property for 'Default View' is set to 'Single Form', but my code to hide the
check boxes hides check boxes for every record (in the ...

    When my Access 2000 report is exported using the "Publish to MS Word" tool
button, it seems to lose important content like lines and other graphic
elements, as well as formatted text objects (which Access treats as embedded
OLE objects). I'm having a lot of trouble creating reports ...

Let's say I have two items on a form, a combo box with a pre-established list
of items to choose from (named "Title"), and another combo box with a list of
integers and a blank (" ") as selections (named "Survey").  If "Survey" is
blank, the user can enter any text he wants into ...

I have a search form used to look up records based on a number of entry
fields.  I have, with the help of this forum, created successful searches for
all of the text like fields, but I also wanted to have a "# of weeks back"
filter as well.  My crrent code is:

What would be the typical approach to building
a search function?
I would assume that, unless there's a built-in facility
that I've not had an occasion to encounter, that one

Some kind of zen thing in Access, maybe?  I'm calling a procedure with an
optional paramter.  I'm NOT passing that parameter in the calling procedure
and therefore the object should be "missing".  Access returns False from
IsMissing, IsEmpty and IsNull, and of course I then get ...

I have a program that is running fine on a Access 2003 pc but will not
work on a Access 2007 pc
When I press the command button nothing happens
The only libabry change on the access 2007 pc it to  Microsoft Access

This works fine if table2 is located on the same computer.
This is a front end, with 2 back ends that are linked together.
But what happens, or how is it coded if table2 is on a different computer?
Thanks

When I have a seperate Front end for each computer and one Backend
located on the server, how do I link all of the seperate front ends to
the server backend?  Do I do each machine seperately?
Thanks