Recent content by mohrorless

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