Hi I'm using the following code to step thru a recordset.  It works fine but
not in the order of the recordset.
There are 33 records and it goes from record 10 - 33 then 1 - 9.  Can anyone
assist?  It's driving me mad.

I have created a bar graph and I am interested in clicking on an individual
bar and by clicking on that bar it opens form/report specific to that bar.  
Does anyone have a methodology for making this happen. I am using the
SeriesCollection(1).Points(1) to color the bar graphs. But ...

Is it possible to add a reference to a library through VBA if the reference
isn't already added. Or am I wrong here and will the library's automaticly
added to my application on no wether what computer I will run it?

I use thsi code
rs.Open "update tilmelding set behandlet = 1, behandler = '" &
ReturnUserName & "', behandletdato =  " & Date & "   where behandlet = 0 ",
Cnxn, adCmdTable

I'm usually pretty good at calculating dates, but for some reason, I'm
blanking on this one.
I need a function such that it always returns next Thursday's date, based on
today.

I have two tables with a one-to-many relatioship.  Table1 has projects and
Table2 has resources.  What is the best way to show (in a report) for a
specific project all the resources separated by commas.
Thanks a lot.

I ahve this code:
Function hent()
username = ReturnUserName
   Dim db As Database

I'm reviewing the following VBA Reference documentation: FileDialog Property
It gives an example of exactly what I need to do, however, when I type in:
I create a button in my form, and copy the example code:
Private Sub cmdFileDialog_Click()

Hi,
Please help me for this query stuff.
I have 3 different tables. I use query for each table to populate some
fields so that 3 tables can have same fields.

Is there a simple way to save the contents of public variables after the
session is over?  I can store the information in a table, but was wondering
if there is a more direct way to persist the variables.
Thanks,

Is there a way to count the nr of days when reading a date mm/dd/yyyy in a
recordset? for example when reading 09/22/2006 it should put 30 into another
variable. Thanks for any help on this.

i have an Access2003 database that when closes creates a backup of the
backend mdb file. the backup files filename contains the date of the backup
in its file name. for examples  MyDatabaseBackup 01 November 2006.bak
the folder where all these .bak files are stored has to ...

Hey everyone,
I have a really simple button on a form that runs the following code:
   DoCmd.RunSQL "DELETE tblACTT_Basic.* FROM tblACTT_Basic;"
   DoCmd.RunSQL "DELETE tblACTT_Enhanced.* FROM tblACTT_Enhanced;"

I have created a module to send an email from within access using automation.
Everything works fine.
Can someone tell me how to check if the message was succesfully sent after
closing the outlook send message? I want to know if the user actualy send the

First, I would like to thank you all for providing this forum. You have
provided me with more assistance/guidance than you will ever know, and I
appreciate it greatly.
Using Ken Getz's Windows File Open/Save Dialog Box code