Recent content by Ridgeway

Not having much luck with the coding so have added the info added with added information HELP!!!! The situation is: 1 tble called Assembly from this is a main form called Assembly 1 tble called Assembly details from this a sub form called Assembly Details on the main form called Assembly. The...

Thank you Michael, if I manage to pull this off I'll let you know huge thank you for your time. Kind Regards Diane

Will union as I thought all numbers had to match i.e 2nd table has the correct order number in, but the 3rd table only has the order number in once but all the records need to be uploaded as soon as it recognises the one number on the first row. Regards Diane

Hi Michael Thank you for the above Michael. So will it search the order items table2 and then add further order items form the 3rd import table and put underneath any items that may already be listed under the order number in table 2 as I do not want to change the order around just add to the...

Unless it is all possible for it the search the forms i.e I have the main form orders and sub form order details but it would need to find on the either the main form or the subform the order number i.e. 123456789 and on doing so complete insert details onto the subform as this would fill the...

I have already imported the spreadsheet with the additional orderitems on and this is the created 3rd temp table (once this table is uploaded the table will be deleted) and the process will be repeated over and over again for each time a spreadsheet is created. The difference with this...

Sorry Michael, basically the first 2 tables are like normal tbl main is order number and subtbl the items ordered. However, at times additional items are added to the order and they need to be inserted against the appropriate order number and again imported from a spreadsheet however only one...

Yes Michael the Orders table has the order number, the sub table has the order details conected by the order number and the 3rd table has been imported and has further orders that need to be inserted however, only one of these columns/rows details match the order number but want all the table...

I have an existing main order table with a connecting sub details table, would like to add further details to the sub details table from a different table to increase the size of the order how to please.

Thank you Michael for your help, all above is difficult for me to understand but I shall try and work through it to comprehend. Many thanks for your time. Kind Regards Diane

Ok thank you Michael, bear with me I've never done anything like this before deep end.

Hi Michael I ran the code but it has stopped with an error: compile error: ambiguous name detected against (Public logtimestamp As String) Anyway I reread what I wrote and thought I may not have explained the situ as good as I could have. Here's another attempt, it may change things...

Hi Michael Thank you once again, I think I may need to read this over a bit but think I get what you are saying. Thank you for your time, I appreciate it very much indeed. I will let you know how I got on, I will be addressing this on Sunday so prob get feedback to you on Sunday Night or...

Hi Michael Thank you so much for this solution. I will try this out at the weekend at home and see how it works. Excuse my ignorance as I really am a novice in simpleton laymans terms what does this sentence mean. I'm not used to using proper lingo yet: I do this sort of thing using an...

The situation is: 1 tble called Assembly from this is a main form called Assembly 1 tble called Assembly details from this a sub form called Assembly Details on the main form called Assembly. The main for just has a few cells for entry but one of them is an autonumber that I have created plus...