My ultimate goal is to be able to completely map out an Access db: tables,
queries, forms, reports, macros, modules with all the included
controls/properties/VBA code. I can dig deep into these top 6 objects within
a db but this requires the code to be included in the db I am ...

I have a button on a form that saves a report based off the data in the form.
A dialog box appears for the user to choose the file type but I can't seem to
force the save dialog box to pop up for the user to choose where to save the
file. Any suggestions?   - Thank you

i have an acces table consisting of ~3000 rows. i would like to calculate a
rolling standard deviation/kurtosis/skew and a slew of other excel functions
over 20 days. i am aware that i am able to call excel functions in ms access,
but as there will be 2980 calls for each function ...

I have an access 2000 database that I created on my work computer (has
microsoft access 2003) and has a form with a command button to open a
microsoft word file. This works well on my computer at work (has windows XP;
microsoft access 2003 and word 2003). I transfered the file to ...

Hello and thanks in advance.
I'm using the ShellExecute API to open a text based file for the user to
view.  I was wondering if it is possible to halt the vb code until the file
is closed (perhaps a dialog or modal mode?)  I've done a quick search on the

I have an image of our office layout in a report. The idea being I would
place text fields on the report with names that correspond to locations.
D-1, D-2 etc.
Then in the employee table under the location field I see a value of D-1 so

Who knows the solution how to get the result between two times, in access 2007.
For example:
The job started at 10:00 field 1
The job ended at 13:11 field 2

Is there a way to query column names in a table and  store the column names
in another table?
Thanks,
Ron

I have a form that has a combo box field with about 15 selections.  Also on
the form I have a tab control with 15 sheets titled with the same names that
are in my combo box.  What I 'd like to do is code that would open the
specific tab control sheet after the combo box is ...

I am new to Access but wish to have a variable, UsrID stored upon startup.  
This variable would then be used to record who created records, updated
records, etc.  I know how to get the Usrid from the network, but where do I
call that code so it is run at opening of the file and ...

I want to know if the below code will work. I am trying to compare
times to get a shift value in a text box.
   Select Case Format(Me.datTime.Value, "Medium Time")
       Case Format(rst!Shift1StartTime, "Medium Time") To Format(rst!

I am trying to figure out the best way in VBA for Access to open a text file,
look for specific records and change the data in specific columns.
Does anyone know what the proper functions would be to use here?  I looked
at OpenTextFile, however, using that I would have to read the ...

dear friends,
table [ invoice]
fields [invoiceid]  number
 "     [date]        date

Access 2003 (SP2)
I'm working on creating some custom commandbars using VBA (I had to do this
recently while working in Excel because I could not figure out how to create
the toolbar as a popup using the View - Toolbars - Customize dialog box).  

There seems to be a default limit of 50 characters per element in string
arrays.
When I try to move a string longer than 50 characters into a string array, I
get error: