Search results

Good spot! ....& indeed this solution occurred to me last night (when I revisited this issue), so that's exactly what I've just done & it works a treat :-) Many thanks. I'll mark the thread as solved.

Yes, that was my general plan of attack for the mechanics 'under the hood' so to speak, ...I guess the cut & thrust of my question is how do I present the data to the user to look like the box above.....such a user interface window needs to take data in (scanning box for the barcode) ...which...

When I come to pack an order, I wish to add a bit of functionality to my Access database ....functionality that my existing third party order management system presently provides. Let's say an order has 3 items to go into an envelope...I don't want to accidentally pack the wrong things into the...

Thanks.... the StopAllMacros action is for use within the macro interface ...what I seek is when some VBA code is being run (called via the Macro), that the VBA code itself can Stop all Macros I therefore converted StopAllMacros to VBA & this is what I got.... Function Macro1() On Error...

I have some macros which are chained. These macros are mainly running queries but sometimes, there's a bit of VBA code being called (via Run code). The VBA code is checking for certain conditions....what I need is to cease all Macros from running when my code traps a certain...

that sounds exactly what I need - thanks!

Apologies, that was a typo on my part (it was about 1.30am UK time when I posted!) ...I was using rst.Edit (not the rst!Edit I posted) I woke up this morning afresh & have approached the update another way (which won't mean a whole lot out of context, but you should still get the picture...

So I'm trying to do this.... Dim db As DAO.Database Dim rst As DAO.Recordset Dim PresentShippingAddress1 As String Dim PreviousShippingAddress1 As String strSELECT = "SELECT DISTINCT EbayOrders.Processed, EbayOrders.OurRef, EbayOrders.ShippingAddress1,EbayOrders.HasOtherOrders " strFROM =...

It is driven by the customer supplied data. Like I say, a customer can place two orders, but have slightly different addressing details for each order...if I don't check all the fields & store any differences as a 'new' separate customer, then the outcome will be that the addressing info used on...

Like I say, I have it working now by removing the shipping address related joins (leaving on the billing address joins - but I'm 100% sure there was nothing wrong with the data contained within the shipping address fields, e.g.. no null fields contained etc).... This works...

Perhaps I've not understood your drift, but this is for new data going onto the customers table. I'm using a distinct query combined with an append query to ensure I have unique records (from the incoming scratch table) & then append 'unmatched' to the Customer table - but like I say, with...

I don't get any error messages. The data contained in the customer table is used for things like invoices.....I have to have all of those joins because for example, a customer could place two separate orders but choose a slightly different way of entering the address data .....if I don't check...

Ok, so I had a break....back at the wheel, but as puzzled as ever, here's my query.... ....if my interpretation is correct, any data that is in the left hand table (which in this case is actually the output of a query called 'UniqueCustomersfromAmazonOrders') that is not 'matched' by the...

That's pretty much it...I have two 'streams' of sales data incoming from Ebay & Amazon They give me different 'chunks of data' (for example Ebay only provides a shipping address, whereas Amazon provides a Billing & Shipping) I dump this raw incoming data into separate 'scratch' tables...

It might seem that I'm a bit haphazard, but I'm being quite structured in my approach. 1. First I had to learn how to get the data (via an API) 2. Then work out the best way to store/manipulate the data in access (the incoming data is in a mess in its raw form) 3. Then normalize it ...etc...

Actually I've just discovered a much worse problem...so I'd like to park the above for a second (the above is more of a puzzlement, than causing problems ....I think!) Ok, to this latest (serious) problem I have a 'incoming data' which goes into scratch table called AmazonOrders. Towards...

Updating more records than exist in the table? Ok, I'm confused. Towards normalizing data, I've updated a Customer Table with customer name & address information....I now want to copy the CustomerID back to the original table. Here's my query... ...when I go to run it, Access informs that...

Thanks CJ - that's essentially the solution I've done (it's less pain from my Noob's perspective!) A useful tip...at the moment I need to crack on (& since it's working blah blah). I've just come up against another challenge....how to put all the different aspects of inventory control in date...

Thanks Steve ...but that didn't resolve (some good came out of it though I hadn't used the expression builder in a query prior...didn't even know it was there as an option...as I've only ever used in Reports) I think the problem is coming about because one of my query's columns calls a...

Thanks...yes, that was the problem :-) Next issue is that the column on the right below, is problematic (if I remove the column the query runs fine)... here's the first error (I get two more follow on parameter related prompts for the other two references in that right column)...