Search results

I have a form (form1) which will open another form (form2) and apply a filter using a filter button already on form 2. I have applied the following code which works properly for 2 of the 3 forms this needs to be done on: The below line 'Call Forms.[RMA Data].Command40_Click' works for both...

Hello, I am seeing a very bizarre problem with exporting a report to PDF. When clicking to save the report as PDF, it is hanging up for about 5-10 minutes before completing, it usually only takes 3-5 seconds. This is only happening on one report in my database, other reports export as PDF no...

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

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 & "*" & "'"...

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

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

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

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

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

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

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

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

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!

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

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

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

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

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

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

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