I have created a database with an  MS SQL (2005) backend and an MS Access
2003 front end.
It is used by about 150 users. What I would like is a way to populate a
field in any of the tables that will auto populate with the user's user ID.

I want to populate a listbox with a list of files from two directories.  How
would I do this?  The Directories are
C:\PROSERV\BU and C:\PRORED
Any help appreciated.

is it possible to create a combo box displaying multiple columns if the data
type for one of them is "Memo"?
thanks in advaance,
mark

Problem: 2 users appear able to insert the same (unique) primary key to the
same table.
I'm attempting to enforce single-threading of a process by inserting a
record to a table. All users use the same primary key so only one

Hopefully  I can explain this clearly but here it goes. I have created a
database and imported all my clients information into the database. I am
running a bussiness that has been growing and busy dramatically.
When a new or existing client comes in I print out an application form ...

I have a form where I track custody of wood.  The client enters a
registration mumber which pulls up the associated company.  The numbers are
now alphanumeric and when I changed the table entry from number to text the
form no longer recognizes the either.  Here is the code:  Any ...

What exactly does this return, it's been awhile and I've seem to have
forgotten.
I'm using it to check a path if its valid.  I keep getting INVALID PATH
even though I know the path is there.

I use following code to open the form.
The form is opened, but it is in the back.
Are there any way to make it in the front?
Your information is great appreciated,

using Access XP.
Stundet at the school I work have to fill out an instrucotr's evaluation, i
disabled the [Close] button on the form and I hid the menu and icon bars, no
problem here.

I have a form with a checbox "Done" and command button "NotDone" with
following code:
Private Sub NotDone_Click()
Me.Filter = "Done=0"

I've not been able to find in the external
VBA file support where I can update the
file attributes, specifically "File Blocked".
Windows Security released a security

I have a main form containing client ID and town and a subform containing
session ID and date.
I want to search for clients who have had a session in a date range, count
the number of clients and group them by town.

I have a table the list items across Columns
Example
Column  Heading      Mill-out        Shop Drawings     Cut-out
Row Data             80             60                40

This has probably been answered many times before but my searches draw blanks.
My main form has subforms, but subforms don't seem to filter too well, so...
I have a button on my main form (form1) which opens a new form (form2) which has a view of 'all' the db records - this enables ...

Is there no way to block some of the spam that seem to be getting into these
newsgroups?
It seems to be getting increasingly worse.  More and more garbage which
makes it harder to see the real questions.  Are there any solutions.