Having a hard time programmatically making reports

[blacksaibot]

I can barely find answers in google or MSDN.



I'm trying to find a tutorial, or at least some sample code on how to programmatically create a report.

What I have now is a Form that opens up with the Access database with drop down menus that allows people to use my own interface to customize a report, because the users of this database don't want to learn access.

So for example:


There is a combobox that allows you to select what kind of filter to use on a pre-existing report (say you want to only see certain records).

Then you click a button that loads the report and it has been changed according to what the user selected in the combobox.


I appreciate any help.

[Rainlover]

So what have you got so far and where is it failing.

[blacksaibot]

I've got the form designed with all the controls.
When I click the buttons it can load a report.

I've written code in Visual Studio (VB.NET) to interact with database tables, sure.
But manipulating reports is something I've NEVER done... so as far as code I have nothing. I wish copying and pasting procedures from my past VB programs into ACCESS would work... but I learned that's wishful thinking.

[Rainlover]

Try using the query Grid to obtain the result you want.

There are some wizards there that should point you in the right direction.

Then base your report on the query.

You can move onto more advanced stuff later.

Check the Northwind Database for examples.

[blacksaibot]

I can't even get a simple button to execute my event procedure!!
on the OnClick event I tell it to change the caption of a label to something else, and it doesn't even do THAT!

private sub commandbutton_click()
label32.caption = "Whatever"
end sub

Even tried this.... nothing

Me.label32.caption = "Whatever"
Forms![FormName]![label32].Caption = "Whatever"

Is that not correct code?!?!

[Rainlover]

private sub commandbutton_click()
me.label32.caption = "Whatever"
end sub

This should work.

Do you have Event Procedure on the Click Event in the properties box for that Command Button.

[blacksaibot]

private sub commandbutton_click()
me.label32.caption = "Whatever"
end sub

This should work.

Do you have Event Procedure on the Click Event in the properties box for that Command Button.

Thanks i got it to work... for some reason the database file i was working in got corrupted or configured wrong. I used the same code in a new file and all my procedures work.

wEIRD