(Access 2007)
I have a problem with my query which shows week numbers on a column. Week
numbers derived from date field of table. Column has below string:
WEEK: Format$([Table1].[Date1];'ww')

I have some tables in one database i would like to reference from another.  I
have used linked tables in the past, but I don't like the way this will lock
out other developers from using that database.  I thought this should work,
but the list24.rowsource = rs1 line is choking on ...

I am trying to append data from tblitemline to tblitemlist. I only want to
append new records. The unique field is ListID. I want to append 4 fields
total. I can't get it to limit it to new records. Any help would be
appreciated. Thanks!

Using Access 2003 - I have a form with a sub-form. I have a macro with
setvalue to set a field in sub-form with the current date with a double click.
When running the macro I get an error "Access can't find the form "Account
Recon" referred to in a macro expression or visual basic ...

I'm looking for some VBA code that will enable me to verify if the password
entered in a textbox control on a startup form matches the User-Group Level
Password so that the user is allowed to have access to the Database window
(hidden at startup).

Dear Sirs
I have a form with a command button which should preview a report from
another database.
I use the following code:

I have a total of 4 forms, nested...
f0Site, f1Customer, f2PlantSub, f3UnitSub
On the main form (f0Site) I have an edit button that when clicked it sets
all forms for edit.  see below code

If I have a report that has sorts by a location, how can I select when I run
the report to only show a specific location.  If you could please help me
out, thanks.

I have copied the SAMPLE ACCOUNT NORTHWIND and everything looks good except
when I try and raise a 'Purchases Order' I get a message "sorry, you do not
have permission to approve purchases" I have tried EVERYTHING and spent hours
on it and I still can't resolve it - Can anyone ...

I have a database for clients that recieve foodbags weekly. I conduct a query
based on social security number to see if they have a record. If they do, i
only want to change the date to relect the current date in the record and
then save the new record without losing the old ...

I have Office Pro 2003 and I am running Vista. I am having problems creating
and/or opening Reports in Access 2003 for an existing database or a newly
created one. When I request a print of an existing report nothing happens. I
cannot even see the report in design mode. When I ...

cv<svvfs<vadffffbzsgdhfcvvxcv

I have a multi-table query in Access 2003.  Several of the tables have memo
fields.  When I run the query, the memo fields are displayed as Asian
characters or a symbol of a square. There is one expression that concatenates
first and last name and a parameter on another field.  ...

Hi - is it possible to set a form to require a selection from a combo if a
check box is set to true?
I've tried using the validation rule set to the check box name, but it
doesn't work...

I have a status feild that updates as an import processing is running.
The status bar lists all of the imports as they are occuring.
The problem is that the feild does not update while the import is running.
I do know there is a command/function in VBA that I can use which ensures