Search results

I have a form that displays various information about the records in the database. I would like to have bullet points on the form to help display the information. I have searched Microsoft Support, Access Help and the previous posts in this forum, but I have found nothing. Could someone tell me...

Is it possible to have one form based on two queries?? The reason for this, is that I have given the user the choice of searching for renewal dates by month and year, but I also want to be able to have a query which brings back all renewaldates from the present date. I have both queries...

Greetings everyone, I have a query that is used to pull records for a certain month from my table. I use the following criteria, as the user selects the Month and Year from comboboxes on a form. The form is based on the query. Field: Year([Renewal]) Criteria: [forms]![renewalform]![year]...

I have a form based on a query. On the form there are two combo boxes which are used as the criteria for the query. My problem is that I can select the values in the two comboboxes but nothing happens. I have tried to use refresh, but to no avail. Any suggestions as to what I am doing wrong...

Ok...This is maybe be a bit confusing, but I will do my best to describe what I am looking to do. I want to be able to dictate what value appears in a combo box based on a value selected from another combo box. e.g. If a user selects a location such as Bahrain, from combo box1, the standard...

I have a continuous form, and I wish to be able to number the records that are displayed. So if there are 15 records, I want to a number from 1-15 by each record. FYI, the continuous form shows the results of a search. The search can bring back 0 or 100s of records. Thanks, Angelo

OK, this is driving me batty... How do I clear a list box of its highlighted records? I have tried refresh, and numerous bits of code from Access help, but the list box still doesn't want to clear. Any advice, suggestions would be great, thnx Angelo

I have a form which is used to create a new record and input information. I am wandering whether it is possible or not to have a mesage inside a text box stating: "Enter Name Here" or in a combo box stating: "Select Location". And then once the user selects the text box/combo box and begins to...

Using code, how do I get access to look up a value in a table based on what a user has selected in a combobox? Before you answer, let me explain a bit further, as this problem is not as easy as it sounds. I have a form which is used to add new records to a database. Whatever information a user...

Could someone point me in the right direction concerning If statements. I want to be able to assign a record a SortID# dependent on what value a user selects in a combobox. For example, if a user selects: Generic, the record is assigned SortID #1 UK, the record is assigned SortID #2 Japan, the...

The following code opens up a form to a particular record once a user clicks on the name of that particular record. My problem is that I want to open up the entire record set but still initially have the record the user chose come up first. Is this possible? Any help would be great, Thnx...

I have a form where I navigate from record to record using next/previous buttons. My question is, when I get to the last record, how can I get the records to cycle back to the first?? And vice versa when I am on the first record and I press previous I want to move to the last record. Does...

I need a Macro that opens a form to a particular record on a onclick event. I can get the Macro to open the particular form I want, but when I use the Where Condition to determine what record to open, the form that I am opening freezes and is just a grey box. The Where condition code I am using...

I have a form which has a wild card search query which brings back results that match what a user has entered in a unbound text box. The results are then listed in a another unbound text box. The user can then select a match, which prompts another form to open displaying the record he/she...

I have a form on which I have a command button that toggles between locking/unlocking a record for editing. Using the code: Private Sub Command61_Click() If Command61.Caption = "UNLOCK RECORDS" Then Me.AllowEdits = True Command61.Caption = "LOCK RECORDS" Me.Refresh Else Me.AllowEdits = False...

Greetings Everyone... I have a bit of a problem, and was hoping some nice person out there would have the solution for me. Basically I have a form where a user can navigate using a combobox (by selecting which record he/she wishes to see), or by using "Next", "Previous" command buttons. My...

Cay anyone help? I have created a form that displays the particular domain name information for each domain name located in a database. I allow the user to navigate from record to record with navigation buttons, and a combo box which lists all the domain names. My problem is: When I use the...

How can I create a toggle button that will allow a user to lock or unlock the record for editing?? Does anyone know??