• I am creating a new home page for this site, where the focus will be on directing people to the forums. If you would like to provide a testimonial, I would be most grateful. The thread where this is discussed can be found here: Seeking Testimonials Alternatively, just private message me.

Search results

  1. 1

    Handle Multiple Textboxes with 1 code

    Hello, I am creating a Timesheet/Payroll database, on the main timesheet form there are about 100 text boxes where the user can enter their hours (10 days in the pay period x 10 different possible tasks. In order to update the total hours immediately, I require the following for each textbox...
  2. 1

    Filter Upon Filter in Continuous Form

    Hello, I have a continuous form that shows all the records from TableA. In the form header I have added multiple filtering options using either text or combo boxes. Each filter uses the following VBA executed by a button: Me.Filter = "[Priority] Like" & "'" & Me.Combo94 & "*" & "'"...
  3. 1

    Recordset is not Updatable - Access 2010

    Hi there! I've got an odd issue here: I have a continuous form that displays 1000s of records, each record has multiple check boxes, text boxes, combo, etc. When I open the form using Access 2010 - it is defaulting to a 'read only' state and I cannot edit any of the records. A weird fix -...
  4. 1

    Find number of records based on Date Difference

    Hi All, I have a table with RMA (Return Merchandise Authorizations). This table has many fields, RMA #, Serial Number, Return Date, etc... My goal is to find how many serial numbers have been returned annually over the last 4 years. Most serial numbers are only returned every 2 years, so I...
  5. 1

    Form switches to READ ONLY after filter

    Hi All, I have a continuous form based on a query (the query has 2 tables with 1 relationship, it's fairly basic). The problem is sporadic, which means I can't figure out the trigger causing it, but after the user filters the query either by serial number, or customer, etc... the form will...
  6. 1

    Update Multiple Table Records With VBA Query

    Hi All, I have a table with many records, using a form with an update button click event, I would like to update ALL records where the Item in the table = the Item in the form. There are 6 checkboxes and 6 text boxes that will need to be updated, but right now I am just trying to test if i can...
  7. 1

    Extract from notepad to excel

    Hello All! I've never done this before, so I wasn't sure where to start looking. I have a .dat file which looks like this: 316 Canada 366 United States 232 United Kingdom 503 Australia 218 Germany 211 Germany 219 Denmark I need to extract these so that row 1 = 316(Column A)...
  8. 1

    Open Form and Assign Value to Field

    Hello all! I am having a bit of a hard time with this: I have a form (vp1) that is a continuous form based on a select query from multiple tables (TableA, TableB, TableC). Now I have created TableD. From form vp1, I need a button on each record that when pressed, opens a new sub form...
  9. 1

    Hyperlink Issue

    Hi All, I am just wondering if possible, how to create a hyperlink on our product page to search the directory for the newest file in a particular folder. We upload a new software revision to this folder from time to time, but we want to keep the hyperlink on the page the same, which is...
  10. 1

    Output to Action Cancelled problem

    Hi all! I've been running a code that has been working perfectly for the last 6 months, but today, i'm receiving an error that is cancelling the code. The error code that pops up is "Output to action cancelled" It basically compares 2 tables in a query, then creates a report to note the...
  11. 1

    Show Heading in Pivot Table with no Data

    I've been searching the forums here, can't find what I'm looking for. Is there any way to show every month in the column heading of a pivot table, even when there is no data for that month? This is an access pivot table. Any help would be great! Thanks!
  12. 1

    Find unequal records in Query

    Hi all! I've searched postings but cannot find what I need. I have a table "Complete Parts List", and I have created a temporary table "TempParts". I've coded so that when the DB is opened, the Complete Parts List is copied and pasted into the TempParts table (which has the same fields and...
  13. 1

    Make Table Query

    Hi all! I have managed to create a Make Table Query that sends the selected table information to a new database. Is there anyway to make this an automatic function, and not delete the previous table, make a new table and automatically rename that table with code? Any help on this would be...
  14. 1

    Extract changes in individual records in Back-end table

    Hi all! I have a table with multiple records (Complete Parts List Table). Whenever a user purchases, sells, or manually removes inventory, these records are updated in this table. Problem: There is no paper trail for the changes to these records. Is there any way to run a command so...
  15. 1

    Form Date Range Filter

    Hi all, I have a problem with date ranges, i think it's quite simple but i can't find any threads for it. I have a form (based on a query) that displays many records with many details (including date of purchase). I would like to filter this form with a date range. In the Form Header I have 2...
  16. 1

    Create Backup of Back-end .mdb

    Hi All! I have been searching but cannot find direct answer to my problem. I currently have a macro to backup my backend file on an hourly basis, but it will only do it when the user is on at the turn of each hour. How would I change this to perform a backup everytime the user EXITS the...
  17. 1

    Go To Record Problem

    Hi all. I have an issue I don't even know where to start. In my sales order form, there is a combo box to select each Part, currently, if a specific part is selected (after update) then I have this code; what it does is goes to the LAST recorded Serial Number in the database. BT_Serialize...
  18. 1

    Input Mask or Formatting??

    Hi All! I am having an issue with the display of the tax amount on my sales report. The text box for the taxes is based on the Percentage of tax on the form. so for example: GST on the form will show "5.00%" When I go to the report the GST shows: "00.05" ... this is when the format is set to...
  19. 1

    Automatically insert control on form

    Hi All! I am having a little trouble finishing this code: I created a button on my sales order Form, when clicked, it opens a new form. On the sales order form there is an Order ID #. On the new form, there is a field for that Order ID #. What I want is for that new form to open and...
  20. 1

    Emailing Report Problem

    Hi all! I am having an issue with sending reports via email. It has worked fine up until today... When the recipient receives the the .PDF report attached to the email, when they open it up it only shows the top left quarter of the report zoomed in. Does anybody have any idea why this is...
Top Bottom