I've just upgraded from Access 97 to XP.  It seems that in the VBA Code
Builder I can't launch the Expression builder. In Access 97 a right button
click would pop a menu with the Build ...  selection which launched
Expression builder. I found Expression builder very helpful in ...

I have a combo-box with a list of week ending dates.  These week ending dates
are used to filter a report. The date range from week ending dates from 2003
to 2010.
Is there a way when the combo box gets focus the current week ending date is

This is probably a simple question, but how do I keep the defined value for a
variable and use it in another form?
I have a variable named 'PartNoToAdd' that is set in one form when the given
'PartNo' is not in the 'Inventory' Table. (Set PartNoToAdd = Me.PartNo) I

I need to create a document from an Access record. I don't think I can use a
report because there are so many variables. If certain things are checked it
will be in the document if it isn't i need the document to shift so there
won't be any white space.

I have a field with information in this type of format:  NB-TS-WP-46048 and i
was wondering HOW I could sort based on those LAST 5 numerical digits.  Right
now, it's sorting in ascending order based on the first 2 characters.  
Is this possible?

All please I need your assistant..
this problem is driving me crazy..
I want to know how to set a control value to zero in case its source in some
other sub forms is not avilable. I don't want the control to show me #Error I

I have a replicated A2000 database and 2 users are experiencing this error -
on occassion.  The rest aren't.
The database opens, and the login form opens.  (I created my own user login
table/code).  When the user types in their user name/password and clicks ok

i have a very simple and though complex problem:
i have a table with a date field ([date_field]), and some value
([value_field]). now ia want to create a pivot-chart with calendar weeks on
the x-axis going from e.g. cw 50/04 to cw 5/05.

I am trying to use a spreadsheet object within a form.  My goal is to write
scripts, activated by buttons that will allow me to read data out of queries
into the spreadsheet, edit it, and write the content of the spreadsheet out
to the appropriate tables.

Hi NG,
my second question:
I need to add some data at the end of a memo-field by vba.
Memo1 = Memo1 & "xxxxxxxxxxxxxxx" does not work!

I posted before and got some ideas but I am still struggeling.
The final testing of my tool is a disaster (promised to hand it over on
Monday!)
Couldn't find any code around either.

I am trying to open another Access database/application via a click
button/module on a form. The database opens then executes the set appAccess =
Nothing line of the code and closes.
I am able to open other databases via the module but this particiular

I am puzzled by the fact that VBA append a # at the end of my programming
statement.
Dim val as Double
val = 0.5 + 10000000000# <- the # appended by VBA after the 10th zero (the

Hi NG,
I need to read out the actual user of the access database.
My database is started with /user me /pwd password and I need exactly this
user (me) in the vba code.

I have a table in the database that contains the names of
all the tables in my data base called zztables
Currently I have a docmd funtion that deletes the link to
each table and then after it has deleted the link it then