I am working on a database which includes a routine for importing
sales data. The data includes a "Week" field, indicated to which week
the data relates. This is a text string in the format of "2007-13"
then "2007-14" and so on.

I am looking for some visual basic to take a list of file names
(pdf's) in an excell spreadsheet or access query output and use that
list to cycle through a folder on a network drive containing the
referenced pdf files.  If the filename in the output equals the

I'm getting this error message on one of the database but not on the
other. "You cannot add or change a record because a related record is
required in table <name>. (Error 3201)"
Both databases have similar relatioships/design so I dont know why

Every time I try to open an attachment from someone who does not have Vista I
get symbols and numbers which make no sense.  When I send a document to
someone who doesn't have Vista they can't read my attachment or it is off
format.  Is there a download I can install to fix the ...

I have created several DB in Access, and on occasion, I have subforms that
may have mult records, thus the one to many relationship. When I create a
report, I want the report to read like a paragraph, with the mult records
separated by commas. an example would be a family who has ...

Periodically, I need to show confirmation/status messages to the
user.
Things like:
------------------------------------------------------------------------

how can i download or buy cd for my  linksys wireless-g usb network adapter
ver.4 thanks for help

I have a number of records that look like chinese caused when staff open the
same record at the same time. I have tried setting the locks etc but still
get the occasional one.
a) how do I stop staff going into a record already open &

I have windows vista installed and only microsoft access 2003. the
application has worked well until suddenly after i did some editing with the
database design, it gave out message "Microsoft acces has stopped working".
Then it restarted itself and prompt me to save a backup. ...

I'm using the "AllowEdits" to lock records so they can't be edited unless
it's a new record. I also have a combo box on my forms header that I use to
search for records. When I have the "AllowEdits" set so records can't be
edited it also locks that combo box as well and users ...

A couple of times I've 'redefined' reserved words such that I end up
corrupting my database (Access2K).  For example, I set up a query and set a
field's name to 'DESCRIPTION'.  From that point forward, Access thinks I'm
referring to the 'DESCRIPTION' as opposed to Description (as ...

I have created a relationship between two tables in access 2000, but once I
close the realationship window and reopen it, the relationship isn't there.  
But if I create a query on these two tables in design view I see the
relationship.  Is there a way to see a list of all the ...

A mysterious yellow circle with red and blue arrows has appeared on some
shortcut icons to forms in an MS Access database.  
I've never seen this before, but if I had to guess, it appears to be
something with synchronization judging from the arrows.  A screen shot can be

I'm getting this error message on one of the database but not on the
other. "You cannot add or change a record because a related record is
required in table <name>. (Error 3201)"
Both databases have similar relatioships/design so I dont know why

Hello - I have a table of email addresses - I only want to see unique ones,
not duplicates.
Can someone please tell me how to set up the query??
Many thanks!