Search results

can you do this: Once you are at the point where you want your button to be clicked, just insert a call to the sub in your code, ex: call ClickOnButtonEvent

You could try something like this (some reverse engineering): When your condition is NOT met, simply delete the header and footer... Your data will shift by themself...

llkhoutx, thanks for the help but I'm not dealing with a main form and a subform. It is a report and subreports. There is no AfterUpdate event for subreports. Also, I tried the requery method but it does not work for reports. Finally, I haven't tried the Parent and Child Links since I doubt...

Something similar to this is needed under the click event procedure of your button: if me.textbox.value = "RED" then Reports!RedReport.print elseif me.textbox.value = "BLUE" then Reports!BlueReport.print end if Check if the print function needs argument.

Je comprend, c'est une chose que je n'aime pas de mon beau gouvernement... Le choix devrait etre laisse a l'employe, pas lui etre impose. Mais la je tombe dans la politique... Si jamais tu as besoin d'aide supplementaire, laisse moi savoir. Moi aussi je convertis de 97 a 2002 avec certains...

Hello, Here is the problem: I am converting my application (that used to work fine) from Access 97 to 2002. I have in my report some subreports that are graphs from Excel. The problem is when my report appear in preview format, the graphs aren't shown BUT if I switch to design view and...

The_Doc_Man, Just for your general knowledge: Forms = Formulaires Formula = Formule Dina01, Never use French software from Microsoft, they suck (and I'm talking by experience). You always encounter many conversion problems. My suggestion would be to check the VBA code...

This should do it. Make sure to add an OLE Object to your report (Insert, Object..., MS Excel Chart) and name it OLEExcelObject. Your report should be named ReportName and your table of data --> Data. Only 2 series are there but the same principle will work for 6. Have Fun Private Sub...

I didn't think it would require so much code. Thanks a lot. I appreciate.

Quite Simple question: What is the command line to create a Browse button in Access 97? I did not find it yet. Thanks

let = set an object to some value get = fetch the value of an object let need to have a value being passed ie: LetObject(Value1 as Variant) {Object.Value = Value1} get need to return a value ie GetObject() {GetObject = Object.Value}

What are lstNS and lstBC?

you can set your tab order within the design view with Tools or View and Tab Order

What are you trying to do exactly? Your query will produce a table where you have your data for your chart? Am I right?

Can't you run your macro Auto_Open through your object? ie.: ExcelWorksheet1.Auto_Open.Run

Are you using MS Chart? If so, I suggest to switch for an OLE object of Excel... Insert, Object, MS Excel... A lot more powerful

What if you defined those variable as Variant instead? Or put a single quote (') in front of your numerical values in excel...

Select your report, go to Tools, Office Links, Publish It With MS Words...

Is your field in Excel all text? Or is it a mix of text and number... Maybe it can help if you format your column as text, even the numeric value. It is just an idea here, I don't know if it will work.

Anytime :-)