Recent content by Crookshanks

Thanks PHV, it helped. But why? Does JetSQL only recognize a specific dateformat?

Hello there, I am working on an application that uses some JetSQl queries in runtime. Now I am developing on my laptop (XP vista Home) when the live environment uses windows XP through a Citrix environment. The following queries does work on my laptop but does not work on the network. hSQL =...

Goodafternoon, I've got a table with 5 fields, lets say fields A,B,C,D,E. The table is filled from different sources (imports, VBA created info etc. etc.). After the fill (or during) I want that each combination of A and B occurs only one time. What is easiest? 1) Make a query with the...

Thanks I will look into that.

goodmorning, I've got several columns in my listbox. Now I was wondering whether it was possible to have an alternative markup for the results in a specific column. Like another color or just underlining. So, i.e. columns 1,2,3 just plain en column 4 bold. The reason I want to do this is dat...

Thanks. I'll try.

Thanks for your answer. it surely might be the solution, but I'm not sure how to proceed...

Hello there, I've got (again) a small and fairly simple question. In runtime it is possible in my form to enter ctrl+F. Can I disable this? No, a screen with Find/Replace appears. Note: I do have some key down events and I do not want them to be surpressed. reagards,

Thanks PHV! That is definitely the cause of the problem. All I have to do is solve it. I've read the documentation about the HyperlinkPart Method but I just want to display the text which is stored in the database as there are links to documents on the network as links to the Internet. None of...

Hello there, I've got a small question and maybe you could help me. I am using a listbox to show the result of a query. By pressing some labels you can sort the query on the field you like. Problem: When I try to sort the field with links (field type = Hyperlink) the query does not sort the...

I do not think so. I have administrator rights. I will do some further testing. Thanks for putting me in the right direction, I will keep you posted? Perhaps anybody knows the criteria of the outputpath?

Sounds logical. I.e. the following path causes an error C:\Documents and Settings\Administrator\Desktop\Projecten_110907.xls and this one not C:\test\projecten_1213.xls does not Perhaps the [space] in Documents and Settings?

Thanks. Yes, to my surprise that works. Getting confused. What is the thought about the hint?

Yes, I included the following: f Right(diroutput, 4) <> ".xls" Then diroutput = diroutput & ".xls"

Thanks for your answer. I've checked it. De outputfile (diroutput) does not exists. When running the export the systeem creates the excel-sheet and then comes up with the error. Leaving me with a blank Excelworkbook.