Recent content by TeddyvN

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