Search results for query: *

I did little modification on the code, but now I get a different error “External table is not in the expected format” This is what I have <CODE> Option Compare Database Sub Test1() Dim objFSO As Object Dim objFile As Object Dim strPath As String Dim strFilePath As String Dim objFolder As...

I think the process is good if we find a way to make it loop without giving an error Cant find file name . What shell I do ???

Same problem . the code goes throught all lines and when it does the import for the first file and loops ( Next objFile) it get stuck saying cant find file name !!!??? Please help

i did my first import . Thanks , but i have an error after it loops the first time saying cant find object !!! Thats what i have Sub Test() Dim objFSO As Object Dim objFile As Object Dim strPath As String Dim strFilePath As String strPath = "C:\Workbooks" Set objFSO =...

TomHW, Thanks for your help. i started working with it in access . It stops on this line ""For Each objFile in objFSO.GetFolder(strPath)"" And an error says Object does not support this property or method. Please help me find a way to loop through the files and start appending the data on the...

Thanks for this nice start. but how will i include MS access in the code . Shell i use ADO or DAO ?

Hello , I have 200 workbooks in a folder , every workbook has a sheet with couple of lines of data , all workbooks are the same , I need to write code that will loop inside this folder , open every workbook , take the lines of data and have them all in one Table or excel sheet . Can we do...

Option Compare Database Option Explicit Public Sub GetJolts() Dim txtparse As String Dim rst As Recordset Dim File As String Dim path As String Dim Db As Database File = InputBox("Enter File Name", "Eneter Name") If File = "" Then Exit Sub End If DoCmd.Hourglass -1...

Hello , I have a problem i need help . The goal is to import a text file into an a Access Database using VBA. I am having problems write code to 1- [Open a Text File from an Access 2000 DB] 2-Use the find and replace method to find any (,) and replace it empty. Meaning to take the (,) out...

Hello .. This process starts by downloading data for couple of accounts from an oracle web database. This Download should occur at the end of the month so as to have all month’s data. One of the fields needs to be researched and updated with the missing info. This research takes a good amount...

I have a table that has an [order id] column and a [rep id] column. An order could have two reps or more associated with. I would like a have a query that will bring me all the orders that have more than one rep associated with. Thanks

I really do appreciate any help. Hello I am trying to create a form in access 2000 with a text box and a button. When you enter a value in the text box like ID Number and click the “Get” button, I need another form to pop up with the info related to that ID.. The Table that i have this info...

VBAjedi .. Thanks for your reply... I am sorry if I did not mention that i am using access form the start.. Please can you guide me through making the forms and entering the code, i am a fast Lerner .. Thanks

PHV :-) I am working with access 2000. I need to know what criteria shell i put in the first form and what should be in the open event of the secound form (The pop Up form).... Thanks

Hello I am trying to create a form with a text box and a button. When you enter a value in the text box like ID Number and click the “Get” button, I need another form to pop up with the info related to that ID.. I really do appreciate any help.

Thanks a million . i will test it and get back to you .....

Agent Acct Name Units Partner Date Amount E777 478-487 5.33 321 5/3/2001 $46 E777 478-489 5.33 321 5/3/2001 $48 E777 478-482 5.33 311 5/3/2001 $49 Paul W. 999 Total EMPTY ROW...

VBAJEDI.. Thank you man, I really do appreciate your work. But I have to find something other than "total" to go through this process.

ETID... Thank you very much for this wonderful solution. The problem is that the string “Total” underneath the name in column “Agent” is not always there. I am sorry if I did mention that from the start. The name comes directly after the rows of data for that broker. Is their any way we could...

Hello , I am having so much trouble fixing an excel sheet to import it to ms access. I get a sheet from Ms Word with the data listed as below but with one problem is that the Name of broker is listed underneath the last row with his transactions . This is how the columns and row are listed...