Search results for query: *

I need to enter a wildcard for a number in a function: InstrRev - is this possible? To keep it short: I need to separate the street from the housenumber in an address field. I wanted to do this by using something like the following expression: Mid([straat];InStrRev([straat];" ")+1) --> this...

I have got a table where in one field I have complete addresses: streetname and housenumber. How can I separate them both into two fields? I thought of finding the position of the space between the street and the number (" #") and then doing something with the position given... But what and...

Dear all, I have a database in which a search can be performed. The results of the search are then displayed in a continuous form. Each record in this form has a button next to it on which you click to view the complete record info (in a normal form that opens). What I would like is that the...

Hi, I have a combo-box on a form that is limited to the list displayed. What I want is to run a macro on the Not In List Event, so that I can enter new items in my combo-box. The problem is that Access displays an error message when you enter a not-listed item, which prevents my macro from...

Dear all, I have a simple form that has a selectionquery underneath in order to see the records on alphabetical order instead of by the autonumbering feature of the table. I now would like to perform searches to for example the last record - with a "Z", but the only "last...

I would like to backup my email adresses from my pst-file into an access table. I can open Outlook and export the addressbook to an access database without any problem. But to make it easier I would like to import the adresses in Access with a macro. But when importing I cannot import all the...

I have a Word template in which I want 3 pages on two sheets. The first sheet has one page only and the second sheet must have two pages (A5-sized). In the properties of the Page Setup I can create two sections in which the first one has a portrait layout and the second a landscape layout. But I...

Hi there, I have an SQL server running version 2000 and one still on version 6.5. Before upgrading the latter I would like to transfer the data from one to the other... But when trying to view the 6.5 server in the 2k one it doesn't get the connection right: "Server is not running or not...

I have a text field in a table where years are entered separated by comma's, e.g.: "1999, 2000, 2001". What I would like to do is, in an update query, get the last 4 characters out of this text field and put them in a number field... From this example the numbers 2001 would end up in...