Replies

I am still amazed and awed how I can agonize over something for more than a day, but for you it is a 5-minute fix. Or perhaps less.

And I was so tempted to just address this post to Dear Hans!

ThisDocument doesn’t contain anything. There are no Document_New or Document_Open event procedures.

There is one module called basMain and it has one function called showMyForm and all it does is show the form in question.

There isn’t any Commandbars_Add or anything of the sort.

Putting the toolbar into the Normal.dot doesn’t help either, then I’m just always stuck with the toolbar, which I want only available when my template opens (and hopefully opens as a doc, not a template).

Just for kicks, here’s a copy. The functionality of the form won’t work, but maybe you can see my toolbar problem?

BRILLIANT.

That’s what happens when we let the guys upstairs create our templates and then force us to use them. I did have a sneaking suspicion at one point about that but then forgot about it, ’cause the guy who did the template is a bigwig IT guy in that department.

The lesson: NEVER trust other people’s templates.

Please forgive me for deleting the attached file, but I think the description of what is wrong with it is enough for anyone to follow what happened.

Would you mind deleting yours, too, Hans?

Thanks!!!!

LOL my psychic ability…

I didn’t remove the text from the document, but I can do that if you’d like?

Hi Hans,

Always saving me, eh? After I thought about it, I did what you said (before you said it) because I think you may have told me the same thing a long–long time ago. Somehow I never remember how to use Excel lol. But you always save the day 😉

Intuitively, though it would make more sense (at least for us Access people) if you could query within excel

Thanks!!! as always,

What should I look for? (and how should I look 😉

That was one of the very first things I thought of doing…that and changing the keyboard.

I’m not using remote desktop. How do I know if I’m using terminal services (although I don’t think I am)?

It’s pro. I tried creating other accounts, deleting all accounts and starting over, but any new account I make, even when I start over, has the same problem.

Yes, Windows is fully updated, yes, I’ve tried a variety of support sites, including Dell’s, and yes, I mean Windows logon, not Bios. It is the user’s Windows logon password that can’t be typed in at all. Opening the Guest account and then doing Switch To–>username will allow me to log into the account, but I can’t log into the account without opening the guest account.

It’s all so very odd.

Thanks for the hint, unfortunately it didn’t work. I’ve also been unable to find any answer to this question around the ‘net, although I have seen two others complaining of the same problem. Ugggggh.

Yes, I think that’s more what I’m going for, is streaming. I don’t have a functioning solution yet, but I think I’m getting closer. And I think I like the satisfaction of creating it myself, even if it’s tough going

Thanks for the info on BitTorrent, though, it’s really interesting

I had pretty much crossed BitTorrent off my list of possibilities…Isn’t stuff like this illegal?

The other side is that what I’m doing isn’t big enough to warrant a huge file-sharing scheme. I don’t want people to need to install software to hear the broadcast, because that would limit people who are not knowledgeable, and I don’t want to have to support that stuff.

The plus side is that I’ve already sort of modified some php code to read from a mysql database and write to it each time someone clicks on the file. I’ve revised the database to have the fields I need, so I’m up to the part of the selection of the site that is next in the list (which I think is the hardest part of the whole thing). The coding itsself is driving me crazy, as it’s not nearly as intuititive as VB, and I’ve still got some errors to work out, but it looks like I’m getting there!

Hi Mark–

Wow, that sounds interesting! Thanks for the link. I will definitely check it out, although for this project, I don’t think I want to keep my computer on 24/7.

Jscher, PHP is kinda what I had in mind. I was hoping someone might know of something that was already written like this (or at least the two separate parts of it), because I don’t know either ASP or PHP. Apparently I’ll be taking up a new language 😉

At the very least, talking about this has helped me map out what I want to do (heh, I think I could even write it in VB). Count # of times file has been clicked (write each click to a text file). When # of clicks exceeds the max number of clicks (which could even be read in from a text file, in case each link has a different requirement), then change to the next hyperlink. On a predetermined date (the end of the month) start the counting all over again.

Revised: a mySQL table with the following fields: ID, LinkPath, Count, MaxCount. When the link is clicked, it checks count for the first ID and compares it to MaxCount, if count is less than MaxCount, then use the LinkPath for that ID. If not, go to the next field and try the test again. When it finally finds an ID it can use, it increases Count by one and serves the link. Now I just need to learn PHP.

Thanks for your suggestions!

Hi!

Well, that is part of the problem. The few scripts that I have seen that do this sort of thing are big & complex. I was thinking that if I could count clicks on the file, which I have seen many people do, then I could estimate how much bandwidth is being used based on the size of the file. If I could write a script that shuffled the links, then it would probably do what I need it to, because I could just display one of those links based on how many times it’s been clicked that month?

Does that make sense? I was kinda hoping to find someplace that I could find the pieces and maybe put them together, but I’m not exactly sure how to go about it.