Search results

Ok, I sussed it, I needed to have another ADO stream (which I called objStreamOut) to write only the modifed text line to... Dim objStream, strData Set objStream = CreateObject("ADODB.Stream") Set objStreamOut = CreateObject("ADODB.Stream") objStream.Charset = "utf-8" objStreamOut.Charset =...

Since my line of question relates to ADO, I've now opened a more appropriate thread... https://www.access-programmers.co.uk/forums/showthread.php?p=1535004#post1535004

I'm a little out my comfort zone here & could use some guidance, I basically want to read in a text file, iterate down through the whole file line by line & replace any occurrences of £ with nothing. Here's what I've got... Dim objStream, strData Set objStream = CreateObject("ADODB.Stream")...

Thanks for your input. Having delved a lot deeper after asking my question, I'm now thinking this is to do with text file encoding. The originating text file is utf-8, I'm opening it with FSO like thus... Set objFSO = CreateObject("Scripting.FileSystemObject") Set objText =...

So I'm wanting to replace all occurences of £ in text file with nothing (e.g. £1.00 becomes 1.00), with this command... FileContent = Replace(FileContent, "£", "") but when I open the text file afterwards, all the occurrences of £ have been turned into  symbol/character e.g. £1.00...

Re the bolded bit, that's what I'm doing ...calling some VBA code with a hotkey macro....but it doesn't allow me to exit the VBA cleanly (I get a further message onscreen, when the VBA returns back to the originating macro) Presumably that's used once already in VBA....my issue is getting into...

Because (to my knowledge), the only way of being able to use hotkeys, is to trigger a macro ...& I really need to use hotkeys.

So I'm using hotkeys to call macros - it all works well, but occasionally, I want to exit from a specific macro (scanning barcodes), so I've put a simple if statement, along the lines of.... UserScannedBarcode = InputBox("Now Scan the PRODUCT Barcode(s)") If UserScannedBarcode = "e" Or...

Ok gents...thank you for your input...I'll have a bit more dabble - if I'm still stuck (likely), I may slim this down & upload a test database to see if anyone can spot/suggest/solve.

At the moment - no - my user interface is a query (as only myself - and occasionally my wife use it) ....I don't need a nice GUI....want to get the basic functionality right first :-) Here you can see the problem in the query that we use (essentially our 'Orders to be processed' screen')...

I have a fair few tables in my design but have only showed a few of the main ones in play. Re the design of the ShippingServiceByCountry table ....yes that's what I've done... [/url] ....i.e. All non UK countries have only two shipping services ...whereas the Uk has a lot more

Thanks jdraw....sound & looks a bit involved! (but will study in detail when I have a bit more quiet time) They say a picture is worth a thousand words, so let me see if I can put this another way... [/url]

Actually still struggling here. A bit more background info.... I've an API that goes & retrieves an order from Ebay that I need to pack & dispatch. The order info comes into Access in XML...I parse this data & spread it across three tables (I have 3 main tables in play - Customers, Invoice &...

Thanks...that'd work :-) ...I guess I was coming at this wrong ...I've a table for shipping service & a table for country...but - as you've suggested - what I need to do is make a bigger combined table & lob on a couple of extra columns .

My apologies that I'm not putting my needs over clearly. I have a table that lists every country (over 200) When an order arrives, depending on the value, some VBA code decides which postal service should be use ...this bit I can do & works fine with a table structure like this... (I used...

At the moment I have a table for the customer's address (with shipping address including the country). I have a table for shipping services (all of the possible shipping services I use - this table is not by country) I have a table for the invoice ...this is linked to the shipping service...

So I'm struggling to work out the approach here, imagine this scenario I have a sales database which is full of incoming orders to be processed Order 1 is in the UK (which is where I ship from )...postal options are 1st class, 2nd class Order 2 is in Germany ....postal options for that...

I'm not an expert, but you've got several things going on there, when I hit problems like you have I strip it back, therefore in a VBA window, I'd do this... myTest = DCount("[ContactId]","qryAppendimportContacts") debug.print myTest ...& see what you have, if you get a number returned then...

Thanks....but in the time since posting I had a brainwave & cracked on & did it all in VBA. Essentially select all the 'unshipped' orders, order them by CustomerID, loop through the selected records & apply the following... if the CustomerID in the present loop matches the CustomerID from the...

I run an online business & each day before packing the orders for dispatch, I have a whole heap of onscreeen orders to scour manually with my eyes...I try to identify multiple orders which are all going to the same shipping address (sometimes a customer places several orders over say the...