Recent content by Maestro

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

Perfect! Thanks.

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

Oops! well spotted. If only everything were that simple to sort out...

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

Thanks, Chris. That works much better now EXCEPT that dates have to be entered in American format mm/dd/yy to be recognised, and my organisation is UK based so we'll have to remember to swap the format around each time we use it. Like operator still gives a run time error unfortunately. I never...

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

OK problem sorted - thanks for your responses! I think the main reason for the code not doing anything was that being in te On Open event it ran only for the first record, so it's now in On Current. I can also answer the second part of my question, and it goes something like: If DateAdd("d"...

Excellent - thanks for that! There's still something not right though. When I now open the form the code comes up with: "Compile Error: Else without If" I now have the following, where access has added the ":" after the 'else' in line 2. Any ideas? Private Sub Form_Open(Cancel As Integer) If...

Just to bring this one back from the dead, I've been trying to do something similar with a membership database I'm developing. For the On Open event I have: If Me![expdate] < Date() Then Me![expdate].BackColor = "255" Only problem is that this seems to be wrong because Access automatically...

In a database I'm creating I want a field that shows the date and time a function was last used (in this case a backup being made). I've used this line of code in the On Click event of the command button and it updates an unbound field on my form called 'pubdate'. Only two problems: - On...

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