Recent content by jezmondo

Hi I've created a script that uploads a .txt file to an iSeries, however the data contains spurious 'spaces'. For example &quot;hello&quot; is shown as &quot; h e l l o &quot;. Here's my script: username password cd <mydir> (iSeries Directory) put C:\<filename>.txt (local filename on NT PC)...

MIS indeeeeeeeeeeeeeeed!!!!!!! You need to suck up to Helen a bit more (so to speak!)

I work for a company that uses MS Project extensively. We also deploy tasks using Project Central. Our department's KPI's are measured against our performance to Projects (including Admin, Support and Project related work). Reporting this has become a labour intensive task - taking one person 5...

Hi Tiffany Thanks for your help. However I'm still needing to provide default values for all fields within the update. Even though the fields in my db are set to zero length and not required, Frontpage still insists on having a default! I'll probably get round this by doing some whizzy stuff...

I'm using DRW in FP2000. If I don't provide defaults values I get the following error ------------------------------------------ Database Results Error Description: [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression. Number: -2147217913 (0x80040E07) Source...

Is it possible to omit default values from the Database Results Wizard when creating an Update.asp page? The requirement to add default values in all fields is messing up another query in the db. This is particular true regarding date fields.

I have a range of .asp pages developed in Frontpage which filter results of a query down to the one the user wishes to update. Everything works without error. However, when I look at the underlying Access db, all of the memo fields (some of which contained data) have been overwritten with...

This worked for me: Dim objNotes as Object Dim objNotesmail as Object Dim PDFPub as Object Dim objNotesSession as Object Dim objNotesDB as Object Dim objDoc as Object Dim objRichText as Object Set objNotesSession = CreateObject(&quot;Notes.NotesSession&quot;) 'Open Notes...

Thanks SQLSister - the table in question does have a unique index field but I'm still unable to add a record???

I have upsized a database developed by someone else in Access to SQL Server. A form within the database has a Master / Detail structure which works fine when the tables are held locally in Access. When the database is linked to the tables on the SQL Server however, trying to update the Detail...

I have aa Access 2000 project that is linked to tables on a central SQL Server. The project will be deployed via citrix for up to 50 users. Does the fact that only the tables are on SQL mean that the concurrent usage limitations of Access will still apply?

I have a table recording users and their PC's. The table is constructed so that if the user has more than one PC there are multiple entries for the user: USER PCNAME username1, PC01010 username1, PC01011 username1, PC01012 username2, PC01013 username2, PC01014 etc... I need to extract...

&quot;TR0610 There aren't enough columns for the time array&quot; error message displays when changing properties for Array to [12 month array type, fiscal period, start month]. I am using an IQD datasource for the Cube model and I'm baffled! Anyone have any thoughts / solutions - or even an...

I have a macro that will run and save reports and then e mail a user. I need this mail to be sent to more than one user but can't figure out the syntax... I currently have: Set objNotesSession = CreateObject(&quot;Notes.NotesSession&quot;) strMailServer = &quot;mailserver&quot; strMailFile...

I have developed a suite of reports that run over a Notes db and I'm currently setting security for users. My question is, will Impromptu override the security for the user within the Notes db ACL? e.g If a user has the ability to view only certain docs in Notes will the ODBC 'sign on' to Notes...