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 derfloh 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: *

  1. redzombi5k

    control source issue?

    Well, it would appear you guys were correct. Listbox rowsourcetype is 6, my confusion lies with why it is reaching eof() as i thought it would only move the record pointer to what was available in the listbox, not to the end of file? I tried playing with some - if eof() clauses and the skip -1...
  2. redzombi5k

    control source issue?

    Hello everyone, I have a issue that im sure if i explain properly has a very simple solution, but its kicking my butt! I have a simple form with 4 textboxes, an edit box that are all control sourced to the same free table, there is also a list box with a rowsource(same table). For some unknown...
  3. redzombi5k

    *.dbf is not a table

    Ah, well hello everyone. Iv been greated with this lovely error this morning, distressing to say the least. Evert dbf recovery program iv tried thus far has been unsucsesfull, i do however have a very recent back up of this file. The only problem being is that the memo file that goes along with...
  4. redzombi5k

    HotKeys Help

    StewartUK, Also interestingly this '\<' works with check boxes as well, which was good for me as I have a few graphical style check boxes that I use for sorting order of a list box control. Very usefull! Thanks -Steve
  5. redzombi5k

    HotKeys Help

    StewartUK, No I did not know that. Thank you I will give it a whirl. Olaf, Also very interesting as I did not know or at least think about this & will try this out as well. Very cool ideas, and I appriciate all the knowlage! -Steve
  6. redzombi5k

    HotKeys Help

    Imaginecorp, Thank You! That was the perfect solution, I feel dumb for not noticeing this before, I am still exreamly greatfull though, probably never would have noticed this on my own. -Steve
  7. redzombi5k

    HotKeys Help

    How do you overcome the inkeycode overlaps in keypress then?
  8. redzombi5k

    HotKeys Help

    Hello everyone, I was just curious how everyone makes hot keys in there programs. For example I would like to make a hot key/shortcut where say the user presses ctrl + s and it auto fills in a story. My problem with that is if I try to use keypress there are so many overlaps there. Say for...
  9. redzombi5k

    NKEYCODE = 19 Problem

    As am I, by the way mine was a edit box not a text box so mabey that makes a difference, but im just as well to let this mystery die, and call it solved! :)
  10. redzombi5k

    NKEYCODE = 19 Problem

    Ahh! Mike, Thanks! That solved it I just put the nodefault directly after the code for my hot key and strange charater gone, however I still wonder why this was happening...
  11. redzombi5k

    NKEYCODE = 19 Problem

    Sorry if I was unclear, yes I am saying I do not want that strange character to show up. I am not putting it there, it just shows up, but only when I use 'Ctrl+S'. If I change the above code to use a different hot key, then the strange character does not appear. Crazy, I put the following code...
  12. redzombi5k

    NKEYCODE = 19 Problem

    Hi guys, I have come across a strange problem with the keypress event of an editbox. I am tring to set up a hot key for 'Ctrl+S', and it appears to run properly, only after the code has run it places a '' in my edit box. After checking my code and finding nothnig wrong, I changed the nKeyCode...
  13. redzombi5k

    Export dbf to xls

    ok, so I guess I am showing my ignorance with excel and automation here because I am able to change the formating (in that when you click on the cell and select format cells it shows to be what I set it to programaticly) but in the xls all the cells still have the little green triangle in the...
  14. redzombi5k

    Export dbf to xls

    Alright, so after all these great sugesstions I have an idea. Tell me what you think.. I was thinking that it might be simplest if I were to use 'copy to - type xl5' and then use automation to set the formating of the columns that I need. i.e. column b's format would be numeric, and cloumn d's...
  15. redzombi5k

    Export dbf to xls

    Ahh I just assumed that was a typo, my mistake. Your cursor idea sounds like it should work, cant believe I didnt think about that! I will try it now and let you know. Thanks again
  16. redzombi5k

    Export dbf to xls

    Thanks Stella740pl and DSummZZZ Stella740pl, I had no idea about the FOX2X, which solves the date field, but I am using character fields in my table and they need to be shown as numeric in the xls so Ill check out the Automation fourm that DSummZZZ listed. Again, thanks for your feedback guys!
  17. redzombi5k

    Export dbf to xls

    Hello all, I have a program that exports the data from my dbf to excel as a .xls My question is this... When I export everything is exported as text, is there any way to control this? i.e. make certain columns be numeric, or date ect. Thanks, -Steve
  18. redzombi5k

    strtofile() ingnores chr(13)

    OK, so for any who are interested i finally figured it out, I needed a chr(13) + chr(10) (a carrage return and a line feed) So any who, Thanks!
  19. redzombi5k

    strtofile() ingnores chr(13)

    Heelo, I am building a log file as I loop through my code and writing that file with strtofile() my only problem is that when I execute strtofile() all of my chr(13)'s are ignored so instead of lookinkg like - 12345 - blah blah blah 23456 - blah blah blah it looks like - 12345 - blah blah...
  20. redzombi5k

    Returning 2 variables?

    thanks for the replay, got it all figured out, one more thing I hope im not going to far off the original topic of this post, but when I use strtofile() the file ignores all of my chr(13) (returns) so insted of it being a readable text file it is just one long sentence, any sugestions?

Part and Inventory Search

Back
Top