Search results

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...

There is a way to do this, in your query, click on the column you would like to caption and click on view properties (or alt-enter), the "field properties" box should load. There is a property titled caption. Whatever you type in there, will appear when your query is displayed.

Thanks Banana - Finally got it to work using your advice. Love this forum...

I did get this to work: see code: You have to setup the Sharepoint folder in your "Network Places" first. Call FileCopy("R:\GMAO-ACCESS\Development\Gina\Automated\ COMETcontractWarningEmailRpts\StatusOfCNS.xls", "\\teamsite.merck.com\external\VSM\shared documents\Invoices\statusOfCNS.xls")...

Thanks for your guidance, I will pursue the web api method.

I have searched this and other forums, my books, and the Microsoft website. I am using Microsoft Access 2002 SP1 and am trying to copy a .xls file from a internal network drive to a Sharepoint Site. I have setup "my network places" to show the applicable Sharepoint Site and Folder, and can...