Recent content by Lizard

Hello, I've created a Client Access Upload scheme that used to work fine. Since a few days, the upload stops, pops up a critical message "Incorrect function" and then refers to the error CWBTF0022 : "Specified PC file was not found or was locked by another application". As...

Hi Kiwi, I made the same automation very simply. I defined a fixed place on the drive to store my text files and linked them to the DB. As a CSV file will not show the column headings and I wanted titles in my tables, I created a table with the title with the same format as the linked tables...

Hi Christina, The URL is http://www.as400.ibm.com/tstudio/ca400/dtbtch2.htm This site contains much more info than you can expect from the (very limited) Client Access Help. Hope it helps. Olivier

Hi Bill, It seems that "cwbuisxe.exe /f" and "cwbtf.exe /t are both launching a download and taking into account the parameters. Using the same commands and inversing the options should logically launch the upload. Unfortunately, it doesn't. However, I found the solution by...

Hello, I need to be able to launch an upload of a text file to a physical file on an AS/400. I'm using a VBA procedure that executes the following command line : &quot;Shell (&quot;C:\Program Files\IBM\Client Access\cwbuisxe.exe /t&quot; _ & &quot;<PATH>\Upload_scheme.dtt&quot;)&quot...

Hello, I'm trying to put in a macro an &quot;OutputTo&quot; function that outputs a query's result to Excel if a condition is met. The condition should be expressed like :&quot;([Sum of sales for CZSALES]![SumOfsales]>=[Sum of sales for CZSALES yesterday]![SumOfsales])&quot;, where &quot;[Sum...

Hello, In the same idea, I would need to be able to automatically shutdown windows in the evening, after I've left the office. At least, I would like to log off Microsoft Networking. The reason is that I have scheduled tasks running in the evening and in the morning, when I log on to the...

Hello, I have a DB that is refreshed every day (normally) from a DB2 database. I would like to show to the users the date of the last update. Is it possible to put on a form the &quot;modified&quot; date of a table ? This would indeed reflect the last update. Thanks Olivier

Thanks Michael ! Quick and simple ! I didn't know the trick. Lizard

Hi everybody, I've a crosstab query that shows, as column heading, the different inventory &quot;types&quot; for a given part (e.g. invent available, in transit,...). The values in the result are then the quantities in inventory for the different types of inventory. The problem is that, the...

Hi everybody, I'm regularly faced with the problem that I see users logged on my DB that prevent me from running my daily maintenance because I cannot get exclusive access to the DB. As I don't have knowledge in VBA, would anybody know where I could find a &quot;plug-and-play&quot; VBA code...

Don, Thanks for your advice. I indeed simply requested a restore and hope it will work fine. It looks to be the simplest solution. However, as I'm quite new to Access dvlpt, I'm curious to know if there's a way to re-build a workgroup file from scratch for a DB that was secured. As far as I...

Don, thanks for your help, but didn't work It gives me the same error message when using the import. To answer your first question, the database where I'm having the problem is located on a shared drive. I still have the initial &quot;security wizard report&quot;, when I created the security...

Hi I have been running an application working on a secure database for the past month, but suddenly, I get an error : You don't have the necessary permissions to use the <my database> object. Have your system administrator or the person who created this object establish the appropriate...