Search results for query: *

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.

Hello guys, I am having trouble with the TransferSpreadsheet Method. I worked fine but for a reason unknown for me now I getting the following error message: Runtime error 3274 - External table is not in the expected format. The code that raises the error is: DoCmd.TransferSpreadsheet...

No, there are no Timer Events

Remou, I decompiled and compiled the db again. Q: is it correct that Access2003 compiles all modules at once. After one compile the option 'compile' was not available anymore. I also created a new database and copied all the objects in the new database but still no improvement in behaviour. It...

Thanks again. So you think the database is corrupt? Is this looping a symptom of the db being corrupt?

Thanks for your answer. I did not change anything. That is the weirdest thing. Could you please be more specific about the various repair routines?