Replies

Yeah, except it isn’t a stand alone ocx, or dll or anything, rather it is just part of the VB project as a User Control object.

I am testing the Usercontrol / ActiveX control’s visible property (ie. not a constituent control on the Usercontrol).

In your VB project explorer, right click the project and choose add –> user control.

Select ‘User Contro’ and click OK, a new user control is added to your project.

This may also be referred to as another name?

This has nothing to do with MS Excel. I am using VB6. The usercontrol is named ctlSheet1 (which you may have mistaken for something from Excel?).

There is not password and no read-only files.

I’ve never really used Data Access Pages, but as an idea, if the table you are reading out of has an autonumber field, you could base the DAP on a query that has a criteria of the ‘autonumber’ field being NULL. Once a record is ‘updated’ for the first time, the Autonumber field is then given a value other than NULL.

I have to stress that I haven’t ever tried this, but it may work?

I have certainly found the culprit to part of my problems.

I say this rather sheepishly, as the answer is a bit embarrising.

Anyway, along the way, I’ve discovered a great tool for sorting issues like this out (or at least trying to diagnose what is causing the problem). It is msconfig utility…go to the run prompt and type msconfig and it comes up!

It lets you disable services, startups from registry, win.ini and other ini files on the next boot up!

Anyway..I discovered that it was Zonealarm that was causing the problems with starting and stopping the IIS Admin service (but not the ‘folder’ problems). I traced this back to me stupidly ‘denying’ access to the internet for the IIS Admin service…however, not realising (although I should have) that this service communicates to 127.0.0.1 (localhost). I did not have this IP set up as a trusted IP, so the service could never start up or shut down. OOOPS

I still haven’t found the culprit for the folder properties, but this to me is a minor issue.

I hope this might help others out that may run into the same problem somewhere along the line.

Cheers

Jayden

Hmmm, yeah. The laptop and desktop are both very new and the desktop has fairly ‘standard’ brand-name components in it. I’d be surprised if it was the hardware.

My money is on some software somewhere. I’ve got Norton Anti-virus on the desktop and PC-Cillin on the laptap, but I’ll try uninstalling Norton on the desktop to see if that helps.

Thanks for the suggestions.

J

Also, if I try to uninstall IIS after the IISAdmin service has started, the PC thinks for a long time, then resets itself ! (ie. catastrophically crashes)

It is just a straight vanilla install of XP Pro.

I have tried it both on my laptop and desktop computers that are both running XP Pro.

Any attempt to stop the IISAdmin service (inetinfo.exe) doesn’t work. The service won’t stop once it is started! I have to start XP Pro in safe mode to actually remove the service (and IIS) – as safe mode does not run the IISAdmin service

It must be an incompatibility between software I have on my machines and inetinfo.exe. What I am really hoping is that someone may be able to tell me which piece of software may be causing it…but if not, I may just have to start the very long and laborious task of starting with a fresh install, then install each piece of software one at a time, see when IIS stops working.

Another option may be to use the Telephony API (TAPI). There are a number of articles on the web about it’s use. It is free supplied by microsoft.

Hi

If there was a missing reference, I would expect the behaviour to be the same from the immediate window also, but the function runs fine when run from the immediate window?

A guy i work with had a problem the other day, similar to this, but nothing to do with missing references. When trying to use the ‘replace’ function from a query in Acc 2000, he got the same error message, although, when using it from VBA there was no problem. The only solution was to wrap the replace function inside a custom function and call the custom function! it appears that some in-built functions in Acc do not work directly from queries.

Although this is not exactly the same situation as you, it sounds a little bit similar, but you are calling a custom function from a query.

I don’t know how much help this is, but it might ‘jog’ someone elses memory about this problem?

Cheers

Another way to do it, that I have used in the past in Access is to use the Click event of the TreeView control, then use the property .SelectedItem, to return the node that is selected: ie.

Private Sub tvw_Click()
Dim ndeSel as Object

set ndeSel = tvw.SelectedItem
msgbox ndeSel.Key

set ndeSel = nothing
End Sub

All nodes share the save event….they do not have a click event each. To determine which node was clicked, as part of the event, a node object is returned, you can use this to determine which node was clicked.

TreeView.NodeClick = Event NodeClick(Node as Object)

Important to note, that this event is actually an event of the TreeView control and not the Nodes themselves!

There might be an easier way (see Charlottes post). This is just the first way that came to mind.

Once you get over the ‘scarey’ VBA stuff, it is actually not that hard

Cheers

Jayden

here is an example database, open the form rptRangeExample

The first thing to notice is that at the bottom of the page, I am using a calculated control. The control uses two functions StartName and EndName functions.

These functions return values stored in module level variables (ie. variables that exist as long as the report does).

The Format event of the detail section stores the current name, if the mblnStoreNextName variable is set to true (this is set to true when the report is opened and at the end of each page).

The On Format event of the PageFooter section stores the last name in the last name variable, and sets the mblnStoreNextName variable to true (so that the name at the top of the next page will be stored).

Hope this helps.

I would tend to use module level variable to store the data, using the format events of the detail and page sections.