I need to determine for sure if a particular fie is on the user's local PC or
on the server. I have the complete path of the file, let's call it
FullFilePath
How can I unequivocally determine if this is on the local PC or on a server

I am trying to change the recordset that  my form uses, but when I
requery my form, all of the textboxes display #Name?
Here is what I am trying to do:
 The user enters a search term in a textbox clicks a button.  The

I have a query that combines the results of three related tables. The
memo fields are truncated to 255 characters, but I need all the
information in them. I'm aware that removing code such as DISTINCT and
GROUPBY will fix this problem (as discussed in other threads in this

I have a user request to build a form in an Access database where the user
can check off specific fields to pull in a query.  For example, let's say I
have 10 fields in a table.  The user wants to be able to check off anywhere
between 1 and all 10 fields in a form and have it return ...

Seeking code to ID & print all controls on all forms having a
ValidationRule property set - but no ValidationText property
setting. Perhaps some modification of the following procedure
would do it?

Can decompiling an A97 mdb result in fixing minor nasties that may be
responsible for some premature terminations of A97 (We are sorry. MS
Access 97 needs to close.... messages). I've found the following
recommendation and was wondering if any of you have used the

I need to email query results from Access similar to the way I do in
SQL using xp_sendmail.  What is the best way to accomplish this?
Thanks!

I recently asked the group for help on converting 3 numeric variables
to a new date variable.  The DATESERIAL function below worked
perfectly!  My question now relates to problems with this new variable
when I try to filter either by form or selection.

Hello all, I have a form I designed for data entry. However, when I set
the form properties to Data Entry mode, the form completely disappears
for Access 2000 users. All they see is a white blank space. What could
be causing this? Thanks!

Is there a way to have the labels in a MS access database switchboard
dynamically generated based on values in a table? I have a table of
items (let's call it table Main) , each of which is assigned to a
category. The list of categories is stored in a separate linked table

Hi, this my first post to this group.  I am trying to add a option
group of ture/false and all.  This is on a form, that the results are
displayed in a subform.  When the user select a record from the last
combo box, (I have three combo boxes that filter into the next), and

When I shell out another copy of my database and try to hide it using
the 'vbHide' argument of the Shell command, the new database is
actually maximized, and the orginal is hidden (the correct action
should be the reverse).

I have a report for which I need three copies - identical in every way
except each contains a label (lets call it 'lblReportInstance') with a
caption saying "Part 1", "Part 2" and "Part 3" respectively.
At the moment I have 3 separate reports that I run sequentially and output

I need to write a VB.Net application that will take an mdb file (Access
2000) and create  corresponding copy of it in SQL Express, creating all
the tables and relationships, and transferring over the data (using an
existing application like DTS in SQL Server or something else is NOT ...

i want to create a directory in a certain subfolder, but here's the
catch
each entry in my database is assigned an autonumber
i want to be able to create a new directory when i press a button on