I need your help with the date. If a date is given (for example the current
date), how do i work out in VBA for Access database that it would give me the
last day(friday) of the next week?
For example today is 13-Feb-2008, Next friday will be 22-Feb-2008. It'd be

I am new to access , and I am looking for some code that will create a
switchboard tree view that will be populated of all the forms I have and
clicking on the tree view item will take me to that form.
I have seen that before so I think the code is online but I could not find it.

My database data entry forms have the navigation button property set to no,
however if a user uses the scroll wheel on their mouse, they can view
previously entered data which I can't have, it will compromise my data.  I
have a form for changing data that retains the integrity of ...

I'm building a Preventive Maintenance database to record PM on our machines.  
On my PM form, which has no Record Source, I have a number of combo boxes for
the user to ID his machine.  When the user IDs his machine a subform appears
with its PM tasks and a control to record any ...

I am trying to work on a app built by someone else.  There is a button for
uploading an xml file.  When I click on this button Visual Basic Compile
Error comes up that says "User Defined Not Defined" it then highlights the
following line:

1-How can I use VBA Code To Copy (Ctrl+C) any think.
2- How can I paste the result on specific place on my H.D like D:\  (by VBA
Code)
Step should VBA Do

Re: Access 2003
I inherited an Access app (developed by an end user long ago) with objects
having no centralized uniform naming conventions.  Some of these objects have
spaces, some have dashes, some even have slashes across various table names,

I hate to admit to being so clueless, but how would I go about
programmatically assigning an object (in this case, an emf file) to an OLE
field? I can determine the path to each record's emf programmatically, but I
am stuck as to how to "insert" it into the OLE.

I need to compact and repair shared database file. The database is in use all
the time. I have a routine that identifies current users, but I still need to
run across large company to ask them to log out. Meanwhile, other users
login.:-(

have a table with fields (Id primary key) and (d_object OLE)
The field d_Object contain (data base) as OLE
Dear all I want to use VBA To Copy OLE from the table and put it in specific
place on my H.D (D:\) for example

I forget how to do this every time.  I had it set and then they swapped out
my PC.
How can I display the "tips" that appear under what I'm typing in for code.  
For example; I type in "DoCmd." and then a list appears of options, or when I

I need some serious help with VBA. I am trying to get multiple records into a
separate table in one field. Here is my example:
Table 1
              Request Number    Product            Product ID

Good morning,
I having a little issue and I'm hoping someone can give me a simple solution.
I need to control the formatting of input data as it is being taken from
another source which is uncontrolled and I can't make changes to.  As such, I

I have a form (master form) and sub form
What I want
I want to  put a button in a master form to change the view of the subform
from data sheet view to single form view

i would like to print to pdf via the docmd.ouput command. is there a way to
supress the dialogue box, and have it print without interruption