Help, I have a table where the first name has data like:
1.  Mike "Butch"
2.  Rose Marie "Mary"
3.  William " bill"

We currently have two developers that need to create queries and reports but,
in the same database.  Can this be done, what would you suggest to work
around this?

I have a module that inserts records to a tblTime
tblTime
=====
TimeID (AutoNum)

HELP :(
tblTime
 > TimeID (Key)
 > TimeSlot (Time)

I have a module to insert a record to tblTime (TimeID Key, TimeSlot Time)
The SQL statement in the VB Module is:
"INSERT INTO tblTime (TimeID, TimeSlot) values (tmpTimeID,LoopTime)"
tmpTimeID is calculated in the program as 2 (for test reason)

I have a table tblWeek with the following fields:
WeekID (AutoNum)
Mon (Date Field)
Tue (Date Field)

I have the following code.  Most of it was copied from the knowledge base.  
It gets the computername, langroup, username and logondomain.  At the very
end of the code I want to insert the results into a table called tblUsers.  
When the code is run it asks for the details of each ...

I have found a note on how to pass a forms field to a query.
[Forms]![Form Name]![Control Name]
But how do I pass a subform's field value to a query.
I tried [Forms]![Sub form name]![Control Name] that didn't work (I think

I've been using the DoCmd.OutputTo command to simply create a spreadsheet
from a query but it appears to only save as Excel 5 format from Access XP
2002 and I think the only option is "acFormatXLS". Is there another method
to create a simple spreadsheet from a Query without opening ...

Is it knowen that when using the
Application.Run command for calling a excel file macro, that
"SHEET.xls!macro" that the SHEET name, can not have spaces? Ex. "Run This
Macro.xls" vs "RunThisMacro.Xls" . Odd...

When I run the following code, to send a query as an Excel file:
DoCmd.SendObject acSendQuery, "qryFeesRpt", "MicrosoftExcelBiff8(*.xls)",
"DACSS@********", "", "", "Fee Report " & Forms("Assembly Documentation Menu
B").SubjLine, "DO NOT EDIT EMAIL SUBJECT LINE", True, ""

I have a excel spreadsheet called "test.xls" which has a "sheet1" in it.  On
the sheet1, there has the following data.
A1  Peter
B1  student

I have this project where i must read all the files havin a specific extention
(*.mdb for example) in a directory and subdirectories.
I was wondering if that is possible.
What ultimately I am looking for is building a procedure that would have a

I have the follwoing code that return error 3001. Could anyone advice:
DoCmd.Hourglass True
zz_ProjectID = Me.ProjectID
zz_StatusID = Me.ProjectID.Column(2)

Long Time Reader Firs time poster...
I hope some one can help me with this as I have not been able to fin
an  an answer anywhere...
Ok, so I want to manipulate data on a table using various SQL queries