Search results

Changes made and it worked - thank you for your help!

Hi everyone, Thanks for taking a look at my question. I am sure it is an easy fix but my stubborn eyes are not seeing the problem and I have been staring at it so long that I knew to come right here. Attached: Stripped database, relations, jpg of the form I have a simple database tracking...

My database in a nutshell, I can't post it because of security clearance. If I don't communicate the problem enough, please let me know. I have a checklist that has 30 questions that need to be answered. It consists of the record ID, and an answer field (number) and a remark field (memo)...

Well here I am again with an update. I started to recreate the form (thinking it would be good to start again). I had a thought that maybe there was just too much to process on the form. I have 30 questions on there that are dlookup to a table. Calculating...calculating. So I omitted the...

Hi all, I have a screenshot of the form showing the first 9 conditional format fields, and then the failure starting at 10. It is the same exact code etc, just changed the names of the two controls. I have searched everywhere I can and I cannot find any references to a limitation of option...

Please help - I do not know where I am going wrong with this. I have always just used vba to backcolor fields. This time I am using conditional formatting (new to it) and it is so simple. Just can't get it. I have a form with 30 questions. Number field holds 3 values, yes 1, no 2, na 3. It...

Hi everyone, I just wanted to share my result. I tried the conditional formatting and got desired results on all three colors. I added another rule to the Remark field that said if the option frame was 3 then it would set focus. All done - very simple now that I am familiar with CF. Don't have...

Thank you! I will try that out!

I tried, I am not familiar with it, but forgive me I just couldn't seem to formulate an expression that does the prompt to the remark field. It is probably staring me in the face, but I keep going back to the code I already have because it worked.

Thank you!!!

I have some vba performing some conditional formatting. Basic, no frills. I need help to expand what I already have. Background: I have a textbox (SQ1C) that needs to turn green when option 1 of the option group is chosen, needs to turn red when option 2 is chosen and if option 3 is chosen...

Worked like a charm! My weary eyes thank you very much.

Hi Everyone. I am working on a checklist with a question, a option group response (Yes, No, NA) and a Remark field. The remark field is required if No or NA are chosen. I have code that turns the Remark field red from yellow if No or NA are chosen. (This red field will prompt them to end a...

Hi, thank you - that sounds like a great idea! I will try it.

Ok, folks I found the problem. It was in the sample data. It would not archive because it had a turnback. Sorry to bother you! Thanks!

I forgot to mention the problem! I keep seeing Archived records when they should have been excluded by the false.

Hi all, happy Saturday. I'm working from home on a deadline to get this database into production on Monday. It has been in testing for two weeks now and I found a lot of issues. Here is one of them, I struggle with sql. Here is the sql I have: SELECT [tbl_QualityChecklist].*, * FROM...

Hi All, Happy Saturday! I am having trouble with some syntax for a form. Structure: Employee Table storing the following fields. Field Names in () Username (their Clock ID) Primary Lookup (their Full Name) Level (Level - Associate, Manager, Exec, etc) Manager (Who their...

And then voila! It's fixed! Thank you! :D

Good morning! Thank you all for being such a great resource, I have learned more from this website than anywhere else. Sometimes I don't even have a issue to research, I just come to learn new things. I do have an issue today and would appreciate any help you can give me. I am...