Search results for query: *

thanks all got it going cant believe i didnt think of a batch file.

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

-have changed it but now getting a no value in required parameter error again. entryTable is a table and amount is a feild in that table. all i am want is to read the files in the tables and add all the amounts and put them into and excell spreadsheet under the right location. sql_str =...

i am getting an error message of undefined function ' EntryTable' in expression. i have the debug.print sql_str in the code but dont give me anything. sql_str = "SELECT EntryTable(Amount) as m " & _ "FROM EntryTable INNER JOIN HeaderTable ON EntryTable.[Reference...

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

would like to thank all you for your help putting the brackets in got me passed that error know i just got to get rid of the rest :) but thanks again.

Public Sub Import() Dim sht As Worksheet Dim conn_str As String Dim sql_str As String Dim cn As ADODB.Connection Dim rs As ADODB.Recordset Dim i As Integer Dim j As Integer conn_str = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\Documents and...

the # characters are part of the feild in the database reference # = reference number

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

it looks like they all pulled with the double number thanks for all your help.

i think thats it my reference number goes up to 3087405397 and starts at 187400001. how would i get access to acept the higher numbers. and i really do appreciate all your help. thanks.

it is defined as a number long int the data that goes in this feild is all a 10 digit reference4 number. out of 23497 records it only imports 19,000 records in that feild but in the other 7 feilds it pulls all 23497 records just not the refence number for the last couple thousand. do you think i...

thank you thornmastr. but it is only one column of a file and in that caolumn is a 10 digit number have looked at the raw data and all seem to be a number but it stil wont pull in that part of the column but will pull in the rest of the columns. will try to define and see if that helps.

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

sorry it errors on line: rs.open SQL_str, cn, adopenstatic, adlockreadonly

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

it it being populated through the select staement but it shows all the locationcaodes in order. example if BGU had 500 transactions the combo box will show 500 location codes instead of just one. will try the select distinct and i do thank you for your help

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