Change Query Data with a Form Access 2010???
Thank you for taking the time to report an issue.
What's wrong... Please write below.
This is the problem:
I have some queryes that sort out some records. I call these query from event on change from text boxes and combo boxes on a form. The problem is that it opens the query. I like to run this query in the background and then run a report based on this query.
How to fix this.
It works fine in access 2007 but not in access 2010.
Right now one of the tables in my query has multiple years across the top (as the fields), 2010, 2011, 2012, 2013. Each year contains different rates that get applied to labor hours.
I would like to know if there is a way to have a form change the field in my query.
I was able to find an article that I thought would resolve the exact issue - [LINK]. The results display successfully in Access 2010 still. In Sharepoint 2010, the form that will capture the parameter displays.
A user can enter a value in the text box and there is a button that can be clicked what will 1) close window and 2) OpenForm in Read only Data Mode and Dialog Window Mode passing in [TempVars]![varName] to the parameter for the form.
However, the result in Sharepoint is Query Error - Failed to retrieve list data (error number 2950).
More information: the Access web database has a table of 33,000 records. I have a query for that table that has a parameter that will limit the results based on a full or partial supplier name.
I created a datasheet form for that query. I created a blank form with a text box and button. The text box value is stored as a tempvar. The button will close the window and open the datasheet form.
How to change the Access query depending upon the project Ref no in the form?
What if I rename the form/table/query? Will Access 2010 make the corresponding changes in the source for the form etc.
Any changes in the fields of the table (say rename add or delete or change data type) - will they reflect in the relationship or in the forms? Will Access do so automatically?
I know the questions aren't properly worded but if you get the drift,.
I'm using a form with drop downs to filter the results of a query. HOWEVER, the form filter only works if I the query is anything but a Crosstab query.
I really need this query to be in Crosstab form, but whenever I do I get an error that "Microsoft Access Database engine does not recognize 'form!Formname!FormBox' as a valid field name or expressions."
When I change the query to a Select query and run, it works fine. I ONLY get this error on Crosstab queries.
Is there ANY way to run a crosstab query using a form selection as a filter?