Go Back   Access World Forums > Search Forums

 
Showing results 1 to 9 of 9
Search took 0.00 seconds.
Search: Posts Made By: Fikus01
Forum: Queries 10-11-2017, 04:24 AM
Replies: 7
Views: 541
Posted By Fikus01
Re: SQL Pivot not working

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
Forum: Queries 10-11-2017, 03:20 AM
Replies: 7
Views: 541
Posted By Fikus01
Re: SQL Pivot not working

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...
Forum: Queries 10-09-2017, 11:28 PM
Replies: 7
Views: 541
Posted By Fikus01
SQL Pivot not working

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...
Forum: Introduce Yourself 08-17-2017, 11:14 AM
Replies: 2
Views: 355
Posted By Fikus01
Re: Hello everyone

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...
Forum: Modules & VBA 08-17-2017, 06:07 AM
Replies: 5
Views: 359
Posted By Fikus01
Re: Vba file transfer help

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...
Forum: Modules & VBA 08-17-2017, 05:20 AM
Replies: 5
Views: 359
Posted By Fikus01
Re: Vba file transfer help

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...
Forum: Modules & VBA 08-17-2017, 04:00 AM
Replies: 5
Views: 359
Posted By Fikus01
Vba file transfer help

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...
Forum: Introduce Yourself 08-17-2017, 03:53 AM
Replies: 2
Views: 355
Posted By Fikus01
Hello everyone

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...
Forum: Visual Basic 08-17-2017, 03:47 AM
Replies: 0
Views: 1,461
Posted By Fikus01
Vba file transfer help

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...
Showing results 1 to 9 of 9

 
Forum Jump



All times are GMT -8. The time now is 12:24 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World