Forms :: Filters Are Not Remembered Between Loads

Apr 19, 2015

I have a search form which suddenly stopped remembering filters between loads. I managed to accidentally replicate the behaviour on a second database where I knew the filters worked - in this case the code was

Code:
Private Sub Form_Unload(Cancel As Integer)
Me.Filter = "(False)"
Me.FilterOn = True
End Sub

Turns out that simply commenting out then uncommenting this section (while the form was open) was enough to break it. Filtering still works, but the form's filter property is forgotten when it unloads, and the only way to change it permanently is in Design View.

So I made a very simple test db with a filtered form, started faffing around with the code while it was open, and lo and behold the filters have stopped working. But I've compared the functional and non-functional versions and I can't for the life of me see what's been changed. I suspect I've run into some kind of bug (not that I should be fiddling with code while in form view anyway) but what can I do to revert it?

It turns out that I can force the filter to be saved by hitting Ctrl+S before I exit the form. Still no clue as to why v1 mysteriously works and v2 mysteriously doesn't. In the meantime, can I replicate Ctrl+S in VBA? I tried DoCmd.Save acForm "FormName", but no luck there.

View Replies


ADVERTISEMENT

Query Looking Up Option Group Not Working; Value Not Remembered?

Aug 15, 2006

I have several comboboxes on forms that are based on a query which checks the selection of an option group from other form (all are open in same tab container). However, the query stills prompt me for parameter, which tells me it's not pulling the value though there is a selection already made in the option group, and I'm sure the path is correct.

Does anyone know how to make sure that the query "remembers" the value? Would it be better done using a public variable? (I don't know if SQL is capable of accessing a public variable, though)

SQL:
SELECT tblCounty.CountyID, tblCounty.County
FROM tblCounty
WHERE (((IIf([Forms]![frmMainForm].[Form]![frmOption]![optOptions]=4,[tblCounty].[OfficeID]>0,[tblCounty].[OfficeID]=[Forms]![frmMainForm].[Form]![frmOption]![optOptions] Or [tblCounty].[OfficeID]=4))=True))
ORDER BY tblCounty.County;

(The logic is that if you select a office location, the combobox will then filter to only counties that office covers plus two generic placeholders in "4", or allow you to select all available counties if you choose so).

View 4 Replies View Related

Forms :: Command Button Outline When Form Loads

Dec 5, 2013

I have a couple of command buttons on a form. They have embedded bitmaps as pictures with a caption below. For some reason when the forms loads (and also in design view), there is a narrow white outline / border around them. As if the button is drawn on a slightly larger white square?This border disappears as soon as I hover over the button (in form view) or click on the button (in design view).

View 3 Replies View Related

Forms :: Empty Combobox Values When Access Form Loads Vba

Feb 25, 2014

I want to empty the combobox every time when form loads. Using the below code

Quote:

Private Sub Form_Load()
combo1.RowSource = ""
End Sub

But Combobax is not emptying.

View 6 Replies View Related

Forms :: Splash Screen While Other Form Loads In Background On Startup

Jan 4, 2014

I have on very large form in my db that takes several seconds to load. I want to optimize things, so I am trying to have it load hidden in the background when the db first starts up, this way it can be immediately called on when it is needed later. Please read further :

I want to have a splash screen that loads as well. I have set the splash screen to the default form when the database opens. However, I am not quite sure how to get the other form to load in the background as hidden, AFTER the splash screen opens and appears. I tried calling it with the oncurrent event of the splash screen, but then splash screen wont appear until after the other (hidden) form has finished loading. I have tried different orders of events, but am having no luck getting the desired results.

Summary: I want the splash screen to show first, then the big form to open (hidden) in the background. The user can click on a continue button on the splash screen and then the main switchboard will open.

View 4 Replies View Related

Forms :: Make Column Invisible In Subform When Main Form Loads?

Sep 22, 2013

How do I make a column invisible in my subform when the main form loads?

View 3 Replies View Related

Forms :: Subform With Filters

Apr 5, 2014

I have set up 2 tables, and got the tables linked with a foreign key. These tables store street names and house numbers.Ideally I would like to enter a street name, and then number from and number to, ie: Main Street, from 1 to 30.Each house number will has 4 fields associated to it.

The desired result in a form will be to enter the street name, numbers from and to, and then a sub form open up showing a list of numbers covering the range entered with 4 "Yes/No" fields next to each house number.Some streets could go up to as most as 300 houses, but I would not want that number shown for every street when it is not necessary. only the relevant number according to what is entered.All data would need to be stored and then queries and reports run against it.I am using access 2007 on windows 7.

View 9 Replies View Related

Forms :: Creating Different Filters For Scrolling?

Apr 3, 2015

The last two weeks I taught myself Access (and hurt quite a few braincells in the process) Yet I am getting close to what I want to achieve, but now I am stuck how to proceed with the following:

I want to have 'forms' view as my main interface for my records. This is working very nicely, and I like how I can scroll fast through all records with my mouse-wheel. I also need to be able to filter records that will be displayed and scrolled through this way, and I created a filter which I can now toggle on or off easily for this purpose.

But now my challenge is, I want to be able to quickly select different filters, so for example, show only forms with a certain date field content. Or filter only forms which have a certain check-box checked. Etc. etc. And later on probably a bit more advanced, like: display forms that both contain 'this' and 'that'.

But I can't find a way to create several different and selectable filters? So this should probably be achieved in quite a different manner?

View 13 Replies View Related

Creating Filters In Forms Using Parameters

Jan 29, 2013

I am creating a front end of a database that is the forms only version with ext. .accdr...I would like to create a way that each user of the front end can apply a filter using parameters, allowing the user to enter in their name when opening the front end.Form and Table name is "Non-Student Tasks Completed Daily" and "Student Connection Task" Field name is "SSC"..How can I get a box to appear when someone opens the database that askes them to enter their name to apply the filter?

View 4 Replies View Related

Upgrade To SQL Server - Forms To Be Based On Queries Rather Than Filters?

Oct 18, 2005

I am in the process of upgrading Access b/e to SQL b/e using .mdb and linked table as the front end ( as given as the best solution in many of the posts).

I remember reading in this forum ( Comment made by Pat Hartman) that forms should be based on queries rather than using a filter criteria.

I have a continuous form with project records. The user can double click one of the records to view further details of the project on a separate form. The code I have used to open the form is as follows:

strdocname = "frmProjDetails"
strParm = ""
strLinkCriteria = "[WProjNo]=" & "'" & Me![ProjNo] & "'"

DoCmd.OpenForm strdocname, , , , acFormEdit, , strParm

Would this be a reduction in performance? Should the record source of the details form be changed to a query that has a where clause pointing to the selected record?
Thanks...Priya

View 1 Replies View Related

Forms :: Option Group Apply Multiple Filters?

Dec 9, 2014

I have a form with 5 options in a group. This works fine when I only have 1 filter applied to each button. I need to select the "Not Collected" button and have it filter out and show "Collected = No" and "Deleted = No". Here is my code..Case 3 is the one I'm currently working on. I can get the others once I figure out the first one.

Private Sub Frame799_Click()
Select Case Frame799
Case 1

[Code].....

View 6 Replies View Related

Forms :: Cascading Combo Boxes (multiple Filters)

Feb 23, 2015

I'm having some issues using the cascading combo box technique on my form.

I have a form, which contains a subform in continuous view, which contains a few combo boxes.

One of those combo boxes (available resources) should be filtered depending on the value of 3 other combo boxes (task types, source languages, target languages).

What I would like to be able to do is run the filtering routine on this resources cbo (currently VBA code that changes the row source value) when the user clicks on it.

It's kind of working right now: when I click on the arrow to open up the drop down list, the values are indeed filtered. The problem I'm having though is that, if I then click on that same cbo for another record (or any other cbo in another record for that matter), the resource cbo of the record I previously set gets deleted.

View 14 Replies View Related

Forms :: Creating Report Menu To Allow User Filters

Aug 26, 2013

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 selects, the filters that apply will need to be shown. I'm thinking the reports will be in an option group, and based on which report the users selects the filters that apply to that report will be displayed. From there the user can choose to apply a filter or not, and run the report.

I am trying to figure out the best way to tackle this. Should I try to create a table that contains the report name and type of filter to loop thru the controls to set visible, and build the SQL?

View 6 Replies View Related

Forms :: RecordSet Bound Form No Longer Filters

Sep 24, 2014

I have a number of forms that are bound to recordsets as follows:

Dim rs As New adodb.Recordset

sqlQuery = "Select * from myTable"
rs.Open sqlQuery, sqlCNN, adOpenKeyset, adLockOptimistic
Set Me.Recordset = rs
Set rs = Nothing

In Access 2003, users could open these forms and filter on basically any field by using the right click-> Text Filters functionality.

In Access 2010, this functionality appears to work (users can apply the filter and the Toggle Filter button in the ribbon shows a filter is applied), but all of the records are still visible in the form.

Any work-around that does not involve redesigning the form to be non-recordset bound?

View 4 Replies View Related

Forms :: Possible To Clear Filters Set On Subform Using Button On Main Form?

Jan 12, 2014

Is it possible to clear filters set on a subform using a button on the main form?

View 1 Replies View Related

Forms :: Recordset Filters From One User Affecting All Users On A Form?

Jul 10, 2013

Here is the environment:

Currently, I have 10 Users running a front end form that connect to back end data where they add to current records and eventually check that the record is complete.

I also have an "Apply Filter" button on the right hand side of the form that allows the user to apply filters to the records to show specific data that is not complete.

I am currently hearing that while the user is working, whether they apply filter or not, it seems as though all of a sudden, all of their completed work dissapears from their recordset hence not allowing them to go back to make changes to it if needed. I can only conclude that when a different user clicks apply filter, all users are affect some how... here are some examples of the code for the filter:

Code:
Select Case [cboFilterValues] ' Where the user selects a filter parameter from a dropdown
Case "All Data"
strSQL = "SELECT * " & _
"FROM [Data Table] " & _
"WHERE [Complete] = No

Then it does:

Code:
Me.RecordSource = strSQL

I am basically trying to find a way where only the user wanting to view the filter is affected... FYI, the other users arent actually seeing all the filters from the other user filter choice, they simply loose all their completed work from their form.

View 1 Replies View Related

Forms :: Embedded Within A Loop To Send Various Filters Of Report To Different Recipients

Aug 15, 2013

In a form I have a button which creates (in preview) an outlook message with a pdf report. It opens and displays just as I want it to, but if I chose to save that message in outlook and either send or cancel (i.e. allowing user to save to drafts and send later) then MS Access crashes.To ensure this wasn't to do with any compile / corruption within my full application I mirrored the process in a very simple 1 table / 1 form / 1 report db and still the same - access crashes after saving the outlook message and either sending the message or cancelling out the message.

Form code is as follows;Private Sub Command0_Click()
On Error Resume Next
DoCmd.SendObject acSendReport, "Table1", acFormatPDF, "someemaddress", , , , "REQUEST FOR INFORMATION"
DoEvents
On Error GoTo 0
End Sub

In my main application this process is embedded within a loop to send various filters of the report to different recipients, which works fine if 'save' is not used within Outlook..

View 1 Replies View Related

Forms :: Show All Records In Datasheet Subform On Form With Combo Box Filters On Load

Apr 1, 2015

I am having an issue trying to show all records when I load my form. It loads correctly when I don't have a record source for the main form. However, the combobox filters will not work. My goal is to have users be able to use the datasheet, subdatasheet and combobox filters. I can get the form to work just fine when I link the Main form and subform, but when the form opens it is filtered on the first record. I have been successful with this approach when using other forms, but they didn't require a subdatasheet.

Is there anyway I can have the comboboxes to filter yet be able to show all records until the user selects filters? Is this possible?I finally got my Manager to agree to use a database instead of Excel files based on this form setup and I need to make as "user friendly" as possible (look and function like a spreadsheet) I attached some pics of the form along with the code for the filter.

View 1 Replies View Related

Embedding Loads Of Photos

Jan 26, 2007

I am wondering if it is possible to embed all of the photos that I have into my photo table automatically. I have the table set up with all of the data that needs to be there but I have over 1500 photos that need to be embedded and wanted to save myself some time and automate the process somehow. I already know that embedding these photos is going to make my database huge but that isn't an issue for this particular project.

As far as I can tell from this forum, the help and the Northwind database this isn't possible without manually going through every photo but I am pretty new to Access so thought I would throw the question out there.

Thanks

View 14 Replies View Related

New Record When Form Loads

Sep 25, 2006

How do i set a form to start on a new record when it loads? I have tried the data tab in properties but there isn’t anything there what do I do? Can I use some VBA code?

View 2 Replies View Related

MsgBox Appear After Form Loads?

Mar 16, 2005

hello all,
i have a form which I have set so that it opens a blank record once opened. After it has been opened I want a msgbox to appear. my code so far is:
---------------------------------------
Private Sub Form_Load()
DoCmd.GoToRecord , , acNewRec

Select Case MsgBox("Please select the Registration Number from the drop down menu or type it in", vbOKOnly, "Select Registration Number")

End Select
End Sub
-------------------------------------------

but the problem is that the msgbox appears before the form is opened.
any ideas how to fix this would be grately appreciated. thank you

View 4 Replies View Related

Forms :: No Filters - Cannot View All Records In Form View

Aug 27, 2013

I have 4 tables and around 440 records but can only view up to 417 in the form I have designed. I have been adding new records via form and it has been added to my main table, but when i try to view it in form view - the record is not available to view. What do I need to do to correct this problem?

I have checked that there are no filters, data entry is set to No, Auto deletions, additions and edits are set to yes.

Also to mention it seems that the problem has arisen since I set up some new queries, there is a one to one relationship between the tables!

View 1 Replies View Related

Forms :: User Select Subform Filters Other Subform

Oct 8, 2013

i have a form with 2 subforms. when the user selects a record in subform one. the date of that record filters subform 2. in the source query of subform 2 i have this under criteria

Code:
[Forms]![frmeventbuild]![frmBUILD]![EVENT_DATE]

View 3 Replies View Related

Wipe A Query's Subform When It Loads

Sep 20, 2005

I have a form with a query's subform when the form loads appears some junk records. I want to load the form with the subform blank.

View 1 Replies View Related

Child Form Loads Before Parent?

Jan 26, 2006

Hi,

I've got a parent/sub-form set up, both of which derive their data from linked tables connecting to a central database. As a result I've had to add coding to the NewRecord events to fetch the next primary keys from the database.

Unfortunately I'm finding that one loading the new record, the child form seems to be loading before the parent, ie the child form_Current event occurs before the parent form_Current event. Is this how it should be? It seems intuitive that the parent should load first.

I'm sure I can develop some cunning logic to get around this problem but I'm sure there must be a better way. Has anyone any experience of this parent/child set-up with linked, central database tables?

thanks!

Dave

View 5 Replies View Related

Open Web Page When Form Loads

Jun 8, 2006

I have a form that displays data based on a simple query. The query asks for a PO number (from the query) and then displays the data. I wish to open a web page after the PO number is put in. What is the vb code to do so and is it on the onLoad or onOpen portion of the form?

Also, the web address needs that PO number. So, the web address would be: http://www.mydomain.com?PO=PONumber where PONumber is what was entered into the text box that was prompted by the query. Any ideas on where to start on this one? Thanks!

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved