Recent content by wvdw

Hi, Instead of using the progressbar you suggest you could check out the syscmd http://msdn.microsoft.com/library/default.asp?url=/library/en-us/off2000/html/acmthSysCmd.asp This is easy to implement and you do not have to add references. I do not know how you copy the files so I can not...

Could you be more specific? Do you want to change all values or just one? All records or a specific record?

Hi, When the user enters data in a input box I have to check if the has the correct (data) type. But I do not know how to do that. i.e dim varAnswer as variant varAnswer = inputbox("Enter the new price", "New Price") How do I check if the answer is not a string like...

Hi, Maybe you can try this. In the afterupdate event from the first combobox you add code to set the second combo's rowsource object: i.e. Private Sub cmdStreet_AfterUpdate() Me.cmdLocation.RowSource = "SELECT tblStreets.id, tblStreets.location FROM tblStreets WHERE...

Thanks, I will try that. I also found that there is an option on the docmd.openform command that opens the form in chart view.

Hi, I have this form that has a pivottable view. But when I open the form I always see the table and not the chart. How can I open the form with the chart as standard view? Thanks

Hi, I created a form that has a pivot table as object on it. But when I open the form I always see the data that is the source of the table. I have to use the mouse to see the chart. How can I open the form and see the chart at once? Saving the form with the chart open does not do the trick...

Hi all, I have a subform that is based on a query. The user can select the fields he wants to see in the query from a selection list. Changing the underlying query is no problem but when I show the subform the not selected fields are visible as well and the value is set to #NAME (or #VALUE) in...

Mike, I tried the eval block already. No luck the error still appears. I will look into the second option. But since I have never seen it before it will take some time. thanks, Walther

Hardy, The OS we use is AIX (4.3 I think) and the perl version is 4 (I know it is old). The peace of code is simple: @array = "a lot of charachters (more than 1010)"; dbmopen(%somehash, "FILENAME", 0777) || die bla bla $somehash{KEY} = "@array"; At this point...

Hi, I have the following problem. I want to store text in a hash which is of course no problem as long as the key and/or value is not to big to fit into the hash. When a value is to large to fit in the hash I get the following error: dbm store returned -1, errno 28 etc. I want to catch this...

The problem is that I do not want to create a file (not on disk anyway). I just want to open Wordpad and control the wordpad window like I control word with automation. The sendkeys option is OK i will try that. Thanks wvdw

Hi ElGuapo, Thanks for the quick reply. But the problem is that I want to show the output on screen. If I write the lines to a textfile (and open that in Wordpad) I will get the problem that the file can be already in use and I have to test it etc, etc, So I really want to open wordpad and...

Hi, I want to send data from a form to wordpad. I know how to open word and print lines to the newly created files. But because I don't know if customers have installed Word and it takes a lot of processing time I want to print the lines to wordpad. Can somebody tell me how to start wordpad (as...

Hi, I have a script that logs into a server (to query for data) but it uses the standard password. If this password has been changed the user must be able to enter the new password but this has to be 64-bases encoded before the script logs in to the server. Does any body know if there is a...