Replies

I tried your answer, but it doesn’t seem to work. Perhaps I misunderstood your coding.

The following code displayed the word ‘Welcome’ in the browser window.

var vWelcome = “Welcome ”
document.write(vWelcome)

But when I changed the code to the following, not only did I get an error message, but ‘Welcome’ was not displayed.

var vWelcome = “Welcome ”
var vWelcomeName = <%=Session("vName")
document.write(vWelcome+vWelcomeName)

Yes, that helped.
I’m recoding the function into JavaScript.

1. The Microsoft Press Developer’s Handbook series: Excel, Access, Office
2. Excel Power Programming with VBA by J. Walkenbach
3. Mastering Access 97 Development by A. Balter

I have the following code before the tag:

The sub procedure code performing the validation occurs after the tag.
<%
Sub ChangePwdButton_OnClick()
If fChangePwd.CurrentPasswordSession(“vPwd”) then
‘Alert “Either you are not logged in, or your login has expired. You must log in again.”
Response.Redirect “/memberlogin.htm”
Exit Sub
End If

If len(fChangePwd.NewPassword.Value)7 then
‘Alert “Your password must be 7 characters/digits long.”
fChangePwd.NewPassword.focus
Exit Sub
end if

If InStr(1,fChangePwd.NewPassword.Value,”0123456789″) = 0 then
‘Alert “Your password must contain at least one (1) digit.”
fChangePwd.NewPassword.focus
Exit Sub
end if

If fChangePwd.NewPassword.Value fChangePwd.NewPasswordVerification.Value then
‘Alert “Your did not re-enter the same password. Try again!”
fChangePwd.NewPassword.focus
Exit Sub
end if

Call fChangePwd.submit()
End Sub
%>

Using my formula, you no longer need these lines:

Selection.Replace What:=”99″, Replacement:=” “, LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False

Change this formula:
ActiveCell.FormulaR1C1 = “=IF(RC[10]<R[-1]C[10],COUNTA(R7C:R[-1]C),99)"

To the following:
ActiveCell.FormulaR1C1 = "=IF(RC[11]<R[-1]C[11],1+R[-1]C,R[-1]C)"

You can then remove the last lines of the code where you do a search/replace on '99'.

Another choice is to set the percentage to a number less than 100%.

That number should be small enough so that the printout only covers one page wide.

I believe Excel will honor page breaks with this scenario.

I tried this with some random numbers and it appeared to work.
Column A started with 1 and had consecutive numbers interspersed with blank cells.

However, if you don’t want column A to be erased you should change the second line to

Columns(“B:Q”).Select

************************
Sheets(“Standing”).Select
Columns(“A:P”).Select {was A:O}
ActiveSheet.Paste

I un-installed and re-installed all of the software that came with the scanner.

That seemed to do the trick.

Thanks.

Thanks,
I’ll forward the article to the hosting company.
Hopefully they’ll know what to do.

My method:

Open the web site on the server and then ‘Pubish’ to a folder on my local machine.

I’ve used two different KVMs, one unfortunately with unsatisfactory results pertaining to the mouse.

{I use a Logitech Trackman Marble +, which has a track ball, two buttons and a wheel for the middle button. The wheel performs both the scrolling and double-click functions.}

The Linksys model kvm100sk, which is a two-port model worked perfectly.

The Belkin Omniview four-port model f1db104p worked fine when I only had one computer running. However, after switching computers, I lost the scrolling functionality of the wheel until the computer was re-booted. The response of Belkin’s tech support was to stop using the Logitech mouse driver, thereby giving up the wheel functions.

Since I’ve also been in the market for a new KVM, I’ve been checking the online manuals for the different units, and they all have troubleshooting segments dealing with non-responsive mice. The universal answer is to use a plain two-button mouse with the standard Windows mouse driver.

I’ve experienced importing problems if (1) the column heading in Excel is not a valid Access field name or (2) the column headings in Excel are duplicates.

One of my clients has been using Citrix for about 3 or 4 years to collect data from field locations into Access 97 databases.

The first year was ‘difficult’ due to connection problems and firewall issues. Since then, it has worked very well, although they have occasional printing issues.

They haven’t switched to Access 2000 because they’re having problems getting two versions of Access to co-exist on Citrix and they aren’t ready to convert their existing Access 97 applications.

They are not using a web browser interface. Rather, the field offices connect via a phone line (like dialing into an ISP). Once the phone connection is made, an icon on the desktop connects to the Citrix server at the company’s headquarters. The field then sees the Citrix ‘desktop’ with Access and the other Office applications.

Are you aware of any messages board ‘scripts’ that work on an NT host with the Front Page extensions installed?

If yes, will these avoid the problems discussed in this thread?