Search results

I'm trying to find a quick way to swap a selection of data in one row of a table (not necessarily the whole row) with a selection of data in another row. The selections are the same size, ie. Select data in row 6, columns 6-10 inclusive Move to row 8, columns 6-10 inclusive and Select data in...

I have a form based on a table containing records about members of a society. On the form I have an unbound list box that draws information from a query (to list members whose membership has lapsed), with 'ID' being the bound field. I want to be able to set things up so that when I click one of...

When I run an update query to update one table in my database with information from another table I'm getting problems with a field for an address. I have my table set up so that addresses are entered into one field rather than separated into several different fields for street/town/county etc...

My database uses a query based on several tables, and I've just added a feature that exports an excel spreadsheet of the query a) to back up the information, and b) so that the XLS file can be distributed to enable other users to update their copy of the database. The problem is getting the...

When I click an "Exit" button on my form I want the database to prompt the user to confirm before exiting. The code I'm using below for some reason works fine at home on my Win '98 machine but not at work on my NT machine ("Compile Error - Can't find project or library"). It doesn't seem to...

Using te same method as I mentioned recently I'm trying to have a field on my form to enable me to filter records by their date. Code I'm using is the same as the text variables on the After_Update as follows: Dim strFilter As String strFilter = "[ExpiryDate] = '" & Me.srcExpDate & "'"...

I have a form based on a query. I am trying to create a search system which uses filters to narrow down the number of records displayed. At present though, it can only filter based on one criteria at a time. I have each text or combo box with the following code as the after_update event: Dim...

I am trying to set up a form which uses a list box drawing its information from a number of queries. In order to select the query from which the list box sources the information it displays the user clicks on one of several option boxes causing the information shown in the listbox to change. The...

This has probably been answered before somewhere, but I am trying to add a method of searching to my form that uses filters. The form sources all it's information from one query. Ideally the user should be able to, for example, enter a name into a text box and then the on_change event applies a...

An easy one for someone, I hope.. Every time I try to run an [Event Procedure] from my form, whether it's one I've coded myself or even a simple delete or search records command generated by the wizard I get the following error message: "The expresson On Click you entered as the event property...

How do I get access to pop up a warning/reminder message two weeks before the date in a date field is reached?

My database holds the details of all the members of a club. I would like to add a button to the form that, when clicked, opens up a new message window in Outlook Express (not Outlook) with the email address of that particular member already entered. Not entirely sure how to go about doing this...