Replies

No problem. You should be able to do the same thing with a php page. I’m just not sure what you need to do there. Only PHP I have written was for this post 222317, which creates a dynamic sitemap for your site, based on the Navigation Structure that FrontPage uses.

All of those API’s are in the MSDN. Regions (what you use to shape forms) aren’t that difficult to use.

You can do this with an ASP page.

Function RedirectForUserAccount()
dim strUserName
dim intPos
strUserName=request.servervariables(“QUERY_STRING”)
intPos=instrrev(strUserName,”/”)
if intPos>0 then
strUserName=mid(strUserName,intPos+1)
end if
If CheckIfValidUser(strUserName) then
response.redirect “”/myCommunity.php?action=blog&user=” & strUserName
End if
End Function

Function CheckIfValidUser(strUserName)
‘Check your user database if it’s a valid user account
‘Return this function based on that check
End Function

Put the first function in an .asp page, create the section function to validate whether or not ‘strUserName’ is a valid account name or not.

Now, the key is to trigger that page. You need to setup that page to get page not found errors. Go into the properties of your website, and go to the Custom Errors Tab (I use IIS 5.0, so things may be slightly different with your version, but probably not much. Find HTTP Error 404. Edit the properties, set Message Type to URL, and URL: to /yournewasppage.asp.

Now, when someone goes to http://www.freshties.com/Drew , if Drew is not a valid directory or page on your site, it will redirect them to your new custom ‘page not found’ page, which then uses ASP in the first function to send ‘Drew’ to the second function (which you’d have check your database of users, to determine if ‘Drew’ is a valid account name’), and if it’s a valid account, it redirects like you want. If not, you’d want to have a ‘page not found’ error come up.

Hope that helps!

No idea on the pivot table thing. Not my ball of wax..

Okay, here’s the deal. Access 2000 and up act differently then Access 97. In Access 97, you could simply use the ShowWindow API to hide the Main Access Window, and all you had to do, is turn on the Popup Property of your forms.

They made some changes to how they subclass the windows for forms in Access 2000 (and up). Because of this, it was ‘noted’ that you had to also set the Modal Property to Yes, along with the Popup Property.

That is a problem. It works, but having the Modal property on causes a few problems. According to the help : You can use the Modal property to specify whether a form opens as a modal form. When a form opens as a modal form, you must close the form before you can move the focus to another object.

That’s a pain. What good does it do to only let one form open at a time?

A while back, I was on a mission to help someone out with a pet project of theirs. They wanted an Access Form that is ‘Always On Top’. (Like the Task Manager window, above all other windows). Microsoft’s knowledge base lists the way to do this is with a timer on the form, which constantly ‘pushes’ the form to the top…… YECK! . I came up with a better way. No timers, and it works like a charm. In doing so, I discovered a way to get around the Modal property issue.

I am attaching a sample database that I put together for someone. It does a few things. When it opens, you’ll get frmMain. There are buttons for frmOne and frmTwo. frmTwo will open with a different shape. All the forms will appear on the desktop, and there is a ‘Minimize All Forms’ button, which minimizes the forms, and leaves a ‘bar’ in the Status Bar, so that you can click it to return to the forms (and the Main Access Window stays hidden).

Note the tricks to the trade with this: When the main form is closed, it unhides Access (won’t leave ghost Access Applications running….though, you can create a simple routine that unhides hidden Access windows….it’s pretty easy….). When a form opens, it calls the ShowWindow API on itself, which is what gets around the ‘Modal Property’ issue.

Hope this helps!

Drew

Getting closer. There is a specific type of ‘window’ which the clues point to. The ‘moving’ focus is the catch. It’s a little known design quirk of something specific in a particular office application

Good guess, but the answer needs to be much more specific. There are enough clues to figure it out, though it is VERY technical.

Let’s say you had this as the URL: http://www.somesite.com/SomePage.asp?SomeValue=12345

In somepage.asp, in the HTML, you would need something like this:

<input type=textbox name="SomeValue" Value="”>

Hope that helps.

No problem, glad it helped.

No problem, glad it helped.

Rule #1. The registry is your friend.
Rule #2. To really customize windows, you must modify the registry
Rule #3. If Rules 1 and 2 mess up your machine, you can always reinstall the OS.

Okay, seriously, one of the reasons I love the Lounge is because I always find a post that let’s me just plain experiment. Here’s how to do what you want. Take your VB .exe. I wrote a simple one like this:

Sub Main()
msgbox “””” & Command & “”””
End Sub

I called it filetest.exe, and compiled it to the root of my C: drive.

Then, go into your registry (and here is where all warranties and promises go away, do this at your own risk! ). Find HKEY_CLASSES_ROOTAllFilesystemObjects
If there is not a key called ‘shell’ (no quotes), then add it. Under the new (or old) shell key, add a new key with the name of the text you want displayed at the top of the ‘right click’ shortcut menu. In my instance, I used Test VB. Then add a key under that new key called ‘Command’ (no quotes). In the default value of that key, I put ‘C:filetest.exe *1’ (again, no quotes, and replace the * asterick with a percent symbol. It’s not posting on the lounge right, so I had to change it!). Now, on every file and folder in Windows explorer, I get a Test VB option in my shortcut menu. Clicking on it displays the full path of the file/folder I am over.

So, in summation, you would have this displayed in regedit:

HKEY_CLASSES_ROOT
AllFilesystemObjects
shell
Your Custom Process Name
Command

Hope this helps.

Rule #1. The registry is your friend.
Rule #2. To really customize windows, you must modify the registry
Rule #3. If Rules 1 and 2 mess up your machine, you can always reinstall the OS.

Okay, seriously, one of the reasons I love the Lounge is because I always find a post that let’s me just plain experiment. Here’s how to do what you want. Take your VB .exe. I wrote a simple one like this:

Sub Main()
msgbox “””” & Command & “”””
End Sub

I called it filetest.exe, and compiled it to the root of my C: drive.

Then, go into your registry (and here is where all warranties and promises go away, do this at your own risk! ). Find HKEY_CLASSES_ROOTAllFilesystemObjects
If there is not a key called ‘shell’ (no quotes), then add it. Under the new (or old) shell key, add a new key with the name of the text you want displayed at the top of the ‘right click’ shortcut menu. In my instance, I used Test VB. Then add a key under that new key called ‘Command’ (no quotes). In the default value of that key, I put ‘C:filetest.exe *1’ (again, no quotes, and replace the * asterick with a percent symbol. It’s not posting on the lounge right, so I had to change it!). Now, on every file and folder in Windows explorer, I get a Test VB option in my shortcut menu. Clicking on it displays the full path of the file/folder I am over.

So, in summation, you would have this displayed in regedit:

HKEY_CLASSES_ROOT
AllFilesystemObjects
shell
Your Custom Process Name
Command

Hope this helps.

Sounds like you should really have this as a little database application, and display the HTML with asp. That way the asp will update the colors automatically.

Sounds like you should really have this as a little database application, and display the HTML with asp. That way the asp will update the colors automatically.

Got it. DIOXIDE is upside down too, just like Carbon is, but DIOXIDE is the same upside down or not. DUH! Don’t know why I didn’t catch that. It wouldn’t work if you used carbon dioxide, instead of CARBON DIOXIDE.