Search results

hi the number of the record not the auto number

hi, I have a subform in my customer details form in that form is shipping details. I could have 3 shipping address per customer is it possible to use the record set number to use in a query to select the correct shipping address in my report steve

hi pressed the reply button by mistake before I had finished my last post could you please also explain how I could lock it down with a data input the users will not be able to get to any tables steve

HI Do you mind explaining how to do that. I at present do have a pdf report of the order but I don't know how to do what you do steve

hi , the purchase order will go for approval ( normally paper copy ) but I have put it into access of which a copy of it will be sent to the manager for approval . he could tell the purchaser to change this or that and send for re- approval what I have done is put a password field in...

hi, is there a way that when I field gets a password entered into a field the form can be locked so nothing on that record or subform linking to that record can be altered thanks steve

hi, i am using 2013 access and i cannot find a chart details ie pivot or bar charts. therefore I have exported the information into an excel . if there is no charts functions on this access is it possible to export the information yet the pivot chart stays in the excel so i don't have to...

ok thanks this did it in one input once again thanks steve

that's great you re teaching me a lot I really appreciate it steve

hi , I need to be able just to run the query and be asked for the batch number to be replaced and be replaced by steve

hi I have put this in the sql but it is not working have I put it in wrong? steve

hi , can you please explain where I put this and do I change my table 1 to my table name steve

hi the reason there are more than one table is 1. sales create it for ref to a sale as orders numbers are "rolling on" numbers 2 purchasing use it to state what parts were purchased against it 3 stores use it to allocate parts against. but this is my first database that does so...

hi, I have 4 tables with a field that holds a "batch number" there can be many batch numbers in these fields I want if possible to replace a batch number from all my tables that contains that data and replace it with another batch number in one go. is a macro the only way to do...

sorry , did not know tables where hidden

hi, I just want to include the e-mail address in the form invoicedata by looking at the customername in the invoicedata form and checking it against the name in the customer table so I though it would be a look up but I have no idea how to do it thanks steve

hi , I have attached a from which is called "invoicedata" this form has a column " Customername " the first name is "Alstom - Transport" There is a table called customer the id number for the customer "Alstom - Transport" is 200 how can I get the e-mail name into the invoicedata...

ok , thanks I will set it up that way steve

hi =[E-mail Address]& IIf(Nz([E-mail Address])<>""," [" & [E-mail Address] & "]") this gives me this results when I want to send a e-mail and does not work if I change it to this it works ok =[E-mail Address] can you please tell me the difference as I got this from the...

hi there is a form called products and this is completed by engineering. this has 2 fields 1. product number ie gc12345 product description ie capactor to drawing 12345 a new product could be generated by engineering and put into the form sales they need the part...