Modal right choice for quick filter query form?

Want to provide users a way to choose from a few dropdowns to build a query, show the results in a datasheet, then click save and load the result set into another table.

Questions: can you access form fields on the parent form?

Sponsored Links:

Related Topics

Modal right choice for quick filter query form?
Want to provide users a way to choose from a few dropdowns to build a query, show the results in a datasheet, then click save and load the result set into another table.

Questions: can you access form fields on the parent form?


passing variable from modal form to main form
On my main form, I have a search option that opens a modal form. When the modal form is opened, the main form remains open. The modal form determines a variable. Clicking ok on the modal form, passes the focus back to the main form and closes the modal form. How do I reload the main form based on the variable from the modal form. The modal form is using a global variable


Modal Form
I have a form that has a Frame Yes/No (1/2) question.I have gotten a select code to work that says if Frame is 1 to open my modal form.the modal form will have additional information for the individual to complete based on the Yes answer.the problem I am having is.I have one table.so how do I get the information from my modal to populate in the table, on the record that is active?

Here is the code:
Private Sub Frame24_AfterUpdate()
Select Case Frame24
DoCmd.OpenForm "frm400Q1", acNormal
Case Else
End Select
End Sub
The modal form opens.it is after I input the data, it is not carrying over to the table.what I did was for the questions in the modal form I dropped into a separate query and based the record source of the modal on the query


Modal Form Close
I have a modal form which has a button on it that when I press it opens a query. how do I get this modal form to hide behind the query when it opens?

I have managed to do it for a report but I dont know where to add vba codes in for a query


Modal Dialog Form
I am struck with a Modal Dialog Form.
Basically I've got a main form with a datasheet subform which is not editable which has a Primary key and a foreign key columns in it. The only way to add some data to this datasheet view form is by clickin' a cmd Button.

Once I click the button a Modal Dialog form appears and then the user selects or enters the details in it which then gets appended to the table.

I've made this Modal Dialog form to go to new record every time it loads but I am wondering if there is a way to link it to the main form I mean when I click the cmd button I want this modal form to appear but want the foreign key to be selected by default.

I hope I've managed to phrase my query properly


Referencing properties of a modal form in VBA
How do I reference properties of a modal form in VBA.
e.g. I have a modal form called "DatesForm" and I invoke it as follows:
DoCmd.OpenForm "DatesForm"
How do I reference the modal result and the fields on the form (what syntax do I use) ?
I want to set the value of a text box called CompanyText, on the form.


Efficiency in Form/Query
Possibly quick question: Is it more efficient to have my underlying query for a form filter out my records as opposed to doing it in the Filter property of the form?

To break it down further: I have added a function where the user can show the last 30/90/180/all days on split form with the datasheet on the bottom. This function uses the filter property to grab the last month/3 months/6 months/ or all records.

Would it be best to change a variable within the underlying query instead of using the filtering?

I only ask because I am working over a VPN right now and I noticed that the form was slow to load and I was thinking of what would be fastest.


modal property not working
I have a button on a form that opens a form called itemqueryform2 with this code:
Private Sub lookupitemsbutton_Click()
DoCmd.OpenForm "itemqueryform2", , , , , acDialog
I want it to open in a Dialog window, with the modal property set to No so that my user can switch easily between the dialog and the form she is using underneath.

In the properties panel, I selected Popup YES and Modal NO, but my form still does not allow users to click out of it without closing the form.


Trouble selecting active record in datasheet
The form shows the default MealItems set for production. At the last minute the end user may need to select an alternate meal item, and substitute corn for green beans.

I have it set up so that the end user double clicks on the ItemName field on the data sheet and that opens a modal form with a query behind it.

I want the query behind the modal form to pick up the Meal3ID which is the primary key of the table behind the data sheet. and pull that record from the underlying tableTbl_ScheduledMealItems and display the fields on the modal form.

Everything works fine except:

The double click only calls up the first record in the underlying table. It does not pull up the active record (The one the end user clicked on.)

How can I make my double click on the ItemName field capture the Active Record clicked on and pull up that specific record in my Modal form?


Adding a Filter to a Form
A filter can restrict or sort the information displayed in the form without creating a new query. You can define a filter as: Filter by Selection; Filter by Form; Advanced Filter definition facility.


Trouble selecting active record in datasheet
Access 2007, not compiled, not split, skill level medium.

The form shows the default MealItems set for production. At the last minute the end user may need to select an alternate meal item, and substitute corn for green beans.

I have it set up so that the end user double clicks on the ItemName field on the data sheet and that opens a modal form with a query behind it.

I want the query behind the modal form to pick up the Meal3ID which is the primary key of the table behind the data sheet. and pull that record from the underlying table Tbl_ScheduledMealItems and display the fields on the modal form.

Everything works fine except:

The double click only calls up the first record in the underlying table. It does not pull up the active record (The one the end user clicked on.)

How can I make my double click on the ItemName field capture the Active Record clicked on and pull up that specific record in my Modal form


Form ComboBox Filter - Select ALL records
I'm trying to filter records on a form with a ComboBox, and I want the option to return ALL records.
My Form is: frmReview
My ComboBox is: cmbGLimpact
The RowSource is: SELECT DISTINCT [GLimpact] FROM Initiatives UNION SELECT Null As AllChoice FROM Initiatives ORDER BY [GLimpact] DESC;
The Query Criteria is: [Forms]![frmReview]![GLimpact]
The field values are: Yes, No & TBD

The filter works fine for Yes, No & TBD, but the blank choice doesn't return all records.

I need to be able to setup several filter ComboBoxes to enable filtering on several different fields. So, depending on which ComboBox filter (field) the user wants to filter on, the otherswill allow all records to be returned.


I can't seem to use filters properly - looking for tips
I am trying to figure out how to add filters to a form I am building. This is somewhat related to my other topic "help with nested combo box" but at a more basic level Ican't even a single combo filter to work.

I have been able to add the filter button but it seems to be useless.

I need to know 2 things:

1) How to add a filter to a form that is a combo box and can include all results or the specific choice you make from the combo box.

2) How to have a filter linked to a filter.

Detail of my problem below:


Filter a Form with a form
I have a form that sets the filter parameters for a query. That works great. I want the form to filter the form that is based on that query. the form I want for the results to show in is HDStock. The form that ask for the criteria is HDSearch.
....
I get a run-time error '2465': HDSearch can't find the field 'Filter' referred to in you expression and the query pops up


How do I auto populate columns based on a single value input on a form?
I need my form to help input thousands of hand filled-in paper forms, of these forms there were many different choice versions and the respondents gave their answer based on that choice, they had 8 choices per form.

My table is set up so that the people digitising these paper forms will first input the "choice 1: choice code" which is a unique number 1-32, they then input what's written on the form and move on to choice 2, here I could give them the 32 choices again but all later choice codes are based on the first choice code (please see the attached table) so I wondered if it's possible to auto populate the 7 remaining columns with the choice code based on the code input for the 1st choice?


Troubleshoot filters
I am having problems applying a filter:
Saved filters are not getting applied to a view or report. I don't see lists of field values in the Filter By Form window. I get an error message saying my expression is not valid. Some form fields are not available as criteria fields in the Filter By Form window. I cannot filter based on a combo box by using the Filter By Selection technique. I want to use a query as a filter, but the query is not listed when I click Load from Query. The filter commands appear dimmed and are unavailable in Datasheet view and Form view. I want help with troubleshooting filters in an Access project.
I applied a filter, but...
Some records are missing (I see too few records). The filtered view shows too many records. The filter returnset looks different from what I think it should be. I filtered the subform or subdatasheet, but it did not filter the main form or datasheet. The returnset is not sorted properly. I want to test my filter before I distribute the database.


Creating a user friendly DB and tightning up Security
I'm trying to restrict my Users from having access to the back end of things through the navigation panel, ribbons etc.
Is there anything else I need to restrict?
My only concern is because I have pop up and modal modes on(except on my Main_Menu). The only access to the navigation panel etc is through the QAT. Though with the Modal setting on .I will lock myself out. Any other ways I can access it?

With the pop up and modal mode I noticed if I want to show up my reports from of the Main_Menu form, They open behind the form. I want it to open in front else no1 can access it


Creating a user friendly DB and tightning up Security
I'm trying to restrict my Users from having access to the back end of things through the navigation panel, ribbons etc. Is there anything else I need to restrict?

My only concern is because I have pop up and modal modes on(except on my Main_Menu). The only access to the navigation panel etc is through the QAT. Though with the Modal setting on .I will lock myself out. Any other ways I can access it?

With the pop up and modal mode I noticed if I want to show up my reports from of the Main_Menu form, They open behind the form. I want it to open in front else no1 can access it


How to apply a filter on form load
The are two properties on a Form property sheet that look like they should allow me to add a filter when the form opens. They are:
1) Filter
2) Filter On Load (I have this one set to YES)
I have a Query defined that I'll like to use as a filter when the form opens. How can I do this. And, no I don't want to change the record source to the form because I'd like to retainthe ability to remove the filter when the form is open to get back to all records.
I'm using Access 2010


Query / Macro / Form to add a choice
I need to create a form which will allow customers to choose a gift out of a choice of 4 gifts but there's only a 100 of each gift available. My table has the gifts under gift choice, with a combo box which gives the 4 options. Now I've got to create a query/or such which will show my customers on the form how many of each gifts are left. And if they do select a gift that is already chosen, I want a message box to come up telling them that the gift is out of stock.