Replies

>>SharePoint uses a combination of file system and database to build web pages. The file system “stuff” resides in C:Program FilesCommon FilesMicrosoft SharedWeb Server Extensions12 and C:InetpubwwwrootwssVirtualDirectoriessharepoint-site-name.

Thanks for giving me the location. I don’t want to mess with the Sharepoint files, but would just like to add code to redirects the url to the the default page I built to open vs the companyweb page openning.

>>Just to be clear, when you try to access your website from a workstation you get a 404 error correct?

This is correct. The IIS settings “appear” ok. The issue only happens when they use the link from the companyweb page that they open directly on their workstation. If they remote in to view the company intranet website, the link on the companyweb works.

<<Have you checked the site settings in IIS Manage?

Are you asking if I checked the IIS on each individual workstatin? If so no and it would be an issue if I have to configure each workstation. I've only worked with the IIS on the server.

Leesha

Regarding the company web, I would only be guessing at how you add or edit information. Is it a page you edit and upload? Or is it part of a wiki or content management system that you edit in the browser?

Actually it is the web that is on the agency server and is installed when the server OS is installed. Is’t a sharepoint web. It allows the users to add links etc. It took me hours to find how to delete them.

>>If the company web server supports ASP.Net, you could create a new folder and copy your application there. If it is outside the existing web site, you probably will need to use the IIS MMC snap-in to set it up. If it is a folder within the existing web site, there’s a good chance it will “just work.” I suggest lots of testing before redirect any existing page to the new one(s).

I’ve searched and searched as well as googled the topic for hours and can’t find where this sharepoint web is. The site that I need to let the users get to is set up as the default web on our server. I finally got it to open from the link by putting in the remote desktop path that I use to get in from home, followed by the name of the folder that the website is in then the homepage name. That works as long as the user the remotes into the server. If they try to open up the link from the “companyweb” (which their IE automatically defaults to when they click in on their workstations) the link won’t work. I’m assuming its because they aren’t actually logged in remotely to the server at that point, but just to their workstations. It’s a poor fix, but its a start.

== Edit ==

Leesha

Hi,
Tried putting in local server and still not luck. To make matters worse in doing this I added links as well as items to the company web and now can’t get rid of them. I’d kill to just get rid of this page and have my page load. Is that possible and if so how do I point to it vs this stupid company web page?
Thanks,
Leesha

The link is something like http://servername/folder/default.aspx ?

the link is http://localhost/default.aspx. I tried your path up above with our info but that didn’t work either. I don’t think its security issues as we log in using windows authentication to ge the company intranet and that works fine. If I log directly on the server it opens up fine from the companyweb main page. The error I’m getting is a 404 error but even after googling it and following some of the info on the links I coudln’t get past it. Ultimately I’d love to bypass the “companyweb” completely and have the default.aspx for the default web open up. Do you know how to do that?

Thanks!
Leesha

Could it be a security issue?

I tried the asp.net forum from microsoft which has helped from time to time, however responses are slow in coming and rarely clear. It is NOT the lounge that is for sure!

Leesha

I learn a lot from the Lounge, both by studying the great solutions provided by others and by doing research for the replies that I post. I can apply much of that in my work, so I can do my job better because of the Lounge.

I hear you on that one! I’m floored by all that the I’ve learned here (mainly due to you patience and turtorials) over the years and how much I’ve applied to my own job and in helping others in my office or friends. I will admit its much easier or I should say less intimidating to jump into something when I know I have the lounge to turn to for help. That is why this how endeaver with asp.net has been sooooooooooooo hard and frustrating!!!

Leesha

That’s not going to happen – I use Access, Excel and Word in my daytime job, but not ASP or ASP.NET, so I have no incentive…

OMG! How do you find time to work a day job with all that you do for us here!!! I’m in awe, moreso than ever!

You can run an SQL statement to update the purchase table:

Dim strSQL As String
strSQL = “UPDATE Purchase SET Closed = True WHERE [po order] = ” & Me.txtPO
CurrentDb.Execute strSQL, dbFailOnError

This assumes that po order is a number field. If it is a text field, change the line that sets strSQL as follows:

strSQL = “UPDATE Purchase SET Closed = True WHERE [po order] = ” & Chr(34) & Me.txtPO & Chr(34)

Hi Hans,

PO Order is an autonumber. I’m not sure is the makes a difference or not. I used the first part of the code that you gave me, making one change. The table is called “Purchases”. I had left out an “s”. Anyway, I get an error that says “Too few parameters. Expected 1”. I’m not sure what its looking for or if the autofield makes a difference.

Thanks,
Leesha

According to the user, these tables were added during some testing on the database years ago when it crashed. He states they aren’t necessary. I didn’t do the “show all” (another new learning experience) and sure enough now I’m not getting the error.

Thanks!
Leesha

I don’t get an error message. A new record appears in the Shipping/Invoice table (the record source of the form opened by the “Ship this order” button.

Really? I just tried it again on my laptop and on the users workstation and we both get the error. If there is no number in the contract number text field it will close, but once there is a number (in the sample case I sent it should be 1234-abcd-5678-e) it gives the error re the contracts1 table.

Can you tell I’m sick of this one! I sent the wrong zip!

Leesha

Forgot the DB file!!

Thanks! I’ll look into this.

Leesha

This worked perfectly. The headers and the totals are there. I’ll have to save this code to my “cheat sheet” files! Now lets hope it works in 2007 LOL. Worked great in my 2002 version.

Thanks,
Leesha

>>It is possible to export an Access report (not the query) to Excel, and then use Automation to open that file so it is visible on the workstation.

This is what I’m trying to do but am not totally sure how to code it.

>>However there are issues with 2007 unless you have SP2 installed. And I’m not sure about totals lines the bottom – they should work, but…..

Figures!! And of course this is yet another account that has a mixture of Access versions. I grow to hate 2007 by the day. I know this is because I haven’t worked it in enough to “think like it”.