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

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

Thanks to 'charityg' I have been able to eliminate the problem, the code was full of duplicated procedures and basically needed a bit of a tidy up. However, hoving now deleted some of those procedures, whenever I attempt to read the code of my form I get a message telling me there's a DLL...

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

A good idea but unfortunately it doesn't work like that - if only life were so easy! When I tried RunApp it would only recognise paths pointing to .exe files, anything else just threw up an error message. I tried making use of the example given in the downloadable example forms on Microsoft's...

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