Search results for query: *

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

...query how do I use a wildcard in my query which filters using the value in the textbox? In other words I want something that finds "the*" or "*of the*" This is what I thought would work: SELECT BOOKS1.[Author], BOOKS1.[Title], BOOKS1.[ISBN] FROM BOOKS1 WHERE...

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

...FLOCK TABLES " & todaysdate & ".mdb" 'Ask for SaveFileName strFilter = ahtAddFilterItem(strFilter, "Access Files (*.mdb)", "*.mdb") strSaveFileName = ahtCommonFileOpenSave(OpenFile:=False, Filter:=strFilter, _ Flags:=ahtOFN_OVERWRITEPROMPT Or...

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

OK Thanks, I'll have a fiddle with it and any more suggestions as to what might be preventing it working would be gratefully accepted - I'm using ccess 2000 if that helps. Could it be something to do with how I'm opening the program (i.e. something like open exclusive) or am I just showing my...

Here's the entire code in the form: 'global declarations Option Compare Database Option Explicit Type shellBrowseInfo hWndOwner As Long pIDlRoot As Long pszDisplayName As Long IpszTitle As String uIFlags As Long IpfnCallBack As Long IParam As Long iImage As...

Sorry, I just copied the entire piece of code into the Basic Editor. How exactly do I find the global declarations for the entire form? I've clicked on form but it already has the code at the top. Should I precede the code with some kind of statement? Cheers Islwyn

Sorry, I just copied the entire piece of code into the Basic Editor. How exactly do I find the global declarations for the entire form? I've clicked on form but it already has the code at the top. Should I precede the code with some kind of statement? Cheers Nick

I know what it feels like to be a beginner! If you look at the properties of the combo boxes in design view (click on them then right click properties) you'll see a load of options. Under data you can see row source. Just insert the following code into the row source box SELECT...