Search results

  1. K

    VBA Code Help

    Hopefully someone can help me with this. In the attached spreadsheet there is a VB macro that looks at the info in the spreadsheet, seperates it by date, and then gives a sum of the times on the sheet. What I would like to do is be able to sum by name instead of by date, but I cant get the...
  2. K

    Problem saving data entered in form (db attached)

    Can someone go through my forms and help me figure out why I cannot submit the entered data. Whenever I try to test my system and enter in inspection information I get an error that says.... "The changes you requested to the table were not successful because they would create duplicate values...
  3. K

    Trouble

    I have a timed form that opens when my db loads. When the form closes a query is run that pulls time sensitive records from a customer table. I am trying to set up another function on my form that takes the system date from a text box on my form(already made) and compares it to a field in a...
  4. K

    Form Question

    Is there a way to append a specific record entered into a form to a serpate table based on a form entry? ex. When a user types the word "true" add the record to tblTrue, but if the user enters the word "false" add the record to tblFalse. I'm tryin to do this because the company I work for has...
  5. K

    Yes/No Problem in Query

    I'm having a problem getting my yes/no boxes to work in a query that i'm using. Instead of showing up as checkboxes in the query they show up -1 & 0. Here is a snippet of my code. The MWS field in bold is supposed to be a checkbock but it just shows up as <tablename>.MWS in my query...
Back
Top Bottom