Replies

What file did you try? The file I posted to this thread, or the finished file, that I posted in a new thread (which I have a link to in the first post….I just added that link the other day.)?

I wrote a NT Service in VB, that runs every night. It browses our entire website, recording each pages text into an Access Database. (Just the text that the user would see, no HTML code, etc.). Then I have an ASP page that querries that database for search results. If you are interested, I’ll post that project.

I’ve got a wierder FP theme issue. We have a custom theme, and I went into the CSS page and set the background to be fixed (so everything scrolls ‘over’ the background). Whenever we made a change to the theme, we would lose that effect, and i would have to go back in and manually replace it. However, I did something to the theme at home with FP XP (We use 2000 at work), and since that time (I am guessing that was the catalyst), we don’t loose the custom effect when we change the theme.

Wierd eh?

Did the .php version work?

What application are you developing in?

I have been busy moving this weekend, where are you at on this? Just want to make sure you get this finished up.

Okay, just remember that it’s only right 15 out of 16 scenarios. With all the combinations of the Popup Property, Modal Property and whether it’s called up as dialog or not, when it’s Popup, but not Modal, and is called normally, then it will be wrong…a false positive.

(Of course it is only detecting that it’s dialog too….not whether it’s modal. The only time it is accurate there is when the Popup property is No.)

I wonder which way is faster…I would bet dealing with the Time as a number, versus a string is faster, since it ends up as a number anyways.

Of course there are usually 50 ways to make the deal when dealing with dates and times.

Before you know it’s an IE issue, you need to verify that it’s not your network. Look at the ‘script’ setting. It should be a path and file name. For example, ours is http://wpad.marlow.com:8080/wpad.dat

Which means it’s a file called wpad.dat, which you get by hitting port 8080 on the server that translates to wpad.marlow.com. That translation can only occur in house. I can ping wpad.marlow.com in house, and I’ll get an IP address, which is the IP address of our proxy. However, if I ping that outside, from the internet, it won’t come up with anything, because it’s not supposed to translate. Thus, the ‘Automatically detect proxy’ determines the proxy isn’t there, and tries to just use the internet through your gateway.

However, if for some reason, they changed that script or the server, so that it can be ‘reached’ from the internet, then your browser will see the proxy, yet the proxy may refuse requests from the other side. So look at your script, and when you are away from work, try to ping the server (or even put that script into your browsers Address bar, see if it brings up a file. If it does, there’s your problem, if it doesn’t, try to repair IE (go into the Add/Remove programs, and when you try to uninstall it, one of the options should be a repair option.

Just make you ‘detail’ forms so you can use to Filter argument on the OpenForm command show only the data you want.

Option Compare Database
Option Explicit
Private Declare Function GetClassName Lib “user32” Alias “GetClassNameA” (ByVal hwnd As Long, ByVal lpClassName As String, ByVal nMaxCount As Long) As Long
Property Get IAmADialogForm() As Boolean
Dim strTemp As String
Dim dwReturn As Long
strTemp = Space(255)
dwReturn = GetClassName(Me.hwnd, strTemp, 255)
strTemp = Left(strTemp, dwReturn)
IAmADialogForm = strTemp = “OFormPopup” & Chr(0)
End Property
Private Sub Form_Open(Cancel As Integer)
If Me.IAmADialogForm Then
MsgBox “Yes”
Else
MsgBox “No”
End If
End Sub

Put that code in the code page of your form. (It’s the entire page of the form I just wrote…..) As long as you have the Popup Property set to No, the IAmADialogForm property works fine. If Popup is Set to Yes, then that property indicates true all of the time.

If you REALLY REALLY need to have this when a form is also designed as a popup, then I can look deeper into it for ya……

“Never trust the experts…..”

dim dtTemp as Date
dtTemp=Format(Me.txtst,”dd-mmm-yyyy”)
dtTemp=dtTemp+(1/3)
rs.(“MyDateField”).value=dtTemp

Of course, you should haven’t use the format command, to enforce a date. Just set the textbox to be a date format. 8 am, is one third of a day, so it is probably the easiest way to set the time at eight, is to just add 1/3.

Mr. Ken?

Well, this sounds SO FAMILIAR….I wonder where I have been asked this before!

I would recommend using the first option, where you store the Hire and Term date.

Then, what I would do, as far as displaying this information, is to make the Employee form have a subform, that displays (READ ONLY) the Hire and Term dates of the past (where BOTH dates are filled in…..so only a complete Hire/Term date). I would then have two unbound controls on the form. The first unbound I would fill with the Hire date from the record with the ‘missing’ Term date. Then the second Unbound control would be the blank term date. Filling that in ‘terminates’ the employee, and adds the missing date to that record. If no records are found with a missing term date, I would leave the first unbound control blank (and disable/lock the Term unbound textbox), so that it is ready to hire them again…showing they are not current employees.

Thus, to determine if someone was active or not, you don’t need a max, just a search for a blank date field!

Hey, I just edited the original post, it now has a link to the PHP version of this. Try it on your site, it should work just fine for you.

Drew

A few weeks ago I posted about a Dynamic SiteMap page, that used an ActiveX .dll that I wrote in VB. I had a comment or two about VB ActiveX controls, since not all hosting companies allow for ActiveX controls.

Attached is an .asp page that creates a dynamic sitemap using FrontPage’s navigation file. (In other words, the page will always show a site map built from the current navigation). This page does NOT use an ActiveX .dll, it is strictly ASP. So obviously you must have a service provider that allows for ASP. The only quirk I can think of, which may trip this code up, is that it uses the FileSystemObject to read the FrontPage data file. If anyone has a problem using this page due to that, you may be able to use ADO to read the file. Let me know, and I’ll look into it, or if you rewrite it with ADO, post it please.

One last thing. It displays in three different ‘modes’.

sitemap.asp or sitemap.asp?View=Indented Builds the page with the links being indented. (Looks fine, but source is full of