Search results

I was looking for an automated way of doing that, so the user can simply receive the source csv file, and import it into the database without manual manipulation. The alternative is to go back to the source and have them remove the header, but that comes at a $ cost, which I was trying to avoid.

Unfortunately, that does not do it... as I explained, the 1st row does not contain the field names... they are in the 2nd row. The 1st row contains header information (filename, date created, period covered, total record count, etc.). I need a way to eliminate the 1st row completely or for...

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.

Problem solved... the culprit was the variable varSampleSize, which was being set to null because the user did not follow the process through to completion initially, so the variable value was reset when they 'stepped' back into the process at a later step.

Added the spaces as suggested, but still getting the same error.

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

Thanks, George... the quotes enclosing the whole thing did the trick. I love this forum...

Thanks, lagbolt. The double-quotes are now accepted by VBA, but I am now getting a Run-time error '53' File not found. However, I tried using Windows > Run with the following, and it worked perfectly: "C:\Program Files\Gavlock Consulting\SmartDir.exe" /run "C:\DataEntry.ini" Any ideas on why...

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

David, you were absolutely right about the field names, but not because of spaces. I missed a " mark after the 31st field in the list values, causing the remaining descriptions to become the column 0 values. Once I fixed that minor mistake, it works perfectly, returning results for all fields if...

Limit on number of items selected Hi David, I just discovered it is not working quite as perfectly as initially thought. The problem now is that, although I was able to create a list of 43 items, it appears the SQL limits me to a selection of only 30 items. Any more than that and I get the...

Amazing what a difference that makes, David. Thank you so much for your assistance with this. It is working perfectly now. Much appreciated.

Almost there Hi David, Thank you for the assistance thus far. I am almost there. However, this piece of code is stringing together only the last list item selected, resulting in a circular reference when the query is executed. For X = 0 To Me.lstFieldChoice.ListCount - 1 If...

I only wish the solutions were that simple Thanks, DCrake It appears the listbox is limited to 20 items, and my query is more than double that. Would it be possible to contatenate the string results from 3 listboxes for the SQL? How would I code that? I really don't know VBA code... I just...

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] ='" &...

Thanks, DJKarl, that is helpful, and I have made some progress. Now, how do I append one record at a time, checking a counter in between, until I have appended the desired number of records?

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 Banana, I did as you suggested, with the following result: SELECT TOP 0 tblTemp.[Order Date Year Quarter], etc... When I saw the 0, I realized I had been testing the code without going through the whole process, so the variable value was not getting set. As soon as I took care of that...

I have it declared as an integer... Public varRecord As Integer I assign the value to varRecord from a bound control on a form, which obtains its value from a query. varRecord = txtRecords.Value I then use a command button on that form to call the procedure that contains the problem code.