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

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

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

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

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

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

Hi guys, I have a text box on a Form that requires the user to input a date. I also have a check box that requires the user to click on it once the date has been entered. Is there a way to make the text box contingent on the Check(Option)box so that when the user clicks on the Check box...

Ok guys, A lot of us novice users are trying to figure this out. I have read through past posts and have seen many people asking this question. It concerns creating multiselecting listboxes and getting that data to a table. For those of you proficient in Access, and Visual Basic code I...

Hi All, I am really having a hard time with this one. I have created a form with various data fields. Once the data is entered it is submitted to a table. That works fine. However, most of the data is similiar with each entry and I am looking for a way to create a form that allows...

I am trying to create a combo box that allows the user to select specific items. The source of these items are from a table. Once these items are selected and the form is submitted I would liked them to be stored in a different table. Is this possible? How do I create a multiple selection...

I am looking to write a code so that when I click on a Control button, the information on the Form gets sent to my email. Is this possible? How do I do it? Nino

What I am trying to do is get information from another Query/Table to a Report I created. I want to know how many times a certain item shows up in the Query/Table. Report Item # Cutline Total ##### xxxxxxx ##### xxxxxxx ##### xxxxxxx I want to know how many times a...

I am looking for an expression in a Query that will look at a particular field, analyze the data and return a particular statement. For example: Field 1 GLP002 GRS003 GLP004 TRE445 I want an expression that will look at this feild for the data types beginning with "GLP..."and...

I put a subform in a form. Both the form and subform draw their information from the same Query. I set parameters in the Query, and now when I open my form(which has a subform) it prompts me to put the parameters in twice. I imagine this is because it is looking for the Form and Subform...

I am connected to database files that can not be updated. I am trying to create a combo box that I can type in my request, have it look up the table and return the info. I have already created the combo box with the list of data from the table field already, but I want to be able to type in my...

I have created a switchboard in my Access database. I am trying to find a certain property feature. I want the switchboard to fully encompass the screen upon opening the database. But I also want to make sure its the same from computer to computer. How can I do this? I opened my database...

I am just starting out using Access. I have developed a Query that will feed into a Report. There are two feilds in my Query I want to evaluate. I want to see if those two fields exist in another Table or Query simultaneously, and if they do return the word "Linked". I have tried...