Replies

The built in record selectors will work just fine. Is there a way to prevent the user from doing a Ctrl A and then pressing the Delete key? That was what I was trying to avoid.

Thanks,
Ron

If I remove the that line from the On Load event, when the form opens, all records have the image. The purpose of the image (a small arrow) is to act as a record selector or marker for the current record.

That did the trick. Thank you very much.

Ron

My programming expertise is limited to DoCmd, Me, and similar type statements. Have been running into a brick wall with syntax errors trying to get the correct MsgBox to appear. A totals query was created to give a count of the selected records by returning a number result. This query result is named CountOffldSelect. Within the On Click Event Procedure of a command button I have inserted the following:

If (CountOffldSelect) = 1 Then
MsgBox “This is One Record”
Else
MsgBox “You Must Select Only One Record To Edit”
EndIf

This appears logical to me but is unacceptable to Access. This always evaluates to the Else. Any help would be appreciated. Thanks.

Ron

What method could I use to count the number of ticked check boxes?
Thanks
Ron

Thank you very much Hans. That did the trick.

Ron

Hans, the results are looking very good and the obvious bugs have been squashed. Pat, your suggestions make the whole thing more impressive and dynamic. Thank you again for great support!

RonM

I was trying different things and discovered if I manually go to the table (tblHrsWorked) and enter a Date and a Name for those dates that had no labor entered, the results between name/hours/date for the report are in proper alignment. It is not even necessary to enter an hours amount in the (fldWrkHours) column of the table. Is there maybe a way with programming to see if all the dates requested on the form are included in the table, and if not, insert a date and name to produce an accurate report.

Thank you.
RonM

Was doing some experimenting with entering the payroll hours and discovered something. If no person works on one day, but someone works the following day, their time is aligned with the day when nobody worked. Any ideas on how to address this situation?

Thank you.
Ron

Pat & Hans

Thank you very much! That worked great. I am constantly amazed by the plethora of genius that is available at this site.
I owe you both a .

RonM

Thank you Pat – that worked like a charm!!! You are a hero.

That was a good explanation Hans. I will read over it numerous times until it soaks into my thick skull. I appreciate all your effort.

Thank you!
RonM

There was a “typo” in my previous post. Where I said (highlight out the “on current” event… – – it should say (“comment ” out the “on current” event… Try that and see if each individual field and record is highlighted as you move through them. I do not understand what the String(……) does. The example attachment for the txtBackground Control Source contains – String(50,219), Null. What does that mean?

Thanks for your help
RonM

Downloaded the Highlight database. Could you tell me how the background color change happens from the txtBackground/IIF.. statement. This is something new to me. One thing I did try was to highlight out the “on current” event of the form. The result was that as you moved through the form, the current field/record was all that was highlighted – not the entire record.

I tried to download that file from Mark Liquormans site. It came back saying that is is unavailable.