This is my first time to develop database application using ms-access so
please consider me as a beginner
I need to know 2 main things
  - how to get value from query and assign the value to a variable in VBA

wrote update SQL last column ok when .runSQL then when breaks out of sub last
value dropped back to original.  code below
Private Sub Command8_Click()
On Error GoTo Err_Command8_Click

Thanks in advance.

I want to use the network Username as default value in a table. I have a
function defined that returns the value, but Access does not recognize my
function as valid.
The expression builder does not show my function in the list of functions,

I have about 80+ tables that need to be imported regularly in to a new
database, from an existing database that has 200+ total tables.  Using
the manual import and selecting 80+ is a pain.  The tables, that need
to be imported start with either X or Y.  Could someone please provide

When a form with an embedded subform is switched to Design View, sometimes
the actual subform is displayed, and other times just the outline of the
subform.  How do you control how the subform is to be displayed?

I'm using the ACG PDF and Mail add on.  If anyone is familiar with this I
would appreciate some help.
I'm looping through a list of customer names on a report and making a new
pdf for each customer so I can email it to each of them.

OK, I am stuck.  I had the following line of code that was working.  My
computer was replaced and I was able to run my program once but now I am
getting a "Type Mismatch 13" on this line of code:
lnglastrow = xlSheet.Cells(xlSheet.Rows.Count, "A").End(xlUp).Row

I converted an Access 97 database to Access 2003 and get an error that there
is an "Undefined Function 'Mid' in Expression".  This also happens when I try
to use the Expression Builder to create a simple Mid function in a Query.  It
worked fine in Access 97 and seems to be a ...

I am using someone elses formula, but they have used the following brackets
i.e. { }. What do they mean?. When I come to amend the formula the brackets
they disappear and the formula stops working.  I don't understand why they
are there and what the difference is between the ...

I need to get an answer how to combine a nr. field and a textstring in a
textbox inside a report (Access 2002)
What I like to do:
Ex:

I have a form that uses command buttons to changes the look of the form; for
example, if button “A” is clicked, the form changes and only those fields
associated to button “A” are displayed; if button “B” is clicked, the form
changes and only those fields associated to button “B” ...

I got the following code from Paul Sadowski's web page.
Dim objMessage as object
Set objMessage = CreateObject("CDO.Message")
objMessage.Subject = Me.Subject

how can i access a specific folder on a drive, pick an excel file, and then
move that file to a generic excel file via a menu button? the generic excel
file would be retrieved via an import query.

I have: Tables suffixed by the year (e.g., tblCustomers2003,
tblCustomers2004, tblCustomers2005, ...)
I want: to get the name of the table with the latest year.
Application: Access 2003