Search results

sheesusm.. i had to utilize all three to get it to work while scrolling through records Private Sub combostreetdirectorywindarea_AfterUpdate() If Me.ComboStreetDirectoryWindArea = "Y" Then Me.ComboOptOutFormInFile.Visible = False Me.ComboOptOutFormInFile = "N/A"...

Private Sub combostreetdirectorywindarea_AfterUpdate() If Me.ComboStreetDirectoryWindArea = "Y" Then Me.ComboOptOutFormInFile.Visible = False Me.ComboOptOutFormInFile = "N/A" Me.ComboUWDocumentException.Visible = False Me.ComboPolicyholderIndividualEntity.Visible = False Else...

Here is the attachment

My Goal is was to have the ability when street directory equals y to hide and default certain fields as well as the same thing for some other fields such as the individual or entity field resulting in hiding of other fields below it so figuring this out will help me big time in the creation of...

Private Sub OnCurrent() If Me.ComboStreetDirectoryWindArea = "Y" Then Me.ComboOptOutFormInFile.Visible = False Me.ComboOptOutFormInFile = "N/A" Me.ComboUWDocumentException.Visible = False Me.ComboPolicyholderIndividualEntity.Visible = False Else: Me.ComboOptOutFormInFile.Visible = True...

I assumed I would have to assign the code to the combo box itself.

I am new to vba so still learning and reading up. I currently utilize the below. This works fine however when i click new records in the split form view or go to next record if the Y is met the first time all records after that are invisible until i go back to the record i changed and alter...

using 03.. thanks for the link.. i actually found that lastnight after reading your post to learn about it.. i thought i was ok as those duplicate fields are for different completion dates should the original start date be exceeded or an issue comes up. I could split them up however Last time...

when you say normalize you are in reference to? The limited data that is being captured fits on one table without anything that needs to be setup in another linked table. Or so I thought. Your suggested edits didnt result in any problems but i still get no action based on the actual button...

i tried this but with no luck Private Function basOrderby(col As String, xorder As String) As Integer Dim strSql As String 'Clear captions from command buttons ClearCaptions 'Set row source for list box If Me.Check25 = -1 Then strSql = "SELECT DISTINCTROW Project_Name, Project_Creator...

http://www.access-programmers.co.uk/forums/showthread.php?t=77694 is it possible to set my global variable to an if function? where Private Function basOrderby(col As String, xorder As String) As Integer Dim strSql As String 'Clear captions from command buttons ClearCaptions 'Set row...

one issue that showed up is that if i can sort based on the three top buttons perfectly. However, when i select my view completed projects button only the 5 shows as intenede but once i hit the sort buttons all records come back so it isnt sorting the five.. but the button is still selected...

out of curiosity your one thread you pointed to a while back talked about requerying... as there could be in theory several users is it as simple as adding the requery to the button itself?

thank you tons for the help on this.. i was pulling my hair out because there was no table linked to the form and access macros and buttons wouldnt filter it correctly again much thanks.. a lifesaver

i ended up excluding 5's from the view to begin with and then once the button was selected it views only those that are 5s however once deselected it showed everything as i forgot to modify the click code. I have yet to try multiple buttons and greying out one button if another is selected...

no worries.. I greatly appreciate the walkthrough.. I am going to modify a couple items and post the final view.. I am going off the premise of altering the main strsql query to exclude the completed items from the beginning and then have the button bring up on those that are complete.

I am seeing how an option group works with the following options so that only one button can be selected. remove completed projects view completed projects view all records (default) I thought it would be easy to go in and rename the toggle button to the check11 button however there is no...

ok going to try something and see if it works.. will post shortly.

I deleted the telephone button.. that was the issue of the dll problem..

if i follow your same logic on this and add a second button to view only those that equal five am I going to run into an issue if both buttons are pressed? In essence how would access know which button has priority in terms of the modified where clause?