Recent content by Fikus01

im afraid I cant do that, this is a work project and the database contains sensitive information hence just sharing an image of the table in the original post

ok thanks, I tried a crosstab but it doesn't like it, keep getting an error related to a query where I use a combo on my front page to select my required results. for the same reason I cant seem to make a table with this result set. all I need to do is have column 1 results as my column names...

Morning everyone, I'm trying to get a pivot query to work on the below data source. My aim is to get the CarId to be the column headers and the axle serial as the data source all on 1 row. the table name MTDN is actually a query that gets the information I need into 1 place. Table: should be an...

1 year ago, I'd never set eyes on access. I spend 3 or 4 months just watching what my team leader was doing and taking it in when we had spare time to work on this program. After a while it just clicked. I get the program and the relational side of it and how it differs from excel, I'm getting...

our database isn't a multi user, it will only have 1 person at a time, but depending on where we are, the usb stick is mapped to either a:\ or d:\. I thought I would be able to use the top part of the code with the error handler to swap between them, and it works to a point, it wont let me use...

Sorry, just read that back and I've been too brief, this is the full code I am running, probably an organisational nightmare to a pro. I can successfully get it to work if I have a fixed file from location but as we use 2 machines with drives mapped differently here I added to code to look for...

Hi everyone. I'm a bit of a newbie to vba and access in general but it is making sense and I've made good progress, I am however stuck on this point. I'm trying to put a filecopy after something similar to the code I have used below and I was hoping to use the mydrive or mydrivedir to specify...

Hello. I'm very new to access and vba. I have a lot of experience with the more advanced features of excel so lots of access is making sense. Already this site has helped me to do a lot and I look forward to learning from you as time goes on. Many thanks in advance Nick

Hi everyone. I'm a bit of a newbie to vba and access in general but it is making sense and I've made good progress, I am however stuck on this point. I'm trying to put a filecopy after something similar to the code I have used below and I was hoping to use the mydrive or mydrivedir to specify...