Replies

Thanks jscher. I was able to remove the Smart Tag info in the signature to stop the Active X message from popping up, so for that problem, your solution was spot on.

NOW, however, the signature is not holding spacing. I had the font at something very small, like 9 pt., with no added spacing before and after paragraph / hard returns. But for some reason, with the Smart Tags gone, it now want’s to put some crazy spacing (almost like a double space) before and after each line in the signature. I’m sure it’s something to do with that users’ machine, but in the Preview window in the Signatures area it looks FINE. It’s only when the signature is actually pulled into a new email that it does the wonky spacing. Do you have any idea what could be causing this?

Honeslty, I never wanted to use Outlook to create the .htm signature to begin with. I created a graphic and put hyperlinks in the graphic using slices – all in Photoshop – and saved it as an .html file. BUT, since Outlook expects a .htm, it doesn’t seem to work right. Some background literature / white pages on Outlook signatures and how they operate, in general, might be helpful if you know where to locate those. OR, if anyone reading this has ever tried to do what I originally wanted to do – use a Photoshop graphic with hyperlinks AS the Outlook signature – PLEASE let me know how to accomplish this.

Thanks!

Sat

Thanks Hans – had turned off the Track Changes, but forgot the process of Accepting all the Changes.

– S

Yes, looks correct, thanks.

I assumed that there was just one small thing in the code that needed to be changed to make it look at the correct number, but not being very VBA savvy, I wasn’t sure what that “thing” was. Sorry. :-/

I need to tweak one thing, Hans. I explained which number needs to be changed poorly. It’s not the 100ths column, but the 1/100ths column (I hope I’m saying that right). So

102.13 becomes 102.1C
37.58 becomes 37.5H

Etc.

Sorry for the mix up.

Had to chuckle at your code name.

Hans! Wassup!

They aren’t doing calculations on the numbers. It’s for export / import purposes. They have an exported list from one program and they are trying to import into another program which, for some strange reason, wants a character in that last column, rather than a number. And I have no idea the logic behind which number = which character. They just gave me a list.

I’m not that familiar / good with VBA code. Would this be something easy to create? Guess you could make a macro that they could run as necessary on a spreadsheet to convert those digits?

Hans – where would you put this code in the report?

The only problem is that it would not necessarily be the “previous” record. More like “current” record as they will be doing searches (simple Finds right now, but could create a keyword query for them if need be) of the DB to see which contact information we already have in there for a specific client, and then possibly adding multiple new contact information for the same client.

I’ll read the link, though, and see if I can manipulate the example they’ve given. Thanks, Hans.

Nope – no confusion on this end (I don’t think). Then again, The Confused always say that.

I was “live” on the remote server files through FP and I had it create the DB for me (again!) in Form Properties. I had done this before locally, but since I thought something might have gotten lost in the FTPing of the site, I decided to open the web page directly through File | Open in FP and typing the URL, then adding server credentials to get in. I opened the .asp page and saw that in Form Properties the “dump to database” option was selected but when I looked at Options there was no database specified, nor could I choose one from the drop down arrow. So I just went with Create DB and it created another database. I immediately checked the folder that it supposedly created the new DB in, looked at the time stamp on the DB (still “live” on the remote server during all this), and it was the correct, current time. I went into IE and tried to enter some dummy data; copied the DB down to local machine again (no records); checked the time stamp on the MDB on the remote server to see if it changed (it has not – still the same as when it was created). So I’m stumped.

I use WS_FTP Pro to FTP the site.

The time stamp for the .mdb file that Front Page created for me does not show as updated since the .mdb was created. And I’m fairly sure I’m looking at the correct .mdb since I noted the time when I hit “Create DB” in the Form properties, and it matches up. So something’s just not happening.

I’m not sure how to make a page to display DB results through FP. Can someone enlighten me? Just haven’t ever done that before, though it’s probably not difficult given the nature of FP.

As a test I made a copy of the registration form (http://www.scctic.com/seminar/registration1.asp) and changed the form properties on it so that it would dump to my email address instead. I did not specify a file name when doing that (didn’t think that I had to) – just put in my email addy and in Options, designated a Subject line, and even went so far as to setup a Confirmation Page instead of the generic one. Didn’t have to publish it (as this time I was working in FP directly connected to the web server, which makes me nervous as heck, but figured maybe something was getting lost in the Publish process), went to that link and tested it out, and upon hitting Submit, I do not get a Confirmation Page, I certainly don’t get an email on my end with the results, and basically the IE screen just blips for a second and shows the form again, though the form has been cleared of all data that I entered. At least with the first link that was supposed to be dumping to the DB I got a “confirmation page” that LOOKED like the form did something.

MORE INFO: I am hosting this on a remote web server through Web.com. I’ve inherited this – this is the web hosting service that our company has always used for their website before I recently came on here. On the Admin panel of our site there is an entire section devoted to Front Page Server extensions. Granted, they are 2002 FP Server Extensions, but I was under the impression that even installing those on a web server would give your forms functionality, despite the fact that the pages I’m creating are through FP 2003. When I first posted these few pages up, the Submit button on the FP form would return an error. So I checked the Admin panel of the site and it said FP Server Extensions WERE installed. I reinstalled/fixed anyway, and low and behold my form appears to start working, giving me a confirmation page with form results instead of an error. I really wonder if the problem isn’t on the host server end. Which is why I wanted you guys to look at the original page and see if there appeared to be anything that I was doing wrong.

Thanks again for any input. — Sat.

The actual file is attached (renamed to .txt as it would not let me post .asp files – so just rename back). Here’s the URL of the page on the site: http://www.scctic.com/seminar/registration.asp

Sorry about that. And thanks for taking a look at it. – Sat.

I know how to do the later, although I may have bigger problems. Copied the .mdb file from the site to my local machine and opened it up and there is nothing there – no results. And I’ve been entering/submitting bogus data just to make sure that it could accept data. I’m not sure what’s happening there – I can enter info into the form, then when I hit Submit I get a nice summary/confirmation page with all the data I just typed. But…..apparently none of it is making it to the DB on the server. Any ideas?

So you’re saying that it’s the SUS’s fault that I can’t turn off the AutoUpdates? So, in theory, before adding the registry setting that would look at the SUS, I should have the ability to turn the AutoUpdates off?

As usual, thank you Hans. Didn’t realize that was called “My Places” else my Google search for technical info might have been more successful.

Hans – thanks for reminding me about this article. It’s very helpful and I tend to forget it exists.

Ran winword.exe with the /a switch and it worked fine. I’m HIGHLY suspect of the Adobe PDF Maker add-in (that installs/integrates itself in Word when you install Adobe Acrobat Standard/Professional) because the only common link in the few computers that are having this Word problem is that they all have Adobe Acrobat Professional installed.

Thanks again – Sat.