Search results

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

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

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

I am once again having syntax issues with the following statement. I have tried all variations of single ticks and quotes, HELP !!!!! I can get the two statements to work separately, but when I add the "AND" it fails. The "RecordLock" field is a yes/no field. stLinkCriteria =...

I have a form with 10 unbound text boxes. A user will populate between 1 and 10 of these text boxes with report criteria, and click a button to open a report. The data in the criteria field is not consistant (which is a issue I will eventually fix), so if the user is looking for P2522, it could...

I am trying to figure out set up a command button in a form that runs a select query using the parameter "Between..and.." then runs a report using the same criteria and if o.k., then runs an update query using the same criteria without asking the user the parameters 3 times. I'm not familiar...