Is there a way that I can sort the results that the
records are returned when using CurrentDb.OpenRecordset
("MyTable").
I have a field in 'MyTable' that I want to use to drive

Need a Cell, which will start at 1000 change every time I re-open the file to 1001, 1002 and so on
Could someone help me write what I beleive is a MACRO? [Office 2003]

I have created a data entry interface for a database I've
been working on and am trying to create a macro that will
compile only the data just keyed to export into an excel
spreadsheet for use in tracking productivity.  I tried a

If someone knows a link to a good url, it will be fine to start
= = = =
Today I still use dbase4,
but I know Excel, Access as user

I've used the following code in VBA for years, now it export the data in the incorrect format, '17.' instead of '17.25'.  I'm losing the precision on all the data.  Also integers are being exported as '482.'  The only thing that has changed is that I've run the 'recommended' ...

I have created a form and when you click on a button, you
print the required report. However there is a error
message whenever i do this.
Thanks a lot,

I'm trying to do a square root and I want the value of that calculation to be displayed in a text box.  I'm using values in 4 other text boxes to do the calculation.  Below is what I have and it's not working.
Private Sub Command79_Click(
Dim mysqr As Doubl
Dim dp As Intege

I have a form with a check box.  When this check box is checked I want it to print a document (an Adobe PDF tax form).  I am trying to figure out how to write a macro to open and print a form that is not a db object  but a file location or how to write the VBA code to do this.  ...

im sure this is very easy to do but im not very good at this yet, i
rather noobish. im trying to get a macro to run as soon as the dat
base is open thus avoiding the ms access interface and going straigh
to forms etc. any hellp would be of great help, thank you.

I have a Form generated by a Query which has a "Modified
Date" field (last date record was modified).  
I generated a SetValue with:
Item: [Forms]![frmADDRESS]![dtmDateModified]

In Access 2003 when I'm running a macro and it makes changes, closes, etc. a
table it always prompts for a yes/no.  How can I tell it by default what
should happen at each point?
Raphael

How can I get the user name that was entered in Access security for us
in VBA?
Thanx in advance,
Dave Urba

How do you assign a command to ALT+F11 (or ALT and any key).  I know how
assign CTRL P which would look like ^p and SHIFT+ F1 would be +{F1} but I
can't find what the key is for ALT.
Thanks.

I have a form with 2 nested subforms(a form with a
subform (first level) and a subform (second level) within
the subform (first level)).  I would like to move the
focus from the second level subform to the first level

OK, I have no more hairs, left, so its time to ask for help.
Seeminly a very simple task, is escaping me.
Here is what I have:
An Excel Table