Recent content by achiola

I am working on a form that I set up with several filter capabilities. When I click on the Remove Filter button that I set up, Access removes all the filters. How can I rewrite the following code to make it remove one filter at a time? Public Sub RemoveFilter() Set frm = Screen.ActiveForm...

Jazz, It almost works... the problem is, my actual criteria is "a-open". When I put this into the code above a msgbox appears first with the letter "a" then another with "open". If I use the word "Open", then that word appears and I could type in my...

Yes...exactly. I want to click the command button and always filter the form by only one criteria... that criteria is "Open". Nino

I desperately need a visual basic code to write a filter command. I want to click a command button and have it filter a form under a specified criteria. Can anyone help? Nino

I need help... How do I get the following code to let me put my own title and use a list box rather than type in an entry. Please Help. I will do my best to explain better if need be Private Sub Command130_Click() Dim LinkFilter As String Dim FormName As String LinkFilter =...

Hello everyone, I was wondering if anyone can help. I have a filter code. It works almost exactly like I want it to, however, when activated I would like the user to have a list of choices to select from. Ideally this list would derive from the field to be filtered. Is there a way to do...

Thanks Nigel... I used yours instead. Looks like I copy and pasted my code incorrectly above. Nino

Forget it Nigel... I got it! For those interested, this is what it looks like. Private Sub Command25_Click() On Error GoTo Err_Command25_Click Dim intPress As Integer intPress = MsgBox("MAKE SURE EXCEL FILE DATA HAS BEEN REFRESHED", vbWarning + vbOKCancel, "WARNING") If...

Nigel, Works exactly like I want it to.... THANKS. One thing though. The append query has its own warning when you click on it normally. However, after I choose OK, this warning shows up twice before activating the query... do you see what might be causing that in the code below? Thanks...

Hi All, I am trying to create a message box that will appear when a command button is clicked on. I want to write a warning before the user continues and then give the user two choices, continue "yes" or continue "no" in which case "yes" proceeds to perform...

I seem to almost have this I think. I utilized this code in the "On Enter" event: Private Sub TxtLinks_Enter() On Error Resume Next If Len(Me!txtLinks) > 0 Then Me!WebBrowser4.Navigate Me!txtLinks End If End Sub The problem with the above code is that I can't keep my...

Can anyone help me figure out how to add a browser/address bar to navigate through websites on my access form. I managed to make the website work on a form using ActiveX Webbrowser Control. But I don't know what to do to be able to navigate. Nino

Does anybody know if this feature exists in Access 2000? I can't seem to locate it if it does. Nino

It did...Thanks!

Hello All, I have a button on a form, the code for it is below. When I click on the button it opens another form, however, I want the form with the button to close when I do this. What do I add to the code below to allow it to do this? Private Sub Command0_Click() On Error GoTo...