Recent content by mizzourob

Re: Get Current [Solved] To finally solve this, I had to alter my OpenRecordset command by appended dbOpenDynaset to it. Set Recordset = CurrentDb.OpenRecordset(SQLstring, dbOpenDynaset) Full code is now Dim SQLstring As String SQLstring = "SELECT * FROM General WHERE General.[CONTRACT] =...

I wonder if the issue has to do with the table name being GENERAL which is a reserved word?

If I modify my code with the FROM clause as suggested and as shown below error 3131 pops up Dim SQLstring As String SQLstring = "SELECT * FROM General WHERE General.[CONTRACT] = '" & Me.CONTRACT& "' ORDER BY EXTENSION DESC ;" MsgBox SQLstring Recordset = CurrentDb.OpenRecordset(SQLstring)...

Thanks for the tip on adding the From clause. When I tried adding that I end up with a run-time error 3131 Syntax error in 'From' Clause. Still not sure what I'm missing...

I have a table named "General" which contains fields "CONTRACT" and "EXTENSION" I am trying to find the last entered EXTENSION when viewing any of the CONTRACT record value in the table using some VBA in a on click event button in a form that uses the General table as it's record source. The...

Ok I figured it out... here is my solution. I had to split it into two function as found on StackOverflow (sorry post count not high enough to share link). Private Sub Command0_Click() ' Requires reference to Microsoft Office 11.0 Object Library. Dim fDialog As FileDialog Dim varFile As...

[Solved] VBA for Import Mulitple Worksheets from Same Workbook Hello.. I am trying to set up VBA to import a user selected Excel workbook that contains various numbers of variously named worksheets that are all formatted the same. I do not care about the worksheet names, but need to import...