Home > Help With > Help With A VB6 Table

Help With A VB6 Table

By the way, what I am needing help with now is a utility program that represents maybe 1 percent or less of the total project. Whoops, you're right. Do the following code need the recordset to be open with "CorRs.Open" before it : Code: CorRs.Open "SELECT * FROM Course WHERE RollNo = ('" & txtSRN.Text & "')", StdCn, adOpenStatic, It is not MYSQL meaning a type of database.

I cannot find any reference to comp being setup as a variable; however, it is used maybe a hundred times in the project. I did receive some code to parse the date which I am tring to test. Learning resources Microsoft Virtual Academy Channel 9 MSDN Magazine Community Forums Blogs Codeplex Support Self support Programs BizSpark (for startups) Microsoft Imagine (for students) United States (English) Newsletter Privacy & cookies SQL Server downloads .. pop over to these guys

I suspect you already have dimensioned that variable name as an array somewhere else in your program. One more try. Reply With Quote November 15th, 2011,09:21 AM #12 Raaj71 View Profile View Forum Posts Junior Member Join Date Oct 2011 Posts 19 Re: [RESOLVED] Need Help : VB6 Fetching Data from

You can do this either by setting the Size property to 550, 550, or by dragging the corner of the form until you see the correct size in the lower-right corner Now it looks as though you are only using the recordset in this one routine. Probably named Module1. the only way i can see you doing this is to use sql string functions to get the string to yyyymmdd and then delete records where the resulting string is less

VB6 itself barely runs. Thanks. Regards Reply With Quote November 13th, 2011,08:22 AM #7 Raaj71 View Profile View Forum Posts Junior Member Join Date Oct 2011 Posts 19 Re: Need Help : VB6 Fetching Data from You may have to register or Login before you can post: click the register link above to proceed.

Do you think I need to add an "AND" statement before the delete that says "if coNum=comp" then ... Reply With Quote Feb 28th, 2008,12:38 PM #20 jonrmoore View Profile View Forum Posts Thread Starter Hyperactive Member Join Date Jan 2008 Posts 325 Re: Need help with updating table vb6 FlexGrid: fill from recordset .. Settle most of the part by refering to the tutorial & sample available in the web except few items now (this table view is one of it).: : : : :

I assume you have a statement somewhere: DTP=dtPicker1.value or similar. 3. https://forums.techguy.org/threads/help-with-a-vb6-table.651955/ I don't know. DB Reserved Words checker Connection strings .. That reply said it was possible to do it with SQL, so I posted it there.

In this case, the company number is "1". What would prey on an Owlbear? Code: Dim RS as New Recordset RS.Open 'do stuff with the RS RS.Close Set RS=Nothing Of course you would remove the code to define this RS from your form declarations and Set the following properties for it.Be sure that the label's BackColor property is set to CornflowerBlue.Set the AutoSize property to False.Set the Dock property to Fill.Set the TextAlign property to MiddleCenter

The difference is that when you place all the code in the same procedure then the memory is released when the procedure is completed where if you define it outside the MDAC/Jet/ACE downloads .. All rights reserved. SQL 'Select' statement formatter/checker ..

MZTools (free upgrade for the VB6/VBA Editor) Reply With Quote Feb 27th, 2008,11:55 AM #9 Arachnid13 View Profile View Forum Posts Hyperactive Member Join Date Jan 2003 Location England Posts 327 Hitchhiker's Guide to Getting Help at VBForums Classic VB FAQs (updated Oct 2010) ...Database Development FAQs/Tutorials (updated May 2011) (includes fixing common VB errors) .......... (includes fixing common DB related errors, SQL 'Select' statement formatter/checker ..

No, create an account now.

Always use [code][/code] tags when posting code. If it is only to be used in this routine then you should have all of the code in the routine. Dec 3 '15 at 11:19 If you are dealing with MS Access, then information_schema queries are not in use. Dec 3 '15 at 11:19 you would also want if not exists (select ....

Click "..." button.: 7.)Check option "Use connection string" and click "Build..." button near it.: 8.)From the list of providers,double click "Microsoft Jet 4.0 OLE DB Provider".: 9.)Now hit "..." button near Set rs = db.OpenRecordset("SELECT dstDate FROM ServDistr WHERE " & _ "coNum=" & comp, dbOpenSnapshot, dbReadOnly) Reply With Quote Feb 27th, 2008,02:28 PM #13 Caskbill View Profile View Forum Posts Hyperactive I suspect that since you just copied that code from somewhere else in the program, it's really not needed here for what you want to do. Specifically, it's data type must be "DATE".

It is also frowned upon to create duplicate threads for the same question - you currently have 3 threads on this subject, albeit with very minor variations. We (or at least I) do appreciate your situation, however it makes no difference to who can answer your questions or when.