Recent content by Trevor G

Simple question. What method have you tried? There are plenty of solutions but which one will suit you best could be determined by what you've tried so far.

When you say weird problem do you mean the picture sizes? One suggestion is to use the photo album in PowerPoint and upload the pictures then create the album and although I forget if you can have 10 images with captions on one slide it could help resize and allow you have the same background...

An example of your current layout may help with providing you with a solution and if you can let us know what version your using as the latest versions have plenty of new formulas and functionality. If you could attach a copy but remove any sensitive data that would help.

How about exporting into a word template with a table of contents using heading styles then convert the word document into a PDF document.

Have you set the format in the table for the time field? You would use something like hh:mm which you would use and not the date in the format in the time field properties.

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...