Search results

  1. W

    Form Calculations Generating Errors - Iff Sum

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

    Help save my carpal tunnel... need joining advice

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

    Problems with Form - Conditional Formatting not behaving as expected

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

    Please help, I am rushing against the clock like a marathon runner desperate for H20

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

    Really need help with handling a null!

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

    Having troubles with my Query not producing desired results

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

    Help with dropdown box using a default - Happy Saturday!

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

    Requiring entry in a text field if either No or NA is chosen in the option group

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

    How can I kick someone out of a shared database?

    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!
  10. W

    Help! My If Then Syntax is wonky!

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

    Hi from Florida

    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.
Back
Top Bottom