Search results

it will be the highest in the table

they have an order number that could last for many orders which can be added to then they have an NCO NO that defines that which part of the order that is. this number was just recorded in an excel sheet then the have a PCO number That is for the part to be purchased which could consist of...

hi , thanks yes it is the last number they entered , but it will / should be the next highest number

thanks they are using the next number/ pco number , but they have no record of the previous number only in an excel sheet , what I want to do is show them the number they used last in the form where they enter that number so they don't look into the excel sheet, but confused how to do it I...

hi , I have 2 tables one with an "NCO " number in it and another table with a "PCO" number in it the field name is NCONO and the number could be "12345" the field name BATCH NO could be "PCO1234" the table that holds the PCO number is called orders the table that holds the Batch in is called...

hi the code attached always shows me the pdf file and goes to the folder required can the code be modified so it does not show me but just goes into the folder I also would like a message to go to steve.kirk @ api.com to say this pdf is in the folder . but not send the pdf to him...

yes the purchase order number is the order number that code will go into 3 forms but be modified slightly for each area 1. invoice details 2 order acknowledgement 3 purchase orders. the code above will put the reports into each persons directory ( sales, purchase orders, etc using the...

hi I have really no idea how to do it this is the code for the whole process could you please look at it and alter it to suit thanks steve

hi the table is pdffolder in that table I have this c:\users\user\documents\sales id number 1 c:\users\user\documents\purchasing id number 2 when the macro runs I would like it to see which one of the above is to be used by means of the " ID " NUMBER if that is possible . this then will...

hi I am a little confused can you please explain a little more I have put an id field in the table and I want it to look at id 2 which is a folder called purchasing where the first line is sales in the table thanks steve

hi, I use this bit code to look at a table for the path for pdf file to go into varFolder = DLookup("Folderpath", "pdfFolder") this looks at the table pdffolder what I would like to do if possible is for this to look at the first line in the table but I want to use this...

hi this is the code I use to prepare the invoice for sending Private Sub cmdEmail_Click() Dim strTo As String Dim strSubject As String Dim strMessageText As String Me.Dirty = False strTo = Me.[E-Mail address] strSubject = "Invoice Number " &...

this is how I got it to work DoCmd.OutputTo acOutputReport, "Invoice report", acFormatPDF, "C:\Users\User\Documents" & "\" & Me.Customer.Column(1) & " " & Me.InvoiceNumber & ".pdf", True or thanks to all

hi , with the brackets in I get an error Microsoft access cannot find the field !1! referred to in you expression steve

hi , I am now getting another error method or data member not found the macro button under e-mail customer is what I I press to run the vba I have attached a file to view if it helps record 2 in the form is the one with the invoice number in it and the invoice number is 1 thanks steve

hi, I created a button and but this into into on click DoCmd.OutputTo acOutputReport, "PDFInv", acFormatPDF, "C:\USERS\USER\DOCUMENTS\invoice" & Me.Invoice No & ".pdf" but I get an error that says compile error syntax error and my code is in red steve

hi, I want to try and see if this will put a report into the folder c:\users\user\documents\invoice\ the problem if this is correct is I don't know where to put it and how to make it work . I assume the report has to be open also , any help appreciated steve

I was going to put a field in with a number in it ie first record no1 second record no 2 etc for each customer then get a prompt in the query to enter either 1 or 2 as this is an easy number to remember. but with the help you have all been giving me in all my posts I know this might be...

hi thanks I never thought about coping 16000 records but that's what I will do do not understand code but thanks to all steve

before ACCESS Excel was used to create orders etc, we are up to order number 16223 now I have access and the auto number will start at 1 how can I get the auto number to start at 16223 steve