Search results

Is there a way to automatically skip row 1 of a CSV file when importing? Row 1 contains a header with filename, date created, period covered, total record count, etc., and then Row 2 contains the column names.

Database was created with Access 2003, but is now being run under Office 2007. Need some more eyes on this... it was working fine for several months, but now is failing with the error: "The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the...

Hi all, Can anyone please help me out with the correct syntax for this: Dim stAppName As String stAppName = "C:\Program Files\Gavlock Consulting\SmartDir.exe" /run "C:\Reports\WeeklyFL.ini" Call Shell(stAppName, vbHide) I have tried searching the forum, but obviously haven't...

Hello all, I have tried searching through this forum for clues on whether this is possible, but I'm not even sure how to phrase the search criteria. I would like to create a form that has a check box for each field in an underlying query. I can do this. I would then like to change the 'Show'...

Hi all, I have tried to research this problem, but am coming up empty. I am getting a runtime error '6': Overflow when I attempt to run this code: Private Sub txtLineNbr_BeforeUpdate(Cancel As Integer) If DLookup("[txtEntryNumber]", "tblCDN_ImportsDetail", _ "[Entry Nbr] ='" &...

Hi all, I am really not understanding this VBA stuff very well, and I can't seem to find the answers I'm looking for so far, so thought I would post this plea for help. Basically I have 3 tables. Let's call them Original, Temp, and Result. There is a field in each table called Entry, and there...

Hi all, I have exhausted my search on this question to no avail, so I am turning to the true experts. Is it possible to use a variable, or alternatively, a form field value, in the SQL Select Top n statement, and if so, what is the appropriate syntax? I tried using "Select Top varRecords ..."...

I have a popup form that opens from a command button on a switchboard. I placed a command button with the Find Record on the popup form. The problem is, the 'Look In:' box on the 'Find and Replace' screen references the switchboard form, not the popup form. If I change the popup property to...

I simply cannot see what I have done wrong here: Private Sub Form_Load() txtCheck.Value = strCheckMark If txtCheck.Value = "A" Then _ lblTitle.Caption = "Amended Entries Completed - Change Flag Form" ElseIf txtCheck.Value = "N" Then _ lblTitle.Caption = "Entry...