Member Avatar for staticvoyager

Okay, I've tried my professor, and he's impossible to get timely feedback from... When he has responded, he has sent me coding - most not even close to containing the proper elements to complete the assignments, and he isn't much for explaning.

Although I could copy and paste all my coding here, I'd rather be able to discuss my issues real time on AIM or Y! I find that I run across nagging little errors when I'm coding that won't even allow me to attempt debugging... (My biggest current issue is a syntax error in my "For i as Integer To..." statement. At the "To") So I think help this way would be better?

If anyone has any experience working with Visual Basic and MS Access databases, I would greatly appreciate some assistance. Please send me a PM, and I can send you my ID. =)

  • 3 Contributors
  • 3 Replies
  • 93 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by fuego2008

Dani AI

Generated

A few focused points that address 's "For i as Integer To..." syntax error and the DB/DGV/ListBox pieces mentioned in the thread. 's resource is a useful learning link; the bits below complement that with quick fixes and patterns that solve the most common problems.

A likely cause of the syntax error is a missing initial value or missing equals sign. VB.NET For requires an initial expression, an equals sign, then the To expression. Example:

For i As Integer = 0 To 10
    ' work here
Next

If legacy VB6 syntax (no type declaration or no "=") or a typo is used, the compiler will flag the To token. Also check for stray punctuation, missing parentheses, or an accidental line break inside the For statement.

Common DGV/ListBox patterns when working with Access (compact examples):

' iterate DataGridView rows (skip the NewRow)
For Each row As DataGridViewRow In myDataGridView.Rows
    If Not row.IsNewRow Then
        Dim v As String = Convert.ToString(row.Cells("ColumnName").Value)
        ' use v
    End If
Next
' fill a ListBox from a DataTable
listBox1.Items.Clear()
For Each dr As DataRow In dt.Rows
    listBox1.Items.Add(dr("FieldName").ToString())
Next

Quick troubleshooting checklist:

  • Compile and read the exact compiler message (it usually points to the missing piece).
  • Verify both start and end expressions are present and type-compatible.
  • Turn on Option Strict to catch conversion/type issues early.
  • Use breakpoints and Step Into to see runtime values.
  • When asking for help, include the method-level code, the exact error text, VB.NET/VS version, target framework, and a sanitized connection string or table schema so responders can reproduce the problem.

A short note: public thread posts help future readers much more than private IMs; also avoid posting personal IM IDs in public threads.

Recommended Answers

All 3 Replies

Member Avatar for fuego2008

I have found this site just by luck, but there are many nice articles and downloadable components on it. It is being updated very frequently and I have bookmarked that site already, and I recommend to do it too!

Regards,
Fuego

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.