Search results for query: *

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

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

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

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

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

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

How do you overcome the inkeycode overlaps in keypress then?

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

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! :)

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

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

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

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

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

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

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!

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

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!

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

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?