Search results

Sorry, I wasn't clear, this: Const SQL As String = _ "SELECT q.Customer " & _ "FROM [Remote Support Query] As q " & _ "GROUP BY q.Customer " & _ "ORDER BY Max(q.Date) " ...does not appear to do anything noticeably different to this: Const SQL As String...

So you don't have to define the date as well if your using it in the query? Like: Const SQL As String = _ "SELECT q.Customer, q.Date " & _ "FROM [Remote Support Query] As q " & _ "GROUP BY q.Customer " & _ "ORDER BY Max(q.Date) " I've probably completely...

Thanks for your kind words! Been on them a week now and I think i'm adjusting now as i'm able to think again without getting a headache... I've been working on this again and just wondered if anyone would be able to tell me why adding the below "ORDER BY Date " clause to the SQL query gives...

Just thought i'd update that whilst it's printing out all the reports, I haven't yet managed to get it to only export out replorts with the invoiced flag set to false. Wasn't as easy as I thought it would be! I'm on an 8 week course of sedatives for an inner ear problem which is making the most...

You need a "shooting yourself in the head" smiley :( At some point whilst I was working on it, I switched from the version I had to a copy of the main version that is in use (to ensure there were no nasty surprises later lol) and I did not spot that the reports had different names as I thought...

Ok but you can presumably understand my confusion given that I'm going to the section in Access clearly marked as "Reports" and referencing what is presumably a report (give that it is in the reports section) and that seems to be named "Remote Support Report" even when I view it in the design...

Ohhh so the record source is the name of the report? We have a query named "report support query" and I presumed it meant it was pulling data from that query. Well that confuses things nicely if the report and the query are named the same.... Thanks I think I have plenty to go on now. I'll play...

Welcome fellow struggler! :P

Oh really? That's weird as when I look in the list of reports I see "Remote Support report". As I say, i'm new to both Access and VBA but I presumed the name in the report list would be the absolute name of it. I'm researching where to find the actual name of reports now as it doesn't seem to...

Cool that'd be awesome if you could! Should be attached. I removed all of our data and ran a compress & repair to hopefully remove any dreggs of it. If i've missed anything, it's pretty low level stuff - just company names. It's not like it's medical records or anything... I populated it with...

Thanks MarkK, I wasn't understanding this but did some research and watched the video linked in the zip (post count to low to post links or images!) which showed me how to (hopefully) correctly set the record source of the report to: SELECT * FROM [Remote Support] WHERE Customer =...

So I've been playing around with this all morning. Predictably I'm not there yet! :D I've tried and failed all the suggestions posted but i'm obviously most interested in the final set of code from MarkK given that it shouldn't flash previews up but i'm failing to understand if this is...

lol someone mad enough to have more dogs than me - I like! Love Puddles as a dog name! Mine are Dave (Shepard Rotty mix), Spud & Maria from Romania which are god knows what - they're so interbred you have no chance of working out their origins...

Wow thanks all! That's loads to go on! I'll have a play with them all in the morning and see where I get to. I'm not worried about it flashing previews up on the screen as it does that now and it's pretty fast even with the fact that it is writing 30 pages of data on each iteration instead of a...

I suck at programming and Access which is why i'm here! Hoping some programming talent might rub off on me if I read enough... Cheers Stephan

Also love dogs! I have three rescues, two of which are Romanian. Would love to hear what you have!

Hi, I've now been working on and off this issue for the last couple of days and i'm not getting any further on it. I wondered if anyone could possibly give me a hand? I am most definitely not a programmer by any means although I have dabbled in the very basics of a few languages on a personal...