Search results

I just really need to get something deployed ...when I asked the question, I didn't know how to do what I needed (I was trying to do all the summing in VBA prior to then updating tables, but couldn't work out how to do that) I now at least have something in place...I'm all ears as to the...

More meat on the bones for what I'm trying to achieve. I run a a one man business supplying products to businesses such as Amazon (& others) ...if they overstock, they return products to me. The products returned to me in a postal package all have both a name (SKU) & a barcode. So here's...

Thanks...no my user input wasn't going into a table (I'd wanted the end summary data to go into a table ...i.e. once he'd finished entering input), but I've now got VBA to create a temp (scratch) table, then use an 'insert into' command to pipe the user entry into the table, I can then use a...

Still not following your suggestion ...are you suggesting the use a temporary scratch table (created in VBA) to append user input to ....& then use a dcount command at the end of the procedure to summarize?

Thanks ...but I'm wanting to do this 'user input' counting on the fly in VBA ...not using an existing table/query (or have I misunderstood your suggestion?)

Let's say we prompt a user for some input (let's say characters we don't know how many times he will enter a character, except he will type 0 to exit), what would be the best way to count? For example, let say he enters the following characters a b c c c b d 0 (exit) The summary would a=1 b=2...

Even with complicated/non standard surnames, all I need to compare would be the First initial of the first name & the bulk of the surname, for example... Oscar de la Roja Alivant Goor Jean Phillip Maston ...so essentially I need a way of isolating/stripping out the last part of the name...

Actually, I found a routine immediately after posting the question, here it is... (ref https://stackoverflow.com/questions/30236076/extracting-last-name-from-a-range-having-suffixes-using-vba ) Public Function LastName(sIn As String) As String Dim Ka As Long, t As String ary = Split(sIn...

Odd title...let me explain. Two names provided for a transaction (one name provided by Ebay ...and one name by Paypal) Ebay Paypal B C Smith Brad Smith what processing can I do to get access to work out they're the same person? Presently the person's name would appear twice...

I now need to include the time element to the above For example, this date/time... 22/11/2017 12:40:00 ...would need to become #11/22/2017 12:40:00# I've dabbled with the syntax, but I'm just not getting it right :-( Many thanks!

Lovely...that worked a treat - many thanks

I'm using some date criteria in an SQL command ...SQL it needs a literal date. I live in the UK, so all my dates in access are ina DD/MM/YYYY format ....for the SQL command I need #MM/DD/YYYY# Now using a combination of left(0, MID() & right() I can construct a literal date from the UK date...

Basically this is my setup... ...I've written some VBA to automatically email customer their sales receipt. I have it working *when* all the fields required are specifically selected in the SQL select command...the problem is it's a very long 'select' statement, so I figured I could press...

Thanks for taking the time - I did as you suggested... SELECT * FROM (Customers LEFT JOIN Invoice ON Customers.CustomerID = Invoice.CustomerID) LEFT JOIN ShippingService ON Invoice.ShippingServiceID = ShippingService.ShippingServiceID; but when my code runs... strSQL = "SELECT * FROM...

But when I use the * in a query ...it works - the field definitely exists in the table I must confess, I've never full got to grips with joins (no matter how many times I look at the diagrammatic representations!)...I simply construct the SQL via an Access query, then copy/paste the SQL...

This is odd, so I tried the * i.e.... SELECT * FROM (Customers INNER JOIN Invoice ON Customers.CustomerID = Invoice.CustomerID) INNER JOIN ShippingService ON Invoice.ShippingServiceID = ShippingService.ShippingServiceID; My vba code is happy (finds all the records referenced), except one...

I'm having issues! There are actually three tables involved :-) This shows the joins... SELECT ShippingService.ShippingService, Customers.Email, Invoice.InvoiceNumber FROM (Customers INNER JOIN Invoice ON Customers.CustomerID = Invoice.CustomerID) INNER JOIN ShippingService ON...

Many thanks :-)

To avoid a ridiculously long SQL Select statement, how do I select all record from two tables? So in the example below, I've two tables [Customers] & [Invoice] which are joined by CustomerID SELECT Customers.BillingName, Invoice.InvoiceNumber, Customers.BillingAddress1, Invoice.OrderDateTime...

My (short term) solution is to use a proxy for the http requests, something like this... If Count < 80 Then XMLHTTP.setProxy 2, "http=178.62.28.110:8118" Else XMLHTTP.setProxy 2, "http=139.59.175.229:8118" End If I've 150 products, so cycling the http requests between...