Not sure where I should put that code. Here is what I have, Not using a listbox:
Private Sub SwitchorRaritan _Click()
On Error GoTo Err_SwitchorRar itan_Click
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "deviceselectio nZ"
stLinkCriteria = [Category]='switch'or [Category]='raritan' "
DoCmd.OpenForm stDocName, , , stLinkCriteria...
NewtoAccess
Last Activity: Jul 17 '07, 07:59 PM
Joined: May 15 '07
Location:
-
Filter values of a Listbox
Access 2000, regarding forms.
I want a command BUTTON labeled "server" on a MAINFORM that:
> Opens up a INVENTORY form-which contains a list box- and
> Filter the values in the LIST BOX (for ex. shows only a list of server pcs and not entire inventory)
Once working I would add other buttons on MAINFORM which would open up INVENTORY form and filter based on other values.
Is... -
I made changes and it worked, ThanksLeave a comment:
-
Closing specific forms
I have a dumb question for access 2002 regarding closing forms.
In a FORM1 I have a LISTBOX1. When I click on listbox1 I want to open another FORM2 and then close FORM1-which contains listbox-.
For some reason my DOcmd.Close command closes Form2 instead of Form1.
Why? How can I specify which form to close? -
OK. I'll update the commands.
Still though, I want application to autoclose.
So if VBYesNo no button selected within 10 seconds, then I want app to proceed with closing anyway.
How can this be accomplished?Leave a comment:
-
This is what i have so far for sub routine action:
Sub IdleTimeDetecte d(ExpiredMinute s)
Dim Msg As String
strMsg = ""
strMsg = strMsg & "Applicatio n will CLOSE_"
strMsg = strMsg & "Click YES to continue working. Click NO to exit"
If MsgBox(strMsg, vbQuestion + vbYesNo, "No Activity detected") = vbYes...Leave a comment:
-
Thanks for the link. I added the forms as mentioned on the microsoft site, only problem is an option whether or not to continue working did not appear.
It just closed right away.
I want to give the user a warning before closing by checking yes/no. if nothing is selected then it should proceed with quiting app.Leave a comment:
-
I'll check out the website.
I do have a Mainform that links to other forms. Mainform always remains open even if other forms are being worked on.
I think I should put a timer on the MAINFORM. And then have countdown which alerts the user and gives them the option to reset timer or not.
How could I code this? And where on form should it be added? 'on current' ?Leave a comment:
-
Automatically Log off idle users
Hi,
We have a shared Access 2000 database shared among many users within the company I work for.
many times, users open up the shared database and forget to close it.
So I cant even make modifications to it after work hours since users are logged in.
Is there a way to log off users after a long period of inactivity?
Let me know, thanks -
I answered my own question.
Filter = offLeave a comment:
-
Remove filter on Current form.
App; ACCESS 2003
Question on FORMS
What command line can i add to a button in a FORM that will remove current filter?
I hid the scroll bar towards the bottom of the form since I dont want users to navigate, but now I cannot un-filter either.
To clarify a bit further,
Form1 opens Form2 using a stlinkcriteria.
I would like a command button in Form2 which removes filter/criteria on form2.... -
Not sure how to do that, but will try.Leave a comment:
-
I got it working, Thanks
Private Sub ViewFloorPlan_C lick()
On Error GoTo Err_ViewFloorPl an_Click
Dim stAppName As String
If Me![List0] = "250" Then
FollowHyperlink ("\\S01cspr01\c orpshare\MDF\Ca rteret\Verizon_ Cage.vsd")
ElseIf Me![List0] = "31" Then
FollowHyperlink ("\\S01cspr01\c orpshare\MDF\16 33 Broadway\48Floo r\MDF Floor...Leave a comment:
-
The Listbox value is used for other functions on the same form, so I cannot dedicate its functions to only Hyperlinks.
Thanks for the advice.Leave a comment:
-
One button, multiple hyperlinks
I have many Visio diagrams. There is 1 Diagram per SITE.
I have a LISTBOX1 which lists all sites.
After selecting a site in listbox1, I would like to have a BUTTON1 that opens up the appropriatte Hyperlink to a visio diagram for the particular site on the listbox.
LISTBOX1 gets data from SITE table (SITEID is the primary key)
Hyperlinks are:
\\S01cspr01\cor pshare\MDF\site 0.vsd
\\S01cspr01\cor pshare\MDF\site 1.vsd... -
Filter reports
Is it possible to open and filter a REPORT based on a criteria as you would a form?
If so would command be similar to:
Private Sub OpenReport_Clic k()
On Error GoTo Err_ViewDev_Cli ck
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "REPORT"
stLinkCriteria = "[siteID]=" & Me![siteID]
DoCmd.OpenForm... -
It worked fine, Thanks for help!Leave a comment:
-
Im using a value from a previously selected list box to set criteria-which works however -simultaneously- I would like to filter records based on text I have pretyped code.
The later portion im unable to figure out.
must be my syntax
stLinkCriteria = "[SiteID]=" & Me![SiteID] & "and[Category]="&"switch"Leave a comment:
-
THANKS mmccarthy !
It worked like a charm. I really need to read-up on the what 'oncurrent', 'onload' etc mean. I was working on this for 2-weeks.
Thanks Again!Leave a comment:
-
Open and filter form results based on 2-criteria
Hi its me again.
I want to filter data by 2-different values. First I want to filter data by site and then by server. the first value is obtained from a list box-this works fine, then I want the same list filtered by the text "server" in my code.
Must be a syntax error, see below, Thanks
Private Sub addPort_Click()
On Error GoTo Err_addPort_Cli ck
Dim stDocName As String...
No activity results to display
Leave a comment: