Search results

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!

Ok so here is what I've done: When the DB is opened, the Complete Parts List table is opened, and all records are copied. Then the temporary table ("TempParts") is opened, and all of the records are pasted into this table. Throughout the day, the records in the Complete Parts List will...

ok so I figured out where to change the WHERE condition in the SQL to give me the results I needed: SELECT [Complete parts list].[Part #], [Complete parts list].Qty1 FROM [Complete parts list] LEFT JOIN TempParts ON ([Complete parts list].[Qty1] <> TempParts.[Qty1]) AND ([Complete parts...

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

Unfortunately I can't release this DB. I forgot to mention also, When I run the query, I would like the new table to be created in a different database. I tried using the 2nd code you posted, but it would not work.. I received an error message saying, "Query input must contain at least one...

I have noticed that every time I run the query and create the new table, the data in this new table overwrites the data in each previous table. Is there any way to stop this from happening?

Thank you, I will give that a shot! The basic goal of this is to take a 'snapshot' of this table today, and then take subsequent 'snapshots' of this table everyday. I want to be able to compare the most recent table with the previous days table. It is basically meant to keep track of...

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

Thanks for the prompt response! I just have a couple questions regarding this code: Private Sub btn_Quit_Click() On Error GoTo Err_btn_Quit_Click Dim FSO Set FSO = CreateObject("scripting.filesystemobject") Dim NewName NewName = Replace(Now, "/", "") NewName =...

There is an Exit button on the Main Switchboard, but the user's frequently forget about it and use the Exit on the application. But, if there is a way to create this Macro by using the Exit Button on the Switchboard, I will make that work.. Thanks

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

Yes that is correct, but not a problem. But is there a code to get me back down to the 3000's and then use the next sequential number?

Basically the Serial Number is the PK. It is not autonumber or anything. So if (After Update) the product is "ABC" then I want to find the last record in the 3000's and then create the next sequential serial number. if the product is "JKL" then i want it to go to the LAST record which will be...

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

Thank you kindly! Works like a charm!

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