Search results for query: *

Please don't bother anymore - found a way around: As there are only 10 numbers to find, I created an expression within an updta query that consists of nested IIf functions - solved my issue. Thanks for your help sofar! Teddy

Sorry, not realy... Teddy

Could you please give an example of how I would use this in a query? I'm not yet so familiar with these strings... Thanks for the help! Teddy

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

Is there perhaps a way to use the InStrRev function to catch a combination of a space + a number, using a wildcard for a number? This way it would work... E.g.: 1e Helmersstraat 14 Teddy

Dear Skip, Some examples of address values: Adm.gr. 15 Admiralengracht 15 Admiralengracht 15-2 Admiralengr. 15-II Admiralengr. 15-B 1e Helmersstraat 14-III Hope you can find a solution... Teddy

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

Spinalwiz: It would show the same data as the bound textbox - the data in the control is evidently not the same as the properties of the control... What I wanted is to show the focus on the particular records on hte continuous form. I guess I'll have to forget the fancy way and just stick to...

Thanks LittleSmudge, I did as advised: I have a textbox which is bound to a record, but I still struggle with the same issue. How can I create an event that occurs when the focus is on that articular text field in that particular record? Teddy

Very simple: In the property-sheet of the form, on the format tab, the last option is 'Moveable'. Set this to 'no' and you're there. Teddy

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 Ken, Sorry, the macro will only fire when the option of the combo-list is set to Limit to List... Teddy

Thanks, The setwarning to no doesn't help: according to the help-files in access the warnings should be set off before the action that triggers the warning happens. Now with the Not In List Event the action has already started, and the warning comes before the macro is run. Convert to VB - I'm...

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

Hi Sharon, Thanks for responding! Basically Access is well known to me, and if I could build a macro to do the job, I would be able to back-up the email addresses with one push of a button, and have it outside Outlook, ready to print or do whatever I would like... Besides you can put them back...

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

Hi Marc, Making time-charts is a nuisance in Excel. I use the software SmartDraw. View at www.smartdraw.com... Of course you would have to buy the program or get a copy from someone... or from Kazaa... Cheers, Teddy

Hi Skip, I followed more or less your suggestion. I forgot the whole thing about two pages per sheet. First section is a portrait page and the second is landscape. On the landscape page I created to text boxes which occupy each half of the page (each one an A5 page). Connecting the two boxes...

I think the easiest way is to export the whole address-book into excel and publish the table on your intranet...? Just follow the wizzard that you get from the file-menu > Import and Export... Teddy