Search results

I do run across businesses that might need you special talents. I will definitely send them your way when I run across them.

That would be awesome but in reality I don’t know anyone else programming in access. I would be willing to bet your fee is a little high for one person to absorb. That is definitely not a complaint. I bet you are worth every penny. Thank you for all your help with a newbie like me. I would be...

Thank you, I will check it out. It would be fascinating to spend a few hours with you and try to soak up all you know about access. Amazing!

Well said Pat, believe I will move the code. Thanks again. Btw, code has changed to the isnull function Instead of 0

Pat, thanks for chiming in you have never led me astray (along with many others) But would the load event be ok if it a one time use, then more code closes the form. It is only to capture a moment in time then closes. Also the code is used to set the properties of the subform before the user...

Not sure if I remember how. I will try that shortly.

I have a time keeping form that should set properties based on the conditions of the last record such as if there are no time stamps then the time-in field should be enabled and the time-out field should not, but it is not working. Only the second set of conditions works correctly. Here is the...

I think I’ve got it figure out. Just tweaking to do now. Thanks

So i could bind it and use that form to enter the first field of data for the clock procedure and after update open the clock in/out form and limit the records to the current employee, is that correct thinking?

Forgive me but is a search form an unbound form with my field to scan the employee badge and then on the after update field it should open the clock in/out form for the rest of the data input?

I am working on a form for my shop personnel to keep time on orders out in the shop. The plan is to have 3 or four computers connected to our network with scanners and access (distributable) on each one. Here is how I envision it: The whole process is collecting the employee id, the work order...

I have moved the code off the unbound txtField and put it in VBA. Thanks

It is working now, don’t understand what the problem was at first. Probably a newbie not closing the form and reopening is all I can think of. Thanks

I have a table with a field named WONumber. It is input by a barcode scanner and is a Text field of the order number (long) and item number (txt) and is represented like this @@@@@-@@@@. After the dash in the field the remaining string is of variable lengths, so I am doing this to get a Dlookup...

Cool, works perfectly! Thank you Pat!

SELECT tblEstimates.EstimateID, tblEstimates.ModelNumber, tblEstimates.Active, IIf(IsNull([MatDetLineTot]),Round([SumOfLabDetLineTot]*2),Round(IIf([MatDetLineTot]<[SumOfLabDetLineTot],[MatDetLineTot]+[SumOfLabDetLineTot]+[SumOfLabDetLineTot],([MatDetLineTot]+[SumOfLabDetLineTot])*1.5),2)) AS...

Hmmm... Query returns yes or no. But that didn’t work. False works

Great!, Thanks again Pat! You always come through for me!

Also, my RowSource is a query not SQL - does that matter?

Thanks, But I changed it to two and still doesn't work, I also have the following code for the cbo - could that be the problem? [CODE] Private Sub cboEstID_AfterUpdate() newestimateid = cboEstID Dim dblPrice As Currency Dim strDescription As String Dim strModelNo As String...