Replies

Problem Solved. Since I am using Now() to fill in the date/time field as to when a job is started/completed, At the same time I use the Time() function to determine my shift. Will only vary a few tenths of a second at the most which is not critical.

Let me try to clarify what I’m trying to do. I am keeping track of computer jobs with a start date/time and a completed date/time. The date/time field is in general format. As part of the statistics I am gathering, I also need to determine what shift the job was started and what shift the job was completed, ergo, I need to extract the time portion of the date/time field to determine the shift, eg, 7:00am – 3:00pm = shift1, 3:00pm – 11:00pm = shift2, 11:00pm – 7:am = shift 3. HTH.

Princess: Your code probably should read:

If IsNull(me![tnum]) then ….

HTH.

Markus: Try this:

Month: Format([InvoiceDate];”yyyy-mmm”)

Peter: Not knowing all the intricacies of your situation, a starting point might be to use th MAX function on the date/time field. This will give you the latest date. Or you could sort all your dates in descending order to give you the latest first. HTH.

Lonnie: Try this. Assume the name of the Command button is btnCommand.

Private Sub btnCommand_Click()
On Error GoTo btnCommand_Error

If btnCommand.Caption = “Open Form” Then
DoCmd.OpenForm (formname)
btnCommand.Caption = “Close Form”
Else
DoCmd.Close
btnCommand.Caption = “Open Form”
End If

Exit Sub

btnCommand_Error:
MsgBox Err.Description
Exit Sub

End Sub

HTH.

Dan: I use this calculation to sum times:

In the Control Source property:

=Int(Sum([timefield]))*24 + DatePart(“h”,Sum([timefield])) & “:” & DatePart(“n”,Sum([timefield]))

Yo Arage: Apart from the naming conventions, each query type has a small icon to differentiate it from another.

Back to the LNC, there are specific naming conventions for each type of query (13 according to LNC) and for all the other type of objects one can have in a database. These are all listed in the LNC book.

Also, this URL should give you what you want. It looks like it is a copy of what is in the LNC book.

http://www.mvps.org/access/general/gen0012.htm

HTH.

It seems strange that one could run out of room in the detail section, unless you have an extremely large number of controls. Assuming that is not the case, try making your detail section multiple lines, i.e., putting controls on multiple lines.

Hi: FMS, Inc. has a tool called Total Access Sourcebook which has code for these type problems. The cost is aprox. $150. There is a function to calculate the difference in business days, eliminating Sat, Sun, and Holidays.

Thanks for your insights and thoughts on this. You have been very helpful.

Charlotte: Thank you for your reply. I was thinking along the lines of a prospective student to take to see in which to enroll.

Debi: In your QBE grid place the results field and do a ‘Group By’ on it. Place the results field in the QBE grid a 2nd time and do a ‘count’ on it. I think this will give you the desired results.

Look into using Left, Mid, and Right functions

Jason: I used this to separate a name field into first and last. Format of [name] is [first last]. You might be able to modify it for your use. Hint: Always keep names separate in your DB. Much easier to work with title, first, mi, last. HTH.

SELECT tbl_Names.Name, InStr([Name],” “) AS [Temp Name], Left([Name],[Temp Name]-1) AS [First Name], Mid([Name],[Temp Name]+1) AS [Last Name] INTO tbl_Split_Names
FROM tbl_Names;