Replies

The [3] and [4] are reminders for me in the source code used to create the events
– I use some code based on example in the ADH which replaces the [1] [2] [3] etc. with specific values, e.g. the builder version is [1]
In this case the main form name, frmMainMenu, replaces the [3]

Thanks for the suggestion of the Me.Parent
– the tab is on the parent, and the tab page should always be the visible one
I’m still puzzled as to why the problem occurs in XP, but not in 2000 or the original 97
– I put the dummy control on the subform as a way to get the focus back to the main form, so uses selects and enters a new value, then can tab back to the main form. In XP, the dummy control event seems to be always happening first, so the data entry controls can never get the focus

The problem isn’t solved
I still need to work out which the dummy control’s GotFocus is blocking selection of any of the other controls in the sub-form in XP, but it works in 97 and 2000
I suppose I really need to clean up the way I manage the form and sub-form focus. My dummy control was a “quick & dirty” means to always ensure the focus was pushed back to the main form, as I was enabling/disabling various controls on the sub-form

Sub DummyCtl_GotFocus()
‘ Builder version 1.4.3
‘ Auto-created by Admin on 26/02/2002
‘ Force the focus back to the main form

Forms![frmMainMenu]!tabItems.Pages(“Page3″).SetFocus
” [3] main form name
” [4] page name
‘
End Sub

Charlotte,

the original file was in Access 97 format, and I converted it to Access 2002 format. I’ve just tried converting to 2000 format using 2002, and get the same effect
Ah, I remember putting a dummy field on the sub-form with an event on its GotFocus to do some checking – well remove it and the fields are again live, so it looks like it’s something different about the way 2002 handles the event, compared to 2000 and 97

Don’t you set this in a queries properties, using either the Unique Values or Unique Records
Or do you mean actually delete the duplicate records from the table , in which case I’d likely use a Make Table query, with the appropriate Unique property set

Could you post the code, might be able to spot the problem

I think you hit the nail there Charlotte, as I’ve recently put a copy of Visio 2002 on my machine
Next question, is there any other way, apart from installing an Office XP application, of updating someones VBA

I’ve got a problem with an Access 2000 database of mine generating an error 3071, “expression is typed incorrectly or too complex”, on someone else’s machine, actually via Citrix on NT4 Terminal Server, which doesn’t appear on mine, stand-alone Win2000, and the first thing I spotted that was different was the VBA.

Could you move this thread over to Access please

Thanks Charlotte, it certainly looks like the VB equivalent of Rick’s add-in,
and yeap, it’s pricier
Have to see if my boss will pay for it

Sorry about that
– first time I’ve tried adding a hyperlink, and I get it wrong
– Jefferson’s got the same address, and he knows how to put the links in
Changed the reference in the test harness, the intermediate dll and my dll, and it works, so I’m but

Nope, the only reference was to Microsoft XML, v4.0 (which is msxml4.dll)
The only change to make the program work was the commenting out of the Document40 versus Document30, no changes to the referenced DLL
Just getting started on using XML, hah, wish work had sent me on at least some training, I feel that a lot of my problems are ‘known’ issues that an expert would answer easily, but takes me a lot of time to find by looking through books and web searches.

I got the MSXML 4.0 RTM parser from the Microsoft site at http:// http://msdn.microsoft.com/downloads/defaul…ompositedoc.xml [/url]

Not standard (yet) in Windows/IE – just checked the Microsoft DLL Database (well recommended) at http://support.microsoft.com/servicedesks/…nfo.asp?sd=TECH [/url]
and it shows that even WinXP only ships with the 3.0 parser, and in fact a search for msxml4* doesn’t get any hits, so maybe the RTM status means that I should go back to using the MSXML 3.0 for the time being

What am I using it for, taking a data query from an ASP page, posting it into our database, then pulling out the users response to the query, and posting it back to the originator, at least that’s the goal

Now upgraded to SQL Server 2000 and it works Ok, so something to do with 7 ??

(1) have you experienced the problem highlighted in Charlottes warning?
(2) have you tried the Microsoft Knowledge base “steps to reproduce the behaviour” to see if you have the problem?
at http://support.microsoft.com/support/kb/ar…s/q304/5/48.asp

That’s exactly what I’d like to have as well, 97 + 2000 + XP
I’ll keep the fingers crossed ever so much
Cor doesn’t half make typing difficult

I knew it was a good idea to check here first
Hopefully you can find out how Mike has managed
and let us all know the answer

(and I was really wanting to try Access 2002)

Oops – missed the preview effect on attachments

I prefer not to do this, I’ve sometimes had problems with Compact, so I like to have the choice

Instead I’ve got a Compact option on my right click menu (and Decompile as well)

http://ourworld.compuserve.com/homepages/a…ip.htm#Compact2

Attached is my registry entry for 97