Search results for query: *

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

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

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.

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