In the online Help for Visual Basic, there is the following example
(I've removed some of the code for brevity in posting here, but not in
the example I'm running).
Sub FieldX()

I have a field called TransNo in a table I want to use as like a autonumber
but to format it with the field TLPrefix in front of the number and to number
per ProjectID.
TransNo should be max number for the ProjectID in the table and add 1  and

I have a report with a sub-report and that also has a sub-report
Both sub-reports are in the footers of the upper report
Like this
In the Main Report footer is the Sub-report 1.

I hope someone can help because I submitted a request to Microsoft and they
redirected me nowhere!
How do I use a variable to reference a column in MS Access? I am trying to
write code and want to assign the column name via a variable so I can set the

Okay, I have a tricky query I need to run, and I am sure there are several
ways to approach this.   I have a field called DataCollDate (which is both
date and time) and another field with temperature and wind direction.  What I
am trying to do is calculate descriptive statistics ...

I have created a form "Proforma" & a subform "Proforma Subform". In the
subform, in the Form footer, I have a control box "Total Cost" that sum up
the amounts from filed "cost" of the same subform. In the form I have a
contol box "Total Euros" that is updated from the "Total ...

free

I'm fairly new at this, so hope this isn't a dumb question.  I created a form
with just a couple of fields on it and now I want to add additional fields,
but when I click the Field List to select the desired fields, there is only 1
field shown.  Why can't I see the other fields?  ...

I have just installed Office 2007 on several PCs in a remote office.  They
are having issues with opening access databases on the server in the main
office.  Nothing on the network has changed and the databases open up fine
when using Office 2000.  Any ideas as to what could be ...

How can I email to a group without all the members of the group seeing who
the other members are?
In the "TO" box I would like to put the name of the group, but not the
members names.

How can I default a field in Access to equal the name the user is
logged in to the Windows server network as?

I have a database at a client's office, called ahhh... dbMyFE1 as a
front end linked to a back end called dbMyBE.  Works as designed.  No
probs.
I've brought a copy of both into my computer, made a few small changes

Greetings all,
 I hope this finds everyone well.   I am creating a contacts Database for
my Church and I was wanting to get some advice on a table structure.
I have a table called Contacts and it contains the following fields

vedemo se funsiona
me auguro

When attempting to delete a record I get the following message:
"Invaild Outside Procedure" on (conMESSAGE)
This was based on the below recommendation:
"Ken Sheridan" wrote: