Search results

Worked !! Thanks alot!! I actually had to put it on the Afterupdate because I already had data in some of the records etc. but none the less works perfect

I need it to save the data in the table as a negative amount so what evey type or qry or rpt I run it will show the data being negative

I was hoping for actual code not an equation but if no one knows how I may have to result back to it.

I am working on a financial db and having problems with the returns on some of the reports in which I would rather see a negative amount then a positive amount to show that the money is being removed instead if added. I have searched to no luck on how to set the txt box to only show and save the...

Try here: http://www.access-programmers.co.uk/forums/showthread.php?t=110203&highlight=searching+sorting

It worked thank you For anyone that needs this code I used Private Sub cmdPrintAll_Click() On Error GoTo Err_cmdPrintAll_Click Dim stDocName As String stDocName = "PromoPackMemo" DoCmd.OpenReport stDocName, acPreview Dim Message, Buttons, Choice Message = "Are you...

Here is my code for the command button Also I am using access 2003 if that has anything to do with my problem with the code Private Sub cmdPrintAll_Click() On Error GoTo Err_cmdPrintAll_Click Dim stDocName As String stDocName = "PromoPackMemo" DoCmd.OpenReport stDocName...

I tired using the code but it does not like the IN it is thinking that it is an end of a statement.

I have a print button and if we print multiple items off a query (that only shows unprinted records) and select yes button that all items that were printed correctly from the query I want it to check yes in the combo box. I already have it for when I print a single document I just dont know how...

Actually A zipped version would be great! Right now I dont need it because I am not that far on my db but once I have everything in place it would be a great addition!!!

Heres the code for the print form and you can also see the db in the attachment on my first post to help get a better feel for what I am trying to do. Option Compare Database Option Explicit Private Sub Form_Open(Cancel As Integer) 'This code executed as soon as Print Orders and Labels from...

I am using a report for both the labels and the memo. What I have is a form to enter the info, then you click on the print button which brings up another form in which you select if you want to print the current record only or all records plus if you want to print the labels and how many labels...

I am working on a db for promo items we send out from time to time right now we type up everything with a type writer wich I would like to make a db to do the printing for us and in the long run save the information for us for later use if needed. My problem is setting up the print form 1. I...

I am working on a db for promo items we send out from time to time right now we type up everything with a type writer wich I would like to make a db to do the printing for us and in the long run save the information for us for later use if needed. My problem is setting up the print form 1. I...

It worked perfectly !!!!! Thank you for the help

Will do Thanks

It sounds like you are using a query and need to set the form up with just a table. Go to the source section of the properties page and find the table that is the source for the form Or use this in the events section of the combo you will have to change the controls PARTID and COMBO28 Private...

It would look something like this PartNumber 1 Month 1 Month 2 Month 3 Total 1 Total 2 Total 3 PartNumber 2 Month 1 Month 2 Month 3 Total 1 Total 2 Total 3 Sql for the qry is...

Thanks for the quick reply which I had finally figured it out but now my new problem is I want to show this in a rpt with partnumber being the sort group but I need the months and totals for those months going horizontal instead of vertical. Is there a way of doing this??

I was wondering if there is a way to combine sales by month for a year where it would show the product then for say January and the total sales and so on for each month.