Search results for query: *

i have a excell application that i have aded a button into to pull in data from a db. i want to create another button to run several dos commads. how would i get vba to run these 30 comand lines on the button click.

i am using an access2000 database with excell office 2000 profesional. i am trying to read the database by item numbers to put the amount in a spreadsheet. i have it populating the spreeadsheet but it does it one amount at a time from left to right. what i need is the total of each item number...

am getting a undefined error on the 'EntryTable' but i didnt think that i had to define the table names. Option Explicit Public RowsCount As Integer Public ColsCount As Integer Public gColNameArr() As Variant Public gRowNameArr() As Variant Public gItemNumsArr() As Integer Public...

this is my string and i am getting a operand missing in the from statment. anyone have any ideas as to what is wrong with it. sql_str = "SELECT Amount(Amount) as m " & _ "FROM EntryTable INNER JOIN HeaderTable ON EntryTable.Reference # = HeaderTable.REference #...

is it posible to import data into an access table without deleting the table. i have three tables where the format and properties stay the same but when i update the tables it reforamts the table to default setings. this is what 8i am currently useing Option Compare Database Private Sub...

i am importing a .txt file into access and get a file conversion error on some of the records. i delete some of the good records and rerun and then the errored records pull into access with no errors. can anyone tell me why it wont pull all the files when they will pull in when i break it into...

getting a run time error of no value given for one or more required parameters. Set sht = Worksheets("Detail") For i = 1 To RowsCount For j = 1 To ColsCount sql_str = "SELECT Sum(Amount) as m " & _ "FROM Entry INNER JOIN Items ON...

i have an access 2000 data base and need to read the location code. but each location is listed several times how in vb can i get the combo box to show only one accurance of the location code. to where the user can select a specific location. there are 30 locations. in the database it is in the...

i have three files that i need to put into an access database and it dont except the file extensions any help on how i would get these files into a data base would be greatly appreciated. the file extensions are .HDR .ENT .ITM when i try to export them it wont send the data

want to know if using an excel worksheet can be used as a report page. and if so how do i add it to my project. any help would be greatly appriciated. thanks Rick

have setup a microsoft access 2000 database. when i go to import the file the import options wont let me select the needed extension (.JRN) how could i import this file into the database with or with out the import in the file menu. also the drop down menu only lets me select text,excell...

we download files everynight via phone line and dialups. i want to read this file and verify that all locations pulled and email me the names of the ones that did not pull. have tried with a form and with out. any ideas or help to get this done would be most appreciated

i need to scan a file and verify to a master list and email the nonconfirmed records. how do you start a project in vb without a form or can it be done.

how do i pull in an ascii file to load access tables.

new to c++ and need to create program to read a file check it to a master file and send the missing files to an email address. any help to get me started would be mest appreciated.