Search results for query: *

I am using the Auto FE Updater. And the database is secured. Each person has a shortcut on their desktop which points to the .ini file which then in turn makes a copy of the FE to their Local C drive. I was also thinking that someone does not have all permissions so when they lock a record, it...

Yes all users do.

Yes they are properly linked. I failed to mention that the database has been working fine for the last 3 months. It's this past week that users started getting errors. Before only 2 or 3 were inserting new records but now it's 6.. would that have anything to do with it? Right now under Default...

I have a main form and a subform. The main form is bound to tblNumber and the subform is bound to the table tblItems. There is a one to many relationship between tblNumber and tblItems I have about 6 users who constantly need to add records into the form/subform. The users can enter data in the...

I have my pictures uploaded on photobucket.com And then I referece my picture:

Ok I understand I can use CurrentUser() Thanks for all the help

Users are using Access security login. Yes the same user can create more than one record during the day. So for the record source of the form I would have to put: Select top 1 * from tblWorkLog where LogonID = <somevalue> order by logdate desc What do I have to fill in for <somevalue>?

Yes in my table, tblWorkLog I have the fields for userid and logdate. I do not have a field that stores both date and time for that record. Do I need to add that? How would I create the query that you mention? And it'll only show that user's last record no matter what? If I sign on as a...

I have a User Main Menu as seen below with the command buttons for New Work Log Entry and Edit Work Log Entry. The New Work Log entry opens a blank Work Log as shown below. The Work Log form's record source is tblWorkLog. The user will fill out all the fields except the End Page and Total Worked...

I think I may have solved the problem. I'm still testing it out to make sure. The Log Date was storing both the Date and Time. LogDate is being populated by (Now) in the form's Before Insert Event. I had: Me.LogDate = (Now) I changed it to Me.LogDate = Format(Now, "mmm d yyyy") So that only...

Sorry it took me a while. Now I understand where you said to set the parameters. I set them as: [Forms]![frmDate]![txtStart] Date/Time [Forms]![frmDate]![txtEnd] Date/Time Now I am not getting the error message anymore but it's not filtering according to the dates. I will play around...

PHV: Yes it is always on a 15 min boundry as the breaks are always from 9:45 to 10:00 and 2:45 to 3:00. I implemented your code and it worked wonderfully. Thank you SO very much. Can you please explain though how it is working just for my knowledge?

I followed through your instructions, sorry but bear with me with the questions. Field: LogDate Table: tblWorkLog Show: Unticked Criteria: Between Nz([Forms]![frmDate]![txtStart],[LogDate]) And Nz([Forms]![frmDate]![txtEnd],[LogDate]) I have frmDate form Open when I run the query I get the...

No I wouldn't want the StartTime to be associated with it. Thank you for the link you provided me. I'm trying to put things together. I know this is way off but here's something that I need: Normal Hours [LogHours] = Round((DateDiff("n", [Starttime], [Endtime]) / 60), 3) Morning Break If...

I have tried parameters plus a Date picker form but when I do I get the error that the microsoft jet database engine does not recognize a vaild field name or expression. Field: Expr2: [LogDate] Between [forms]![frmDate].[txtStart] And [forms]![frmDate].[txtEnd] Or [forms]![frmDate].[txtStart]...

PHV: I added the date field and Unchecked the Show. In the Criteria I entered: Between #10/1/2005# And #10/31/2005# But that means for each month I will need to change the criteria?

SkipVought: When I include the date field it messes up my sums. It'll include each record for each date and the values of the sums becomes wrong.

AlanJordan: Thank you so much for the post. I am unsure however how to get this working. Is strLoginDate a name that you inserted or is this something that I have to subsitute with my own field name? What will go after the If statement? If.. Then..?

I have a form which has a Start Time and End time and Log Hours. Log Hours is calculated as follows: [LogHours] = Round((DateDiff("n", [Starttime], [Endtime]) / 60), 3) There are two 15 minute breaks throughout the day. One at 9:45 AM to 10:00 AM and one at 2:45 PM to 3:00 PM. What can I...

Below is a visual picture of what's going on: Two crosstab Queries one that calcuates the Sum of Total Hours employees worked for each Job Type and the other calculates Sum of the Total Pages worked for each Job Type Then I have a select query that includes both the Sum of Total Hours and Some...