Recent content by Islwyn

Hello, My system is the other way around but I haven't yet had any need to look at something saved in 2003 on my laptop (2000) and I've just reduced my macro security settings to low to get rid of the infuriating security messages - since I'm only working with my own databases and trust my...

Many Thanks Tom, I did do a search in Access help but found nothing except converting Access 97 to 2000 or higher - I should have gone straight to database utilities! Thanks again.

I have a friend with Access 97 who wants me to make him a database, but I'm running Access 2003. Before I get going can anybody tell me whether this will this work, and if not is there a way of converting it (in the same way that you can save a word file as a Word 97 file)? Many thanks Cheers...

Many thanks - that seems to work within a single form but not with two forms open (i.e. refering to a second form that is open) There is no error this time but the form simply isn't requeried. Any ideas? Thanks

Hi, thanks for your answer I have tried that but all I get is an "Object Required" message so it isn't finding "YOUR_OTHER_FORM" despite the fact it is open. With regard to the underlining query how do I use a wildcard in my query which filters using the value in the textbox? In other...

I want a form ("booksearch") that contains a list of data to be instantly updated from a query ("querytitle") whos source is a box in another form ("findbook") (or perhaps in the header of "booksearch"). In other words I'd like the list to be instantly updated as I type each letter. Could...

Does anyone have any ideas why somebody else should get the below error message using XP with a newer version of Access than me, but I do not - the error message simply can not be true if the V. Basic code is working! " This record has been changed by another user since you started editing...

Cheers, Thanks for that - I knew there'd be a simple solution.

Hi, I want any changes in Textbox1 to be shown instantly in Textbox2, the instant I press the keyboard. I have tried putting the following [Textbox2]=[Textbox1] in code under [Textbox1]'s On Change, Key up, Key Down, Key Press etc event options but no changes occur until I click somewhere else...

Hi,here's why your solution does work. What I have is a Main Form with FieldOfficer and County combo boxes. These filter FarmRecords on a sub form. If a new farm is added for a specific county and field officer the records remain in chronological order because they are ordered by the FarmID...

Thanks RoyVidar, that nice and simple and works perfectly. And thanks everyone else for your time Cheers Islwyn

Thanks Gol4. Unfortunately this is a little bit too alive for want of a better word. It works well at first but jumps around more and more eratically as you scroll through the list. By the way the reason I want this is because it has been requested for some silly reason. Something to do with a...

This is probably simple but it's driving me up the wall. All I want is a textbox on a continuous form that indicates that this is record 1, record 2, record 1200 or whatever out of the filtered or queried table. So basically what I want is the number that's displayed next to the navigation...

OK I've finally got it working but there must be something my OS doesn't like about the first lot of code I tried, it either crashing, freezing or giving me that initial error I had at the start. I've ended up using the code at http://www.mvps.org/access/api/api0001.htm combined with the...

Hi, I've managed to get it half working somehow. It seems there was some kind of problem with the word "shellBrowseInfo" and when I changed it to another word (Nickstype) it seems to have stopped the error. The problem I'm having now is that the files always go to the root of the C...