Recent content by Trevor G

Ok im away from my laptop just know. A quick thought? If the CSV file is stored in a folder and only that file then the file name shouldn't be an issue if the code looks for "*.cvs" I'll download and explore some options and I'll keep an eye on your thread to see if anyone else has taken a look...

Hi what about recording a macro in Excel to either import and use the text to columns to sort the date format or open the CSV and change the format. That way you have code that can be adapted and run from Access. If you could share a sample, obviously no real data and I'd be happy to take a...

How can we help? Please can you show the Query code as well as not having a proper named table or fields doesn't help

Welcome Alex you've come to a great community. May I suggest that you create a specification to guide you. Sometimes knowing what you want as an end is helpful. As you know what you want it will also help with making sure you don't miss anything. Some basic info like: what do you want to hold...

How have you created the form and sub forms? I think you may have used the form wizard.. You could build a query in a similar way if I'm going down the right path. Then the report wizard would do the same. The macro section would then be able to output the report as pdf. A few steps without...

I agree with sonic8. Your screens show two different versions of MS Office and Access. What are you looking to do?

I have had a look on Google and this code should do what you want in Excel. The link to the website is shown here as well. I ran a couple of goes extending the sample you showed and it worked ok. https://stackoverflow.com/questions/44979746/vba-parse-by-and-transpose-next-row Sub splt() Dim rw...

Where is the original data stored (application it comes from) can the application transpose it before you get it?

In Excel you can use text to columns and use the Pipe as separator. then use Copy and Paste Special and Transpose that will provide the solution you are looking for without an VBA as it is a one off.

if you switch into design view on your form and use the drop down at the top left of the form icons which will list all your objects and you can select each one which should either highlight if there is an extra object over a label or something else or confirm that all the objects are as...

I did the Berlin marathon in 87. Stayed with the Black watch. Spent sometime with a good mate called Grahame Smith who was the chief clerk in 259 Sigs (I think I'm right !). A good friend going back to my Aldershot days..

Hum 9 Sigs Cyprus? I was with 262 from 88 to 90. Wonder if you were around then?

A mix of units. Started with 216 Airbourne in Aldershot after junior leaders. Went to 7 Sigs then to 1 (BR) Corps for a good few years. 244 down in Brize Norton only for six month, then 262 in Cyprus for a couple of years. Then 204 in Munster (including the Gulf war) and finally in the MOD...

Al, One additional option could be change your query to a make table and then you can use the table. Perhaps treat the table like a temp table which you can replace each time you need to do your mail merge. Mike when were you in the signals? I did 18 years 1976 to 1994.

Colin I hadn't taken it in the wrong way. Sincerely I appreciated that you added your thoughts. We all learn from each other. Best regards Trevor