Search results

Thanks for your help with this. I tried both methods, just to see what happened and they both worked well.

Ah, ok. I've never worked with UPDATE or INSERT. So, in simple language, I would do whatever extraction I need to do to create something which looks like a date in my initial query (from the raw imported data) and then use UPDATE or INSERT query to push the data into a new table but with the...

I'm importing data from eBay, Amazon and my own website into individual tables in Access. I'll then simplify each table and create queries which pull out the common data fields (such as transaction date, SKU, quantity etc etc) and append these all into a master table so that I can analyse sales...

Thanks for this, much appreciated. I'm not sure how it works though!

I have a problem that I don't how to get round, and I feel that VB is likely to be the answer here. My database imports files in the format shown above - this is fixed as it's produced by another system which has no flexibility in the output. I only need the 4th line, which is easy to isolate...

Like a charm - thank you!

Makes logical sense, I just don't know how to do it!

I have two great bits of code, which work well in Excel and Access. This works well in Excel to identify gaps and close them up for me. Thank you @Gasman Sub Tidy_Address() Dim iLoop1 As Integer, iLoop2 As Integer, iLastRow As Integer iLastRow = ActiveSheet.UsedRange.Rows.Count...

Thank you all - the subroutine works brilliantly.

Sorry, terrible explanation. So, in the image above, there's an empty cell between 'Braunston' and 'Northamptonshire'. To the system that these addresses get imported into, that looks like an empty address line and so it would reject that address. For it to be correct, 'Northamptonshire' would...

I have an import template for one of our system which requires all of the address lines to be 'aligned left'. It's a pain, so I wondered if there's a formula which could identify gaps where there is a blank cell. For example, between Smith's Wood and Birmingham below.

Ah, ok - it's [pick_no] in the qry_to_print_BOUN

That's exactly why I was thinking it wasn't going to be possible, but just wondered.

It's fine, I can do it in VBA. I was just being a bit lazy really, and hoping there was a feature in that interface that I could take advantage of. No worries, I'll do it the long way!

I feel like this might not be possible, but how can I use a value from the query to create a dynamic file name where I've indicated [VARIABLE HERE] in the image below? The function makedir() will have created the dynamic folder name, ready to be used.

Works like a charm, thank you. I wondered if it was overwriting, but would've had no clue how to fix it!

The code below isn't functioning as I expected it to... In short, I've added in the 'While Not rs. EOF', down to 'Wend', in the expectation that it would loop through all the records in my query and drop them all into the text body of the email that I'm sending. Oddly though, the only record...

Works like a charm - thank you!

I'm using the code below to strip certain non ascii characters in a query. It works nicely, apart from where it comes across a single quote. I understand why it's breaking, but I don't understand how I'd alter the function below to cope with single quotes in the fields that it's looking at...

Solved, corrected the syntax and now it sums correctly.