I have a report named rptBrian, which is run with a command button
cmdreportBrian. (Access 2003 user).
This report is based on a query named qryBriantodo, which is a subquery of
the query qryBrian1

I am having trouble with the following
Private Function Calculate_Charges()
Call Lookup_Charges
TransType = Me!TransType

I'm dynamically creating a form - in code - that contains several
labels with bound SQL Querys and modules. I have all of this working
just fine except for one item.
I want some of the querys to have subdatasheets. As I understand it

I'm fairly new to this stuff, so forgive me if I ask the wrong questions.  I
have an online database app that is submitted to an access database.  What I
want is when a new request is submitted, an automatic email is generated and
sent to multiple persons with that record as an ...

Alright, I have the dumbest question.  I want to do something, but I don't
know what it's called.  So I can't look up an example.  This is such a moron
thing to do, but I'm hoping someone can help me out.
I created a user defined variable, and what I want to add is a function for

I am trying to insert a numeric value into a field on a form via a sql query.
The query totals up all the cost fields asociated with a particular record.
The query say brings up a figure of 400 but i cant get this figure to insert
into the form field.

I have a recurring problem with a database I'm working on.  I have all
breakpoints cleared and saved.  However, occassionally, the code will stop as
though a break was there; usually where the most recent break was located.  
Now, if I am working on the DB and have this happen, I ...

I'm inserting values into a table using: CurrentDb.Execute strSQL,
dbFailOnError
Everything works fine, except when I'm adding a string value that sometimes
contains the single-quote.  ie. someone wrote "didn't"

This sounds like it should be straightforward, but I cannot find any way of
doing this: put simply, I wish to bring a specified form to the front. I have
an Access app which has a client list, alongside the entries of which is a
'get record' button. When that button is clicked ...

I have a long list of numbers and names which I imported from a .pdf file.  
In the .pdf file they were a single string.  After stripping off unprintable
characters and separating the numbers and names with a query, I want to use
each name for a field name in a separate table.  My ...

Crosstab queries (perhaps among other sorts of queries), do not have a Filter
property.
But create a form with a subform control, and put in the SourceObject
Property of the sf-control "Query.MyCTQuery" and you can do a filter-by-form

In a vb collection, I would like to retrieve the key of each items.
Example  :
dim col as Collection
col("k1")="a"

I must be missing something but I am not finding a way to check a value of a
variable for "Nothing".  In my case, I have optional params to a procedure,
and I would like to know whether a given param was specified.  Teh param is
of type "Control", so it gets assigned "Nothing" if ...

I am extremely new to programming so please excuse me.
I have numerous fields on  a form ie Client Name, Street Address, Suburb,
Post Code etc and I would like these fields to automatically fill in to a
sub-form when client name is selected so it can be merged to different types

can someone help me out. I'm trying to generate the VBA code for next problem:
With the Update event i try to generate a number out of a date and folowup
number. The dates and numbers are stored in a seperate table.
When starting the event (after update) i would like to look into ...