Search results

But that's jsut what i am doing. when it reopens. it doesn't refresh the parameters received in the underlying query :(

Hi Jacob :) I get errors on both lines. DoCmd.Requery Command isn't available right now Me.Refresh Data member not found

You know anytime i post a question on this forum. Even my tiniest most silly question. I always get a chapter worth of lecture on my tiny issue. I learn alot each time and in each case, i've had to go back and re-evaluate my db with the fresh knowledge. Thanks for the lesson :)

aahh Rural Guy, where have you been all my life? :D Thank you so much! Quick Question: Hope it's not silly to ask, why this works and the one i had in there didn't? :) =IIf([txtTotalDailyOT]<>0,[txtTotalDailyOT],0)

How do you refresh,reload,requery a report? My report opens from a buttonclick on a form based on criteria on that form. When i click to open the report multiple times and in each time changing the criteria on the phone, it doesn't refresh the report to the newly specified criteria. It still...

Hi gemma, Yes, their total is the sum of time at work i.e. Sum([timeOut]-[timeIn]). Lunchbreak is calcualted from timeIn, timeout (no fields set aside for that). Yes normal: daytime/night doesn't matter, just timeIn and timeOut and anytime past 7.5 hours should be shown in the OT field and...

Hello my beautiful worldwide friends :D I am trying to calculate employee Overtime hours from their recorded TimeIn and TimeOut if over 7.5 hours. So anyday they work past 7.5 hours should be calculated and totalled at the end of the week. And i can't seem to figure it out, maybe my maths is...

Hi adeptus, if given a choice to learn either C# or Java, which would u choose.

lol... happy belated birthday :)

LOL ..so mean :D

1. First i watched the videos (didn't practise...just relaxed on my bed and watched alot of it on my laptop)...lol 2. 1 month passed, and i realized I can't discipline myself enough to self study and practise, i decided to enroll in a certification class at a discounted price of about $1200 for...

Notice i said "Name"? not sentence. not phrase. not a memo. Just "name". So feel free to put spaces in your sentences. thank you :D

I hate names with spaces. fieldnames. tablenames. filenames. controlnames. "Spaces" scare me! I inherited this huge (convert BE to sybase) db a while ago that had ridiculous spaces in every controlname,fieldname...just to say i was traumatized for months and had to go to a spiritual healing...

Thanks all, i have come long a way in little time :D

lol..hahaha

Bwahahahahahahaa....catdamn! :D

Just wanted to thank you again and to let you know i've found the reason why mine wasn't working. Obiviously i had nulls in there. Got the fix here from pbaldy: Passing parameters thru combo selection: ERROR: Data type mismatch criteria expression Thank you!

Thank you soooooooooooooooo much! I have checked my db and fixed it. Got rid of the nulls and also put some validation to ensure that the field is always completed by the user, so the nulls shouldn't happen again. Fixed the combo text also. Works like magic. You are the best *muah! :) *sigh of...

Get the "Most recently changed control on a form" and update my textbox with it. How? I need a code to fill a control on my form txtLastUpdatedControl with the name of the control that was last updated on the form. What i am trying to accomplish is that, since most people go onto the form to...

I am trying to pass parameters to my qury thru my combo selection. I keep getting this error "Data type mismatch criteria expression", does anyone have an idea why? WHERE (((fShiftWorked([tblTimeLog].[timeStart])=[Forms]![frmOperatorWorkDone]![cboShift] Or...