Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Denae
  • Content: Threads
  • Order by date
  1. Denae

    Sending email messages with loop sends same record each time

    I have code that is sending an email then updating a table with the date/time the email was sent, it is sending the first record and looping the right number of times (there are 3 email messages to be sent so it sends 3) but it is repeating the data in the first record instead of moving to the...
  2. Denae

    Dynamic report based on multiple selections - formatting issues

    I have a switchboard with 22 different reports, the user has the ability to check-mark the reports they want to print (e.g. 1, 5 or 22), then print the selected files to one PDF. I accomplished this by creating one master report with each of the 22 reports added to the detail as sub-reports...
  3. Denae

    Claim Tag Tracker - use next tag in new record

    I have a database that is tracking items that are being checked in and out during a festival. Each item is tagged with a unique ID (ITM_2016_####) and plastic claim tag. I have a set list of claim tag IDs that can be assigned to items as they are entered into the system. On a form I list each...
  4. Denae

    Run-time error '2489' on print

    I have a form that has the following code on the AfterUpdate property, it is printing an ID Label for the record that has just been added. The label prints but then Access gives me the Run-time error. Any help would be greatly appreciated. Private Sub Form_AfterUpdate() DoCmd.OpenReport...
  5. Denae

    Access VBA for Barcode Scan

    I have a database that tracks check-in and check-out of items. Each item has a barcode assigned to it with a three digit number. I recently purchased a gun scanner to scan the barcodes to check them in/out. I want to scan the barcode and have the item number auto populate the form, then mark...
  6. Denae

    I have a database that tracks check

    I have a database that tracks check-in and check-out of items. Each item has a barcode assigned to it with a three digit number. I recently purchased a gun scanner to scan the barcodes to check them in/out. I want to scan the barcode and have the item number auto populate the form, then mark...
  7. Denae

    Create records based on form selections

    I have a form that has fields that I need to drive creating records on another table when the values are provided. Value table: tblPayments_PayrollDeduction_Info Destination table: tblPayments_PayrollDeduction_Amounts tblPayments_PayrollDeduction_Info has the following fields...
  8. Denae

    Update Query Error: Single-Row update/delete affected more than one row of a linked table.

    I have an access database that has linked SQL tables. One of the tables (dbo_EmployeeInformation) has employee records that occasionally need to be updated. I have an extract of current data that I have tried linking into the database as well as creating a table in the database where I paste...

Part and Inventory Search

Back
Top