Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. SarahG

    Secure FTP through ASP won't complete

    I'm using classic ASP/VBScript and want to call secure FTP (PSFTP) to transfer a file. When I open the page it just hangs. My IIS uses an internet guest account called xxx. I have verified that: - the PSFTP command is constructed correctly - the PSFTP command runs without error from the command...
  2. SarahG

    Need to mailmerge from secured database

    Hi, I have an access database with security enabled so that the Admin user can't open it. However, I can't point Word's mailmerge at the database now. Is there a setting in word that I can put in a userid/password, or set a connection string to the database so that Word can access the database.
  3. SarahG

    Subform link lost

    No I don't. I can put it in easily enough and wait for it to happen again. This is the problem, you see, the error is spurious, but I'll try that and let you know how we get on.
  4. SarahG

    Subform link lost

    Hi, I have a form (based on TableA) with two sub forms. Each sub form is on a different page of a tab control. Each subform is based on TableB. So when the user types in something in the first sub-form, a record is created in TableB. Then when they switch to the second sub-form, they edit that...
  5. SarahG

    IIS - detailed error messages OFF

    I can set up the custom error pages, that works ok. However my original aim was just to send back one generic message from IIS - I'm confused as to why this doesn't work. As far as I can see it should be a simple matter of changing the setting in IIS to "Send text error message to client"...
  6. SarahG

    IIS - detailed error messages OFF

    I want to disable detailed error messages being sent to the user. I've changed a setting in IIS (Home Directory-Configuration-Debugging) so that a specific message is to be sent to the user. However this doesn't seem to be taking effect. I have commented out any "On error resume next" and...
  7. SarahG

    Losing session variables

    The Web Garden setting seems to be the culprit. It has been set to one and IIS restarted (through the Services list rather than through the console). What is very confusing however, is that I confirmed this setting was one after I originally set up this thread as it was flagged on monksnake's...
  8. SarahG

    Losing session variables

    Thanks for your replies. Nothing has worked so far, it produces this problem on the server itself, so firewalls & networks are ruled out. All the links are relative, there are no underscores in the server name, I've ruled out caching problems . I'm at the end of the lsit, and can only think...
  9. SarahG

    Losing session variables

    Monksnake - That's a great site thanks. However it's none of those things. Sheco - I'm the only developer and the IT manager & myself are controlling IIS to resolve this, so if it's being reset it's not by us. Basically our IT dept followed a list of recommended tweaks on the server to tighten...
  10. SarahG

    Losing session variables

    I have edited the application so that each page prints out the session variables on opening. If I set the variable on page 'A' it comes out on b,c and all pages. It's just sometimes it doesn't. When this happens either it is displayed again on a refresh, or it doesn't appear again at all. In...
  11. SarahG

    Losing session variables

    Sorry if this is in the wrong forum, but I think it's an ASP problem... I have a website that uses session variables. It has started behaving erratically in that session variables seem to get 'lost'. There is no clear logic as to when they do this and in some cases the session variables can be...
  12. SarahG

    Is v5.1.7 compatible with SQL Server 2005?

    Thanks for your replies.
  13. SarahG

    Is v5.1.7 compatible with SQL Server 2005?

    Hi, I hope I have the right forum. I'm using BO v5.1.7, and it links to a database built in SQL Server 2000. I'm going to migrate this database to SQl Server 2005. The tables and views which Business Objects reads from will not be changed w.r.t. structure, data-types, field names etc. Does...
  14. SarahG

    Stop a form from opening problem

    Hi, I presume that if no date is specified, then an empty form is displayed? If so, you could try the following code in the Open event of the form: Private Sub Form_Load() If Me.Recordset.RecordCount = 0 Then MsgBox "There are no records to display", vbInformation, "No data"...
  15. SarahG

    sort order not working using query

    I think nz will return either a number or a string. You could try : ORDER BY cdate(nz([MgtPlanMeetingDate],#12/31/2049#)), cdate(nz([MgtPlanMgtPlanDate],#12/31/2049#)), tblMgtPlan.MgtPlanDateCreated; to ensure it is ordering by date value rather than the alphabetical order of the dates. HTH.
  16. SarahG

    How to send one line to printer or report using VBA

    Hi, even if you successfully send these lines to the printer, I reckon it would probably print each on a different page. Perhaps you could build a table called tblAudit with fields [OldVehicleNum] and [NewVehicleNum]. In your code, declare rsAudit as a recordset: declare sOldValue as string...
  17. SarahG

    Two installations of Business Objects

    Hi, I want to do something very straightforward - I want to have two installations of Business Objects on one machine. The machine in question already has a version of Business Objects (reporter) on it using distribution througha repository, requiring the user to log in when opening Reporter. I...
  18. SarahG

    Two installations of Business Objects

    Hi, I want to do something very straightforward - I want to have two installations of Business Objects on one machine. The machine in question already has a version of Business Objects (reporter) on it, but it was set up by a previous contractor and is highly secured. I don't want to disrupt any...
  19. SarahG

    Still having problems with Landscape vs. Portrait

    Hi, I had this problem with reports in a previous version of MS Access. It printed correctly the first time it was previewed after being saved, but after that switched to landscape/portrait. It was mysteriously resolved by removing a text box from the page footer. The text box was unbound and...
  20. SarahG

    display confirmation of input in data entry form

    Hi Joe, there is no right or wrong, but a subform is generally used when you have one main record and repeating data records associated with that main record, e.g. if you wanted to display all entry/exit records fro a user, that user's record would be on the main form and all entry/exit records...

Part and Inventory Search

Back
Top