Recent content by McDimwitty

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

The problem is solved. However, I am curious. How do you turn on and off AutoCorrect. This is my first Access app I am doing.

I think that was it. Thanks.

- I have no timers in my application. - I intentionally type in lower case in order to see the variables change and confirm that I spelled things right. Even though the Intellisense doesn't work, the properties of my classes do change to the right case. That suggests that my classes are okay...

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

That tidbit of information is going to save me a ton of time and frustration. I can convert these number fields to string in no time and then I can get to the rest of the application. Just so you all know, I appreciate a forum like this more than you know. Books and documentation are crucial...

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

imported spreadsheet - table all wacky I imported a spreadsheet into an access table, but when I open up the table, only the first two columns are there. The first is the primary key - autonumber. The rest of the fields are blank. Is there another way to get the data into Access. I have a...

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

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

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

Bob, I started VBA in Excel a few months ago and in Access last week. Although I didn't try it yet in my application, I think that's exactly what I was looking for. It's also very straightforward that I think I am grasping how Access, VBA and ADO works. Thank you! I will try it in the...

Basically, the access vba app that I am writing for work has to import a semicolon delimited file daily which is created by another system. 1) It has an file extension of xls. 2) This other system places the headers which I don't want. The Access table already is defined. With this in mind...

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

I am doing this for work, so I have absolutely no control over how the file I receive is formatted. I bet a lot of the people on here know how that is. :rolleyes: The file my application gets is a text file which is delimited by semicolons, but it has a file extension of XLS. My Access VBA...