Search results for query: *

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...

What's up braindead? Could you give me a little more detail here. I followed along the link you supplied and still seem to be having trouble. I am new at code writing, so my question is, where do I write the code to simply have the webbrowser control go to a website. Right now, nothing works...

Thanks Joe, I just needed to know what the cause was. Terry, I will check out the Handbook, it sounds like it is just what I need to solve my problem. I did take a look at your FAQ link, and it wasn't very helpful. One thing I took from it though was to be clear when posting a...

I have created an Access database that is now being used by other users in my company. The problem is that when they open up the forms it looks a heck of a lot bigger on thier screen than it does on mine. It makes it cumbersome for them to get around. Is there anything I can do to allow other...

I hope this helps. You need to create a new field in the database(table), Name that field. Go back to the form in design view. Right click on the options button that you put there and select Properties. Select the Data tab and you will see 'Control Source'. When you click on that field you...

Thanks Aivars, That worked perfectly! Thanks a lot. Nino