Search results

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

Good morning, Sorry for the later reply.. Weekend.. If tried it like you suppose but still after closing the query the form is shown smaller and doesn't maximize when I click it. Can it be that because the query isn't openend maximized that the form doesn't resize? Greetings, Jan

I don't want the form showing not maximized.. Should the button close the form. Run the query and reopen the form.. Is this possible after each other? Jan

I want it to activate just by clicking on it.. But maybey you can tell me a way to work around my form troubles.. I tried closing the form and reopening it after open query statement but then the form reopens before you can update the query. So I would want to put back the reopen command tíll...

Well, I'm looking for a way to go around this way. In an other dbase I have a query start up from a form. When the query is closed after an up date the form isn't shown maximized any more. I've tried to go around this by Docmd.max... ing every where possible.. Now I want to try something...

A user activates it. So its opens and after closing it, I want a form to open.. Jan