Recent content by AndrewRW

I get the same problem...is it a memory issue? Very annoying!! Blank graphs, except for the title. Weird.

That's it Duane! It worked - you legend! :-) Cheers Andrew

Actually it's a bit stranger than that...when the date is from 1st - 12th day it won't complete the records...weird... Anyway, thanks again. Cheers, Andrew

Thanks Duane, That seems to be a lot closer, just not completing the records where the date is a single digit day (I'm in Australia, so our date format is dd/mm/yyyy (eg 7/12/2005)-but I won't waste any more of your time by expecting you to fix it if it's not very easy :-) I've now found a few...

Hi, This is my attempt...Item number is a number, PID is text, Date is a date/time field. SELECT qryGroup.PID, qryGroup.Date, Concatenate("SELECT [Item Number] from qryItems WHERE [PID]=" & [PID] & "AND [Date]=" & [Date]) AS Items FROM qryGroup; The qryGroup basically just groups PIDs and...

Duane, I keep getting errors (missing operators), despite the fact that your database works fine, but when I use the same syntax in a query in my database it doesn't work at all...argh. The operator errors relate to the WHERE part of the SQL statement...and I get them for the SELECT part if I...

Yes indeed...and the numbers are just examples - the actual item numbers are between about 23 and 44000... Thanks too, dhookum, I'll have a look at that site. Funny how simple the problem looks.... cheers Andrew

Hi, I've had a look around, but can't find out how I might be able to do this. I have data that looks a bit like this: PersonUniqueID Date Item 123 12/05/2005 1 123 12/05/2005 2 456 12/05/2005 1 456 12/05/2005 2 567...

" in your case, it would be 2 (lastname, grade)). " or 3...lastname, firstname, grade..can't remember how I got this to work, but it does...

Hi, I got this from somewhere, can't remember where... Basically, lastname is based on a query (or lookup) with 3 columns. Then, after update, insert this code as an event procedure(substituting your own control names and the number of columns - in your case, it would be 2 (lastname, grade))...

One thing I found out was that you need to make sure the column headers in the spreadsheet don't have a leading space in the names...you'll get an error message when you try to import the spreadsheet into Access.

Thanks for your advice :-) Cheers! (and Merry Christmas)

Hi, I work with a relatively large database (over 1Gig in size), which is on a network drive. Trying to run some queries results in a "not enough memory or hard drive space" error message. I've got Win XP and 256MB of RAM. Do I need more, or is there something else going on? The person...

There is a facility within Access to export to HTML using a template. Perhaps that is what is needed. I'd be very interested in hearing other solutions. I've used snapshot format in the past, or converted to pdf documents, to maintain formatting of reports. cheers.

Thanks Fubear. They sound good, but I guess I'm really after a "tutorial/module" based approach for training-which is what Sam's seems to provide. Cheers :-)