Recent content by Gina

I want to thank you all for your guidance. Attached is a shell of what I have done. I am no expert, but it works for my application.

This is a picture of my "smaller" report menu. When the user selects a report from the option box, the filter combo boxes will be displayed based on the report selected. I'm thinking I would also like to store in the table whether the filter combo box should be displayed or not for each report.

I'm wondering if Pat Hartman uses this also as a method for filtering. http://www.access-programmers.co.uk/forums/showpost.php?p=1183547&postcount=6 Hoping we get a view and reply from Pat

I have been tasked to create a report menu for my users to select a report (there are about 20), select which filters that they want to apply to that report, then run based on what the user selected as the filters. I have about 30 different filters to create, and based on which report the user...

Curious, did you ever figure this out? I have to create a report menu that allows for up to 30 different filters that are different for each report, and I am trying to figure out the best way to do it.

Public bPreventClose as Boolean should be placed at the top of the module, NOT inside of a function.

Did you ever get an answer, or get this to work? I too am looking for instruction on how to do this.

Field 3: ([Balance]/100) + ([Transaction]/100)

Here are instructions that I drafted for this process: Go to Microsoft Downloads and install the "Office Web Toolkit" on the target machine. Open MS Access and Create a new Module or open a module that contains your local code. Click on the "Tools" Menu. Click on the "Web Service Reference"...

THANK YOU!!!! THANK YOU!!!! THANK YOU!!!! Way 2 is the way to go...

this is a really stripped down version of the function.

My function was returning a variant. I changed it to an integer and it's still not working. Yes, all I want to do is run the function.

Sorry, that didn't work either.

I tried EVAL and I am getting an error. I tried =Eval([products_function]) and just Eval([products_function]). I know the function works, because I am using it in other queries.

This may have been covered in another post so I apologize ahead. What I am trying to do is to store a function call in a table field (identified as text), and then try to run that function in a query. I need to know how to tell the query to run the function, instead of just returning the text...