How do I Accessing a windows user id from a VBA event in Access 2000 ?

I have a ADP that formerly supported "autocomplete" in combos. I had to
import the entire project into a new shell because the old one got corrupted.
Now autocomplete is not turned on. Where is the switch for this?
Maury

I have multiple clients that have an MDB.  The MDB has the same tables but
some of the queries, reports and macros are different.  I'd like to create
one master database with all the objects.  Do you have any suggestions on the
best way to organize this mess?

I am using Access 2007.
I am trying to access an Access 2007 from within Microsoft SQL Server
Business Inteligence Studio.
I do not see a Ole-DB driver that supports Access 2007. If i use OLE-DB

I have a table with 3 fields, AccountNumber, Security Number, and LotShares.
I would like to create a query that calculates a running total of lotshares
by security by accountnumber.
Multiple accounts will hold the same security.  Within each security held by

I'm using VBA to export data from a table direct to a CSV file
 DoCmd.TransferText acExportDelim, , "ExportTable", filePath
this produced a file with COMMA separated values, until...my computer
got fried and the repair shop re-installed Windows XP in French (I

I have a database with a main table containing records of issues and a linked
table containing attachments to the records in the main table.  The
attachments are embedded OLE objects.
I have an entry form for the issue records that has a subform displaying all

How do I set up a cell to be 0.0 (zero) if there is no data available??? I
know is on the Validation Rule, but I don't know the formula.
I can't add the values of other cells becasue there are a few empty ones.
PLEASEEE HELP!!

I have a main form created which has a subform allowing multiple inputs of
Trustee names.
I have created search form which has an unbound box used for the search on a
unique ID on the main form. But what I need to do is be able to search by the

I am using the criteria <=#9/14/2007# in one of the columns and it's not
pulling up all the entries older that 9/14/07???? Please help!

Can someone please help me.  The trick to this one is eluding me.
I have two tables that I need to combine in access.   Both tables contain
the same basic information, but I need to print a report to see what the
amount differences between the two tables.    The only thing is ...

How can I repair a system error that reads the following: the windows logon
process system process teminated unexpectedly with a status of 0x000000
(0c00000000  0x0000000).  The system will be shut down.
I had some work competed on my computer but when I got it back this is what

when sending a single picture from a file the recipient is getting all my
pictures in the file. I have 10 pics of buildings in a file, I send 1 but all
10 show up. Also some times the recipient gets my pics and they are huge

I'd like to know why my Form does not remain or open in alpha order.  I would
sort and save it but when I re-open, data is in random order.  I've tried to
do this with the table thinking it would help.
Does anyone have an answer?  Thx

I am importing data to Access that has a 'Weeks' field containing number
ranges, eg 3-5,7,11-13,17. I need to then use this data to create a new
record for each of the weeks so in this eg I would end up with 8 records -
one for each of weeks 3, 4, 5, 7, 11, 12, 13, 17.