Search results for query: *

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...

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.

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.

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...

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"...

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...

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...

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...

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...

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...

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...

Thanks for your replies.

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...

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"...

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.

...In your code, declare rsAudit as a recordset: declare sOldValue as string, sNewValue as string declare rsAudit as recordset docmd.runsql "Delete * from tblAudit" 'Clear the audit table set rsAudit=db.openrecordset("tblAudit") With rst .MoveFirst Do While Not .EOF .Edit...

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...

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...

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...

...some code to check it is a valid user (I've used dummy field & table names): Private Sub txtBarCode_BeforeUpdate(Cancel As Integer) if DCount("*","tblEmployeeNumbers","EmpID=" & me!txtBarCode") =0 then msgbox "This employee number is not valid or the barcode didn't scan properly...