Search results

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)...

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...

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...

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 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...

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...

I have a split database with each user having their own frontend copy. Sometimes people leave their database open for extended periods of time. This affects my ability to make any table changes. Is there a way to kick a user out? Thank you!

Thanks for your help - I am new to VBA syntax. I have found a nifty solution to addressing a required field on a form, I am just having a problem adapting it so that I can have more than 1 control. For reference, I have 8 checkboxes that must be checked off before the record can be saved...

Hi everyone, my name is Laura and I am from Florida. I am happy to be here - I have been reading threads and learning many new things. Hope you all have a great day.