Search results for query: *

Great, Thanks!! ~Dori

Ok, I know this is a stupid question...should I copy and paste it just how you have it? I tried that but it gets hung up as soon as it gets to Me.Section("Formheader").BackColor = bckColor What am I doing wrong?

My SignInForm has the following event code to change the color of the ExpirationDate field if the record's expiration date is passed. I'd like the whole form color to change instead of just the one field. ' Display Expiration date field in Red if Expired...

Our num lock key unclicks itself on our Dell computers at work. This happens about 20 times a day and it's very annoying! Is there some way to fix this? Thanks, Dori

Got it. Thanks!!!

Hello, I'm trying to do the same thing but I can't figure out how to set the group footer to have a page break after it. Can you be more specific for me? TIA! ~Dori

But we need the dates on the report. The report is a receipt we give to our members when they sign up for a class. And they need to see when the class starts and ends. Now we are adding "membership" to our class list. We don't want to show dates on membership receipts because there are so many...

I got an error on the IsLoaded part: Compile error: "sub or function not defined" Otherwise it works! But I really need that part because occasionally we have to run that report without the RegForClassSignIn form open. On those rare occasions, it will have nothing to do with the membership...

Do I add this to the Open Event of the report?

On my RegForClassSignIn form, the startdate, enddate, controls all have a date in them. Our related table requires it. This is fine because we never want those left blank. But now we have a situation where we don't want the date to show up on the ReceiptSignIn report (which shows up when...

Perfect! Thank you! ~Dori

I tried that and got a sytax error. So I copied and pasted yours and got the same error. What's missing?

Jeff, I know you have the answer here...but I don't know exactly how to word this. Every way I try to put "My Stuff" I have problems. Can you be more specific? Thanks!!

Yeah! I'm almost there... In the After Update event I tried: Me.[cboIDSearch] = Mid(Left(Me.[cboIDSearch], Len(Me.[cboIDSearch]) - 1), 2) And it worked! However, if someone types in an ID number (without the symbols), instead of scanning it, there's a error: "Could not locate Pass ID" then...

Our ID cards have a magnetic strip that automatically inserts % before the ID number and ? after the number like this: %255? (this is passID number 255). When the ID card is scanned into the unbound control, IDSearch, I want the control to ignore the % and ? and just read the number. Is there a...

I've got a query (TrackingQuery) with over 100,000 records showing each time a member visits our facility. Of course, most memberID's show up quite a few times. Can I make each one just show up once? I'd like a total of how many different members visit, rather than how many total visits...

Thank you very much! : )

Ok I finally got it! Your code was perfect! I had just closed the Time Clock form. Duh!

>>I'm entering a new position into the positions form. I want to refresh that in the Time Clock table's Staff Name cbo box of the Time Clock.<< Oops! I didn't mean Staff Name cbo, I meant cboPositions.

I guess I meant that I speak english, not Access. Dim is something I do to my headlights at night, string is what I use to sew, exclamation points are used after grammatical interjections. Those are the only meanings I know : ) My experience with Access is mostly just data entry. I tried the...