Recent content by OrganMan

"Hey Hudson, I totally agree with what Lagbolt said but I just found the tone of the email rather sarcastic, and I understand your backing him up since I am a newbie. On a positive note I was able to get everthing working on my own. Thanks for now guys. Doesn't sound like a stomp to me...

Wiklendt, Not sure why you are replying back over two months later. If it is for the solution, I have moved on to other projects since, so it might be a little hard to find the solution for this one. A few others replied saying that his comments weren't out of line and I accepted that, I just...

Hey Hudson, I totally agree with what Lagbolt said but I just found the tone of the email rather sarcastic, and I understand your backing him up since I am a newbie. On a positive note I was able to get everthing working on my own. Thanks for now guys.

Hey Lagbolt, Thanks for the wonderful tidbits of information. I would appreciate if you didn't reply to any of my posts, as the two replies that you have provided have not been of any assistance to me, I am pretty sure that I can get some actual help from just about anyone else, DUDE!!

Ok, I have been able to fix more of my code. I am now able to populate the second listbox with the data contained in the text file. I am now trying to get this data imported into my access table and seem to be having problems with the Connection object, getting the error, "Run time error'91'...

Ok maybe I should break my problem down. I have the code working to search a particular folder and display all of the txt files from this folder in a list box(lstFiles). What I would next like to do is populate a second listbox(lstFileLines) with the Tab delimited data contained in the...

Hi there, Can someone please look at my code and help me out help. I am trying to convert over VB code to work with VBA in Access 2003. The code to list all of the available text files in a particular folder is working fine, and they get populated in a listbox called lstFiles, the problem is...

This may be a bigger project than I first thought but what I need to do is import a text file into an existing table. First of all I have created a form with a listbox that I would like to be able to store the text file in. How do I go about loading the text file from my hard drive to the...

I now get the following error: Runtime error: 3078 The Micosoft Jet Database Engine cannot find the input table or query 'frmtabCards'. make sure it exists and that its name is spelled correctly. I do not have a query for anything here. I only have frmtabCards in the FROM clause of the...

To break down my task, can someone tell me what is wrong with my code: Private Sub cmdAddCardToCollection_Click() DoCmd.RunSQL "INSERT INTO Collection ([CardId],[CardNo],[[ConditionId],[Quantity])" SELECT Me.txtCardId.Text, Me.txtCardNo.Text, Me.cboCondition.Value...

Wondering if someone can help me out. Upon click of an Add Card To Collection button I would like to save the values of two textboxes into the fields of a table. First of all the textboxes are filled when a record in a listbox is clicked through the control source property, and I would like to...

Can someone help me out? I have a listbox that is populated with data from a recordset. I would like to know how to display the data on a record in the listbox when clicked into the corresponding textboxes on the botom of the form. I have the following textboxes on the bottom txtCardNo...

My database is coming along quite nicely. Presently when I click a button I have a recordset that hits the database a populates the fields of data on a listbox according to my SQL statement. The data that is displayed is all of the sportscards in a particular set, which I previously chose...

Everything is working great to this point, able to select a subset from the subset combobox. I have added a list box that will display the cards from my card table within that particular subset. How do I code to have this listbox populate when I select the subset. I am pretty sure that I have...

Hey JANR, Just wondering what code I would have to put in the rowsource of cboSubset to have a list of subsets populate after I select a manufacturer then a set. I have added data to the subset table, also added a SetId field and have also added a second after update event for cboSet. I...