Search results for query: *

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

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

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

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

I have created a number of reports that show a day's transactions with a filter of 'Date Ordered = Today()'. These reports now need to be run to show the previous day's transactions. Does anyone know how to do this i.e. 'Date Ordered = Today() -1' Cheers

I have created a macro that automatically runs, prints and saves a report .pdf. The .pdf files then need to be mailed however they're obviously too large. Is there a way of zipping the .pdf's via the macro?

We are currently embarking on an AS400 ERP implementaion and need to migrate data from various AS400 legacy systems into it. Is anyone aware of any tools that may be of use to us (we REALLY don't want to have to key all of the data in manually!) Thanks

Does anyone know of a way to call winzip to zip up files created by a vb macro? The files are created and saved as .pdf ready for mailing but I really need to zip them up before they're sent. Cheers

I am trying to set up a macro that runs a simple report, publishes it as .PDF and then opens Notes and mails a user to let them know the report has run. I'm having difficulty with the final part of this i.e. getting the macro to open Notes and mail the user... If poss I would like to...

After grouping or sorting a column of data the results of a substring calculation in another column are lost.... Why??????????? Cheers for your help...