I see this question comes up all the time, but I still haven't got it right.
Users want to update a Yes/No field (VolLet)  on table "TREG" a record at a
time  by clicking a command button on a continuous form (FVolLet) which is
based on a non updateable querry(Group by with sums ...

The GetObject method seems to intermittently fail in Access 2007 Beta 2.  A
code snippet is below:
Dim oApp as Object
Set oApp = GetObject(“C:\Example.mdb”)

I have a module set up to export a query to excel and parse the data into
various tabs.  Works great, when go into the module to run it.  I want to run
that module from an event procedure from a form. (on click from a button)
I see that some have refered to a "Call" option, but ...

I am using FTPCLIENT.
I can Logon to the ftpserver.
I can change dir on the ftpserver.
but when ever I try to 'FTPPUTFILE" I get the following error.

I'm creating a report in Report Generator that pulls across
multiple tables. As many as 8. When I get to the sixth table, it causes the
links to come up with an error. 5 tables is fine and everything links
correctly, when I add the sixth, all the links on the report #error

Which binary contains the NZ Function for MS Office Access 2003?

Hello, I have been having great luch with this project so far.... you guys
are great.
New question..
I have build from scratch a contact database using a sub form to keep the

This is hopefully an easy one to answer, but I cannot find what I am looking
for.
I have a function that writes data to a text file (makeflatfile). Can I get
the function to allow the user to enter a starting and ending range of

I am using the code below to fax a PDF from Access.  This all works fine
except that it leaves Acrobat Reader open after it has finished.  Could
someone please advise what I need to add to close Acrobat Reader.
   Dim objOutlook As Outlook.Application

I have a Select Query that gives me the desired results.
I know I can click on Office Links and output the query results to Word -
"publish it with ms word"
I think that the button uses DoCmd.RunCommand acCmdOutput to RTF

Ok, try not to laugh.  I have two dates in VBA, I wish to find the years
between them using the datediff function.
date1 = #1/1/2000#
date2 = #1/1/2005#

I have (2) combo boxes and (1) text box set-up to filter out my form.  I am
using the following code.
Dim strWhere As String
Dim lngLen As Long

If I have a 'pot' of numbers 1-50 say, how would I select each of these
numbers at random until they have all been used up?
(I think I know the answer but would like a professional opinion :)
Cheers,

Is it possible to give a Treeview control a Shortcut menu?  I cannot seem to
find the property....
Thanks.
Steve

Hi everybody..
I have two questions.
1) I just want to learn whether it is possible or not to create
subdatasheet, if my tables dont have primary keys? If there is a way how can