Search results

  1. A

    Help with Query that is attached to a form

    Hi - I have a query that is attached to a 2nd form that open when the user inputs information in a 1st form and then clicks the Search button. So the Search button opens a 2nd form whose record source is based on a query. The 2nd form displays the correct records when using Fund Year and/or...
  2. A

    Solved VBA Code to run a series of queries and to check the record count and based on record count either continue or display message

    Hi I have this embedded macro that is attached to a command button on my Form. I need this to be VBA code since I have to add a step to execute a select query that checks records against 2 tables to see if the record on my Temp table already has the same records on the "real" table. I also have...
  3. A

    Solved Append (unique) records to table without creating duplicates

    Hi - This is the last piece of this project I have been working on. I have a Form that allows user to attest to reviewing records by marking each checkbox control and then clicking an Attest button. This will open an Attestation form which allows the user to "attest" to completing the review...
  4. A

    Solved Import process runs append query: is there a way to alternate the message depending on the record count?

    Hi - I have a macro (mcrImportClaims) that is attached to the OnClick Event of a button that resides on a Form. This simple macro executes an append query (qryImportClaims) that reads records from a SQL table and appends them to my Access table. The macro runs a delete query first, then the...
  5. A

    Solved How to Create a Calculated Field for Fund Year based on 2 date fields?

    Good Morning, I need to create a calculated field called 'Fund Year' that will be based on 2 existing fields, 'Date of Service From' and 'Data of Service To' values. So I am thinking something like this, "if D.O.S from Year < Current Year and D.O.S to Year < Current Year then Fund Year = Current...
  6. A

    Solved Controlling total amount billed and total record count based on checkbox selection

    Hi, I have a form with a Check box control called Attest. When the user marks the checkbox I would like the Attested Amount Billed to increment based on the Amount Billed value for the record/row. In addition, I would like the Attested Recs to count the number of marked checkboxes. How can this...
  7. A

    Controlling total amount billed and total record count based on checkbox selection

    Hi, I have a form with a Check box control called Attest. When the user marks the checkbox I would like the Attested Amount Billed to increment based on the Amount Billed value for the record/row. In addition, I would like the Attested Recs to count the number of marked checkboxes. How can this...
  8. A

    Help with VBA code to validate form controls

    Hi, I have a form control that I would like to validate to see if the value entered by the user exists on a SQL table. I tried using a macro but it's not working and I know it's probably better to do using VBA - something I am not good at! I can code basic routines but nothing crazy. 1. I...
  9. A

    Access Query to allow user to enter criteria for anyone or more values on a form

    Greetings, I have a Form in my Access database that is based on a query. My form consists of multiple textbox controls and the goal is to allow the user to enter either the date range start and end values, and/or Fund Year and/or Fund Name Listing. My query selects records from my table with...
  10. A

    Working with Tabbed forms

    Hi - I have a tabbed form in an Access database I am designing for process claims. Each tab represents a different fund type. My main table will contain the individual claims. I also have a table that contains just the funding type names. Each tab contains an identical form with all the same...
  11. A

    Run-Time Error when processing Export to .txt delimited file

    Hi - I have a macro that is attached to a command button on my form that runs a step that executes (run code) a function called ExportData() a colleague created a long while ago. It exports the main database table to a txt delimited file that feeds a process to our SQL tables. Mind you this has...
  12. A

    Access table Yes/No Data type default value when pushed to SQL

    Hi - I had an Access table that had a field with a data type of yes/no. I had pushed the table to our SQL server and now when the user is updating a record using a form (the record source is the SQL table) the receive a write conflict error message. I search the Internet and found a post that...
  13. A

    Write Conflict Error message

    Hi there, The user is getting a Write Conflict error message when using a Form in Access. He navigates to the last record and clicks to add a new record. This works successfully, however, when he navigates back to the previous record, he receives the Write Conflict message box. Somethings to...
  14. A

    Type Mismatch issue when trying to Open Form using VBA

    Hi - I have an event procedure tied to the On Click property of a button on an Access Form. I need to open a 2nd form based on multiple criteria. Normally, I would use a macro to do this but since I need to open the form based on 3 different criteria I had to use VBA. DoCmd.OpenForm...
Top Bottom