Recent content by JvM

Good afternoon, I want with a mouse click on a button to open a window that adds an Hyperlink to a text field on the form... I can add a hyperlink.. In the textfield with hte got focus command.. But I want it to react to a mouse klick on a button. Can anybody help me?? Thankx Jan

Conditional formatting.. Sorry my Englsih isn't that good,, Can you explain yourself? Jan

Good afternoon, Can anybody tell me if I can change the colour of the standard record selector. If so where do I do that? Or else can I make a record selector in VBA? And how do I do that? Thanks allready... Jan

Good afternoon dear Forum Members, Can anybody help me with a problem that I have with some reports? I want to open a graphic that you can make in the forms section a turning graph. When I open it, there is no problem.. But when I put them on our intranet it only shows the information view...

Good morning to all, I tried to go to the Rolling Stones yesterday and couldn't post an reply to all your effort. The Stones didn't deliver, Mick had a cold... But back to acces. Namliam, thank you for that last bit of code, it works great!!! The last three posts I do'n't understand...

I tried that but it gives me all records from up to down sorted on highest number. But it doens't give me the last record..

Heh, Thankx for the replies but I get a syntax error on the last piece of sql. It says : syntaxisfout in query expression [01_maandomzet].jaar = (selectMax(jaar) as Maxjaar from 01_maandomzet) and [01_maandomzet].maandnr = (select Max(maandnr) as MaxMaand) from 01_maandomzet. When I take...

SELECT [01_Maandomzet].Jaar, [01_Maandomzet].Maandnr, [01_Maandomzet].Maand, [01_Maandomzet].Maandomzet, [01_Maandomzet].Budget, IIf([maandomzet]>=[Budget],"ja",IIf([maandomzet]<[Budget]*0.9,"nee","bijna")) AS MRP FROM 01_Maandomzet GROUP BY [01_Maandomzet].Jaar, [01_Maandomzet].Maandnr...

I tried it, but still get all the rows and not just the last one...

Do I put this in the criteria field?

Good morning, I have a few queries with several rows with data. I want the query to select the last row with data. The rows heave an increasing number from one till .... Can anybody help me select the last row? Thankxx Jan

Thankxx for the excample code.. Will come in handy some thimes. I changed the layout colour back to plain white.. I've tried differend methodes but I couldn't get the page completely in an other colour.. To bad but so what... Greetings, Jan

Good afternoon, Is it possible with a report to give the whole page a different colour? So that the print preview shows the whole page in a different colour? Thanks, Jan

Well, I would. But the tables the under laying query refers to are lincked to tables of our ERP. So posting the dbase wouldn't help.. The graphiq show for every month a budget value and a value that is reached. Acces displays the graphic on one page and gives eleven blancs... Thats my problem...

Good morning, I have a report with results by month.. It shows a graph from the beginning of the year till now. When I want to print it , I get twelve pages.. One filled and eleven white.. Does now how I can solve this? Greetings, Jan