Recent content by Matthys

Printing problem Hi, was beginning to think I'm alone in this problem. Months later it's still not solved, still running Access 2000.:eek: What is this Generic Text Printer you speak of? Is it a driver or software?

Sub-Report help I have a report, this report contains a sub-report which holds a chart (Radar chart) The display of my radar chart is determined by it's row-source. I want to set the row-source according to certain conditions in the code but ACCESS doesn't allow me to change the row source in...

Hi, Why do my Access reports print black and white when running my mdb on Access 2002 and higher? It works fine on Access 2000.

Pivot Table Example I did this one in about 2 minutes, with some tweaking you should be able to get the desired outcome.

Use Pivot Tables Hi I think the best way to do this conversion will be to use Pivot Tables, I'm not an expert on Pivot Tables but the concept is pretty straight forward.

Hi, this problem came out of nowhere but looks like it's here to stay. Our Access app generates various Access Reports. Recently we installed a new version of our access app and since that version onwards, all pc's with Office XP/2003 print reports in black & white. Printing to PDF works fine...

Getting the index Ok, thanx that worked. Now say I have the value of a certain column in a certain row, how do i find the index of that row? Assuming that all rows are unique. Sorry I'm dumbfounded by lists.:o

Hi, I have a two column listbox, list1. How do I save the data on the 2nd column of the selected row? To save data from the 1st column I do: myData = list1.itemData(list1.listIndex) Now for the 2nd column???:confused: Why are lists so complicated?:mad:

Solution Hidden in this post lies the answer! http://www.access-programmers.co.uk/forums/showthread.php?t=81228 Thanx Rich! Kinda complicated for me but it does the job.

Thanx, but that only resized my form, I want to resize the Microsoft Access Window

I'm working on an MS Access app. The clients use this app with their monitor resolution set to 800 x 600. Whenever I edit a form I need to set my screen resolution to 800 x 600 to make sure the form is within bounds.:mad: I wan't a fast way to set the Main Access Window's size too 800 x 600...