i have 2 Date Time Picker control where i fill the firstdate_var and
seconddate_var.
I have a Add button and then start changing the date from both Date Time
Picker.

I'm developing a VSTO add-in for Access using the PIA for Office 2003. There
seems to be a distinct lack of events in the Access object model - the
'Application' object in particular. The only events I see documented for
Access relate to forms and reports. My add-in needs to ...

I have a database that I need to calculate someone's chronological age for an
appointment date, does anyone know what the formula would be

i have a problem with the use of Null
I have a table that has allready 10 records for testing purposes.
Everything was runnig Ok.
Delete them all to start on the real world and when i tried to add the first

I'm doing a very simple form,
I need a combobox to be visible after a selection is made in the previous
combobox
my code is:

I have a table of users assigned various projects. normally a user is
assigned multiple projects, and for that, multiple entries of the user
is created within the table, with ofcourse the unique names of
projects. eg:

I have a subform used as edit for data selected on a listbox in main form.
The data is displayed on subform when I select one record from listbox. Data
changes are saved when I select another record from listbox. But the values
displayed on listbox is not refreshed untill I click ...

I'm trying to update an mdb file that contains tables linked to my current
mdb - by renaming it, and then replacing it with an updated file.  Access
won't let me rename the file, I assume because the links exist.  I tried
deleting all the links, but Access still refuses, I guess ...

Please help me with the following code. Every time it runs, it stops halfway
through and gives me a runtime error. The .mdb size goes from <100 MB, to
over 2 GB, which I believe is the source of the problem, but I can't figure
out why since all I'm doing is attempting to fill in ...

I am attempting to dynamically change the background color of a subform from
an event in the form.  I don't seem to be able to do so.

Howdy fellas. I'm working on a code in access. What I'm trying to do is allow
people to Save a file from their documents and automatically save that file
in to the common drive folder.
Right now, here is my code. This code allows me to get the path of the

I am using the search form and I love it, however, i am trying to search 24
fields now and as soon as i word wrap in the visual basic editor window it
doesnt work....
If Not IsNull(Me.txtsub) Then

I have an Access form that sends data to bookmarks in a Word document.
The command button that sends the data to Word also activates code
that adds a "next number" to the form. The number comes from a single
record table "Make Next Number". That number also appears on the Word

Hello again, I have run in to another problem. I now can save documents,
whether its excel, pdf, word, etc in to a common folder. But now I want to
set up a listbox where they can double click on the item they want and it
automatically opens up the file.

I have a table with client info.  There can be more than one record with the
same address (different clinets living in the same address)
In the "Contacts' table, I have the follwoing filelds (amonth many other)
- ContactID