Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Crookshanks
  • Order by date
  1. Crookshanks

    Jet SQL - Difference on Vista and XP?

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

    Jet SQL - Difference on Vista and XP?

    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 =...
  3. Crookshanks

    Unique combinations of two Field

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

    lay-out listbox, different lay-out in columns

    Thanks I will look into that.
  5. Crookshanks

    lay-out listbox, different lay-out in columns

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

    disable ctrl+F in runtime on Form

    Thanks. I'll try.
  7. Crookshanks

    disable ctrl+F in runtime on Form

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

    disable ctrl+F in runtime on Form

    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,
  9. Crookshanks

    Sorting query on field type Hyperlink

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

    Sorting query on field type Hyperlink

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

    DoCmd.TransferSpreadsheet - error message

    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?
  12. Crookshanks

    DoCmd.TransferSpreadsheet - error message

    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?
  13. Crookshanks

    DoCmd.TransferSpreadsheet - error message

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

    DoCmd.TransferSpreadsheet - error message

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

    DoCmd.TransferSpreadsheet - error message

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

    DoCmd.TransferSpreadsheet - error message

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

    Infinite Loop after Error

    No, there are no Timer Events
  18. Crookshanks

    Infinite Loop after Error

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

    Infinite Loop after Error

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

    Infinite Loop after Error

    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?

Part and Inventory Search

Back
Top