Search results for query: *

Thanks for the link lameid, it looks pretty complicated (for my skill level), but also appears to do what I want to do. I will study this and see if I can work it out. Literally I want to send out a newsletter (hence email addresses) with each of the products details (ie part no and price) in...

Hi Leslie, thanks for the reply. that is pretty much it. It is actually : email address: abc@1234.com ; Product: Product1 email address: abc@1234.com ; Product: Product2 email address: abc@1234.com ; Product: Product3 I wondered if I could somehow concatenate so that the record looked like...

I am so stumped I am not sure if this is the correct forum for the question. apologies in advance. I am trying to produce a query that creates an out put the same way a report would.I need to do this in order to export the data to an emailing application. I chave generated a query to filter by...

I have a Customer Orders Form[Orders] and a subform [Order Details]. My business has now changed such that 90% of customer orders are drop shipped so my purchse orders on my suppliers are identical to my customer orders (except price). I would like to enter my customer orders into my...

fneily, yes customer can have several users and users can be customers in their own right as well as an employee of an existing customer (also the users do move from customer to customer).We have some users that appear in three different customers. Customertble: CustomerID Customername Pword...

fneily, thanks for your reply. Yes I think that is the problem. I cannot think of a way around this. Basically I am just trying to add a new web customer to the database.The data is typically manually entered via a customer form and username sub form (hence the junction table link).If I manually...

I have recently split a "Customer table" into "Customertble", "Usernametble" and a "Junction table" (linking them).This all works very well.However, I have a macro that imports data from the web as a csv file, and puts the data into a table "new user".The macro then activates the update query to...

Apologies for the late response (we are in opposite time zones).Jimmy you understood the problem correctly there is only one billing address, but multiple ship addresses. The solution that you gave me for the addresses works perfectly.On the customer form I can enter new customer addresses, mark...

Thanks MajP, that is exactly the problem I was having (not being able to get a new record).Now I know it can't be done. BTW I am now making a tweak to my Purchase order forms. I would like to fill my PO form(and table)from my customer order form. A customer places an order which is processed. we...

Thx Jimmy, what you have suggested is exactly what I ended up doing.I was just interested (as i couldn't get it to work). if it was possible (for future reference).I do have one question. I saw from your downloaded file (that you knocked up in a couple of mins and it took me days), that you...

Jimmy, MajP, I have been sleeping on the above solution, and just wondered is it possible to achieve the above but with a command button on the main form activating a pop up "address form" (with all the same capabilities of the embedded sub form). I tried for ages to get that to work but failed?

Jimmy, thx for the download. I had the customerID field already in the address table (as per MajP). You are spot on in what I am trying to achieve. The way I have determined the billing address is put a yes/no box on the subform (ie those addresses with 'yes' are the billing addresses). I think...

Hi Guys thanks so much for the help. majP you are correct (although i just transposed Clydes response). I have just got it all working. which is a massive relief. I really appreciate the help. thx again. ian

Guys I have spent two days trying to solve this forms problem, and now have no hair left. I have a "customer" form which accesses the customer table, I also have an address table (having recently split all addresses into this table).The Tables have a one to many relationship (ie several...