Search results

  1. M

    insert rows into errors table -- Access 2003 / VBA

    I didn't know exactly where to put this because it is primarily about SQL. I have three tables that I am going to be using for this part. RawData Reconciled Errors Basically, I need to insert rows that didn't meet the criteria and put the whole row (with over 25-35 fields) plus one field that...
  2. M

    Farewell, dear Intellisense (Access 2003 VBA)

    I am at work doing VBA when suddenly Intellisense stopped working. It's a pretty simple application: recordsets, sql, some classes. Nothing else really. It's working for declaring variables like: Dim A as (and it pops up a list of data types). However, it doesn't work for my classes or...
  3. M

    Importing from csv stopping

    Thanks to the super moderator, I was greatly helped. I am reusing his code to read from a delimited text file and place the values into the table. This is what he wrote: http://www.access-programmers.co.uk/forums/showpost.php?p=639755&postcount=5 I ran into a snag. though. I have 37 fields...
  4. M

    changing Excel column names from Access

    I have been trying to import an Excel spreadsheet into an Access table. I have no say in how the XLS file is formatted. And the users of my Access application will be importing XLS files on a daily basis. The XLS file's header names are usually 2, 3 or even 4 words long. I have read that to...
  5. M

    Print field names of table

    How would I print the actual field names of a table? I would love to be able to write a sub that loops through a table's fields like: "recordset.fields.item(" & field & ")" And it would print out all the fields in a given table. I have some tables that have 25-35 separate fields. Instead of...
  6. M

    General question about collections

    Should I be concerned with using too many collections in my vba projects? I was told by a coworker that I need to limit it to a few otherwise my applications would bog the users' computers down. =-= Mr. McDimwitty =-=
  7. M

    OpenText -- what am I doing wrong?

    I am getting a compile error in the second sub in the OpenText statement. Any idea why? Private Function GetSelectedFile() As String Dim fDialog As Office.FileDialog Dim varFile As Variant Set fDialog = Application.FileDialog(msoFileDialogFilePicker) With fDialog .Filters.Clear...
  8. M

    importing csv to a table

    I need to import a csv file with a file extension of XLS to an Access 2003 table programmatically. How would I do that? Mr McDimwitty :eek:
Back
Top Bottom