Search results for query: *

I agree with bborissov. I have imbedded an sql select within anothe select statement to return the literal for a code. For example: Select MainTable.field1, MainTable.field2, (select literal from LitTable where LitTable.code = MainTable.code), MainTable.field3 from MainTable [spidey]...

Thanks TennesseeFox! [wiggle] [wiggle] [wiggle] I have beating my head against my desk for a day and half over this ( [banghead] ). Now I can move on to something else to lose my (alleged) mind over! [bugeyed] [idea] [cry] [spidey] [americanflag] [unclesam]

THANK YOU, THANK YOU, THANK YOU PANKAJBANJA!!!!!! I am a newbie to .net and I have been stumbling my way through it. I had all sorts of tools/functions to do everything I need to in VB 6.0 ([banghead] [curse] [hairpull]), but they are basically useless now. Thanks Again! For You: [medal]...

Thanks for getting back. We are writing an app to track the instances of graffiti and vandalism and in order to help establish patterns and enable the people that did not work each case to see the vandalism/graffiti we need to be able to display it for them. One of our problems is that the CF...

Hi All!!!!!!! Quick question, or maybe not.... I am working on my 1st CF project and I need to be able to allow the users to indicate an image file to be saved into an image data type in sql server. My problem is that the only code that I have been able to find on working with images has the...

Rick, You tip helped. We have and old VFP 3.0 program that I wrote a LOOOONNNNNNGGGGGG time ago. One of the users just got a new machine with XP and 512 Meg of RAM. They called me with the Insufficient Memory problem. The best I could do was to scratch my head. At least I know that it is a...

BigViking, Maybe I wasn't clear enough in my previous post. When I wrote "I call it pretty early in my startup module to keep it fom doing too much before going to the previous instance." I implied for it to be called from Sub Main. All my apps (built into EXEs) start with...

SurvivorTiger I might have what you need here.... I have a Sub that I called ALREADYRUNNING (it's below). I use an MDIForm for my main form & it gives me no problems. I call it pretty early in my startup module to keep it fom doing too much before going to the previous instance. The only...

VBKRIS, I think I can help you with the whole thing here. I have a Sub that I called ALREADYRUNNING (it's below). I use an MDIForm for my main form & it gives me no problems. I call it pretty early in my startup module to keep it fom doing too much before going to the previous instance...

Thank You CClint. [spidey] [americanflag] [unclesam]

GeorgeDurkee- Glad I could help. John [spidey] [americanflag] [unclesam]

I haven't used datagrids, but I have used listviews. When I needed to know the number of records in the listview I used this code: Dim intListViewCount as Integer intListViewCount = lvwListViewName.ListItems.Count The grid control also has an ApproxCount which queries the data source for...

I know it may not be an elegant solution, but why don't you put the info into a public variable? Then put the info from the variable into the field when you get to tform that the field is on. Good Luck [spidey] [americanflag] [unclesam]

You could try copying the whole app to another machine. Test run the app for a couple of days on the other machine. Hit every screen and button add records and everything else that the system does. After a couple of days check the dates of the files. The dates of the files that the system...

Since you only have about 11,000 records with 12 (I presume small) fields. Our experience is that Access starts balking around the 50,000 record mark. Of course our tables are a good deal more than 12 fields. What version of Access are you planning on using. You can import the data into...

Congrats Mike! [medal] I troll the posts every day and post answers if I can and I always see you giving the answers I would have (when I know the answer - which isn't as often as you do). It is well deserved! You truly are a master! [yoda] Just 1 quick question - with all the posts you make...

I would be a little wary going into Access. How big is the FoxPro database? Also what version of FoxPro are you using? Our experience here is that when Access databases get too large they start getting kind of "kludgy". Weird errors pop up, database sharing quirks and that sort of...

I tried that one before I went to the Knowledge Base([cry]). I had some problems with it. It came with a dictionary of 8500 words. Someone else there had a dictionary of 175000 words. I got both of them and pulled the discionary out of a VFP spell checker we have here and I managed to get...

Believe it or not the Microsoft Knowledge Base has a good way to spell check & it's pretty simple. Follow the instructions and in less than 5 minutes you can be using an instance of word to check spelling! Here's the link: http://support.microsoft.com/default.aspx?scid=KB;en-us;q243844...

I'm sorry. I didn't fuly explain myself. What we are planning on doing is changing the resolution when the system starts up then changing it back when the user is done with it. The users we have here have a variety of machines, some new, but mostly hand me downs that have a variety of screen...