I am very confused - am working with Access 2007.
Yesterday - I created form with 2 levels of nested subform - and referenced
the controls on both from the top level, and it worked fine. Code extract as
follows:

I have a function checking two controls Saldo and Stock. Sometimes  one of
the two controls may be empty, having no figures in it.In this case I want to
give the command to exit the function.For example, when the control stock is
empty, I get the following message :

I have the following code:
strsql1 = "select * from los_service where (los_service.los_service_date =
#" & Forms!frm_administration_menu!rpt_date & _
             "# and los_service.service = 'PRAG') or

In a report I am trying to get  a count of each group in a field, without
using groupby in a query builder. I trying to creat an experession in control
source property of a control in the report. Using the count function, I get
the total count for that field. I need to be able to ...

I don't have Flexgrid nor Datagrid ocx. What I want to accomplish is this:
Having 3 buttons, one named Concluded and the others I don't need  to explain.
When I click the Concluded button, it passes 4 arguments thru a query into a
recordset:

What code can I use to detect whether the first 3 letters of a string are
upper or lower case?

I thought a simple sub, such as the following, which I found on this DG,
would allow me to copy/paste the results of a Query to an Excel SS:
Private Sub Command1_Click()
Dim stDocName As String

I'm trying to make a function work found on-line.  My module looks like this:
Option Compare Database
Public Const SW_Hide = 0
Public Const SW_Minimize = 6

How could I parse the name of the caption to the message box ? For example,
if the caption of the control is Paris, I would like to insert the caption in
the message box and the message there to read “There are problems with the
warehouse in Paris”

I tried posting this in the MSDN discussion groups, but received no response,
so I thought I'd try posting it here.  I realize that this is, perhaps, more
of a VB question than an Access question, but I thought someone here might
have some experience with this.

I have a user that does not have any Office products loaded. I install Access
Runtime 2003 when my software is installed and use the following code snipet
to check spelling, however I am able to enter misspelled word and the code
does not catch it.  I have tested on machine that ...

I have a field, calculated  in a query, and I want to write a report
to show "Sell Thru Pct", Descending.
Query runs fine, UNTIL I put the sort in -then I get "Expression is
typed incorrectly or too complex....Simplify....."

I have a program in VBA in which I tried to run an SQL for which two
parameters (text) are entered by calling for them from the 'criteria' field.  
I also want to use those same parameters as the front part of the name of a
file to save.  However, no matter what I do (Public, Dim, ...

I have created an Append Query (qryAppendTests) that looks like the following:
INSERT INTO tblQueue ( REQUEST_NO, REQUESTOR, DUE_DATE, TEST_TYPE, CYCLE_NO,
TEST_ID )
SELECT tblTest.REQUEST_NO, tblRequest.EMP_ID, tblRequest.DUE_DATE,

I have a simple flat file database of a questionaire of about 130
questions/variablea. I need to a report with the frequencies, mean, median,
mode, min, max, range, standard deviation etc. I thought it would be easier
if I could code VBA  to create functions for each of the above ...