Search results

I separated this field from my major query [timeStart] and made a query from it. Now, I keep getting data mismatch when i run it. It's obiviously something to do with my combo box. What can i possibly be doing wrong? SELECT tblTimeLog.jobId, tblTimeLog.timeLogId...

Great! Thank Jon. this is exactly what i am looking for. Thanks for taking the time to set it up. very nice of you :) Yours work fine when i run it. Including the function. But this part of my query fShiftWorked([tblTimeLog].[timeStart])=[Forms]![frmOperatorWorkDone]![cboShift] Or...

Can i get some help around here? :mad: Please...i beg you...anybody, somebody please help? :D

anybori? :(

I have a value list combobox (cboShift) on my form with selections as "1st Shift";"2nd Shift";"3rd Shift" and a subform that should filter my records based on the shift selected on the mainform. My data fields in my query are [TimeStart], [Time Stop], [other fields]. I would like that e.g. when...

that's very nice

Hi Keith, you don't have to apologize. I enjoy laughing at a good joke. 50% of guys do anyways, even though y'all don't admit :o even pastors!

*sighs I have no idea what im doing wrong. IT's still not rounding :mad:

A different but similar issue in the same form: Does anyone have an idea why this is not rounding to two decimal places? :mad: This is a field in my query. bound to a control on my form. I have set the formatting to fixed, 2 decimal places and here's the query expression... Expr1...

This does it. Thanks! you rule. Thanks Pbaldy!

You are the best!!! :D Public Function GetUserFullName() As String Dim db As Database Dim rs As dao.Recordset Dim strSQL As String Dim LUser As String Set db = CurrentDb() strSQL = "SELECT operatorFullName FROM tblOperator WHERE [operatorUsername]=username();"...

I have a table that contains fields as follows: [userId], [userName], [userFullname]. About 10 users (records) in total. I have a function username() that gets the username of a user from their logon. Now on my form, i have a textbox that I'd like to display the Fullname of the user that's...

I have values for example like, 0.03, 1.14, 1.28 I'd like to round them to the nearest tenth. So resulting values will be as follows: 0.03 = 0.00 1.14 = 1.10 1.28 = 1.30 How do i achieve this? What's the formula?

ooops no intellisense :o I think it's name autocorrect. I changed names of some controls. I went into each form to fix the names and it works now :D *wwheew Im so glad i opened this thread. Thanks RG quality dude ;)

Hi there! :) All my references are set, nothing missing...nada! this is strange.

I keep getting compile errors "method or data member not found" when i use Me.mycontrol in my code. But when i change it to Me!mycontrol i don't get any errors. Everything was working fine as of yesterday, now i have to change code in my forms to Me!mycontrol. What's the difference between using...

lol..you know you are greatly appreciated :D

sweet! Hi Worldchamp, i don't care what ur old username was. However, since you are now a champion, let's talk about job prospects, home-based business and that app u created :D

Very nice!! thank you :)

Thanks all, you've all been very helpful :rolleyes: I fixed the issue anyways :D