Search results

hi, this code puts pdf reports into a folder I am prompted for a number via the query I run because I have more than one report the query asks me 3 times could this be modified so I only get prompted once for all the reports in the code On Error GoTo Err_Handler Const...

hi I tried to bring the 2 fields down into the query but when I run the query I get 5 times more than the result quantity should be. and cannot join them any other way to only get the 5 results I needed that's why I went for the dlookup for some reason the data type in the order detail...

hi I am getting the word "error" in my query that I put that lookup in required date: DLookUp("[required]","[order details]","[productno]=" & [product no1]) or should I put this in a form before I use it in the query for my report steve

hi I have 2 tables 1. order details 2 invoicedetails in the table "order details" I have a field called , productno and required( required in a date field) in the table "invoicedetails" I have a field called procduct no1 what I would like to do is get the result "required"...

hi, I have a query that has many tables in it 2 of the tables are 1. customer 2 shipping details these are linked by the "customer id" in the shipping details form the is a field called " addressno" there could be more than one record in the shipping details form for each customer what...

ok , I am working in the form called invoice this is where I will create the reports 1. the invoice 2 the invoice delivery note 3 the certificate of conformity I have 3 buttons (vba) 1 to show the invoice 1 to send the 3 reports to a file and the one we are working on now to send the...

hi its not I have a subform called customers that comes from a query I use this to get the address =[Customers].[Form]![E-Mail address] and th name of that text box in E-MAIL address steve

could the code be modified to now open the customer form and find the " customer name" before it exit sub so I can put the e-mail address in steve

hi thank you this is what it made it work steve

sorry cj i did not see your post i will try it now

hi i managed to get this code from the internet I have no idea about VBA so I would not know where to start on how to test it could you please advise how i should do that thanks steve

hi , this is the code that I use to send an e-mail but I think because there is no e-mail address in the form I get the error "invalid use of null" what I would like it to say is " please enter customer e-mail address in customer form" any help apppricated steve Private...

hi , there should have been 4 quires in the attachment so I have attached another please ignor the stockqty>0 as this is for another purpose, I was going to use that when selecting allocation , as you cannot allocation when you have less than 0 products no = assembly numbers product...

I have attached some tables and the query that we run for ordering the products table has the subsheet showing the parts required steve

hi , the database does no work like that. orders can be on the system up to 2 years in front , the parts required to fulfil orders will look at all orders up to 3 months in advance and these are the parts to order each order contains many piece parts to fulfil one assembly part ( a capacitor...

hi if possible I would like it that they are not allowed to enter a figure greater that the existing stock. But not sure how to do that steve

hi , I have 2 forms one form is made from a query. the form is called allocation1 the other form (subform) is called stocklist when they select the material to allocate they then enter the qty to allocate the stocklist ( which is linked via the material) shows that material along with the...

ProductNo pco no OrderID GC3555M1 PCO0099 4341 GC3446M1 PCO0100 4341 GC3446M1 PCO0101 4341 GC3446M1 PCO0102 4341 DC3839M1 PCO0138 4360 OrderID NCONo CustomerName 4341 6156 Alstom - Transport this how the 2 tables are

we would have NCONO 1234 pco1111 pco 1112 pco 1113 NCONO 1235 pco 1114 pco 1115 a part could be added to NCO 1235 later but that pco number could be pco 1200 as other order when created before this order got...

hi the table names is called orders which has a field NCONO The other table is called order details which has a Field called PCONO they enter an NCO for every new order even an order within a order they enter a pco no for every part ordered within the NCOno ( could be 6 parts ) therefore...