Search results

  1. V

    Help with adding to the code

    is still giving me the same error. the excel is open from previous command. whatelse might be.. i am opening a recordset. selecting/adding a sheet and then copying then the same again untill all my tables are copied. any ideas?
  2. V

    Help with adding to the code

    Object Required? When i try to change the Activesheet to Sheet2 i get the error "object required" Any ideas? Set Rs2 = CurrentDb.OpenRecordset("SELECT * FROM RN00144GE4RFG;") Do While Not Rs2.EOF 'set the reference to the Active Sheet Set wks = Sheets("Sheet2").Select
  3. V

    Help with adding to the code

    that will not give me the chance to export tables to different sheets in the same workbook..
  4. V

    Code for Increments!

    Help with this code Since you were helpfull yesterday.. could i get your idea on this one? thank u so much in advace.. http://www.access-programmers.co.uk/forums/showthread.php?t=123452
  5. V

    Help with adding to the code

    After testing and reading i came up with the following code to export a single table ton an Excel Spreadsheet. I cant get to commands for all the things i want.. so if someone can help me or direct me i would be gratefull. 1. I want to export all tables (their names are lister in a table, so i...
  6. V

    Code for Increments!

    Different Question Since you know more than me.. one more question.. I am about to finish my first Access database.. Most of the functions are done be seperate Modules that i wrote. i need to execute these modules one by one after the click of one button. is there a way? or do i need to add...
  7. V

    Code for Increments!

    This is exactly what i want! Thank you so much i appreciate the help! i will study the code so i can figure out the steps and use it later on.. Cheers!
  8. V

    Code for Increments!

    ok.. instead of writing code for all the tables.. is there a way to write a code for all the tables... this is what i have for the two tables... the name of the tables are listed in Countries tables in the field SOBP.... please help Sub UpdateLine1() Dim rsSOBP As DAO.Recordset Dim strsql As...
  9. V

    Code for Increments!

    i have the following code... Sub Update_Line() Dim strSQL As String Dim rsSOBP As DAO.Recordset Dim a As Integer Set rsSOBP = CurrentDb.OpenRecordset("SELECT SOBP FROM Countries;") Do While Not rsSOBP.EOF a = a + 10 strSQL = "UPDATE " & rsSOBP!SOBP & " SET Line = " & a & ";"...
  10. V

    Type Conversion error

    i am importing using vb.. and it works fine except that field.. i dont want to change it.. is there a way to modify this? ub Import_TD() Dim i As Integer With Application.FileSearch .LookIn = "c:\Input Files\TD" .SearchSubFolders = False .FileName = "*.xls" If .Execute() > 0 Then MsgBox...
  11. V

    Export Access Query To Multiple Excel Worsheets in 1 Workbook

    How would i change your this code to get different worksheets for an array of tables in my database. each sheet should have the name of the table and the file of the spreasheet should be something + a date? any suggestions?
  12. V

    Type Conversion error

    i am importing from excel and i have a column that has account numbers and at some point i have an account like this... 2C1C18100 on the import i get an error. i set the field to memo, numner or text and still get the same error.. any suggestions? thanks in advance
  13. V

    Query in VBA Syntax!

    Is there a site that will indicate how do i syntax queries in VBA. i cant figure the syntax out. I have searched this site and google and i cant find a unique way to write my queries in vba.. for example.. i get an synatax error on this.. Sub Update_SOBP() Dim rs As DAO.Recordset Dim strSQL...
  14. V

    Append with VB

    Problem solved! I was using stupid names for my fields. With characters that were not acceptaple. Do not use / or space in your fields. thanks for the guidance...
  15. V

    Append with VB

    I know what you mean.. but my destination table is not the same. it has more fields so i want to tell my query where to put the fields. and yes i have a query 1 and a query 2 and they make then i ihave Q_normal whats wrong with this systax? whatever i do it gives me a Intert Into Syntax...
  16. V

    Append with VB

    well this is my query with one field of the table and it works fine. i am just checking a table which has values then appends to that tables (that values has its corresponding table) and the criteris is a union query.. this works fine.. why is not accepting more than one fields...
  17. V

    Append with VB

    I tried everything and my query doesnt work. i also changed all the fields to text exept one and it seems giving an error message... Someone please help... thanks
  18. V

    Append with VB

    I am trying to append from a query to a table. The procedure checks a table, finds the value and goes and appends to the table found. i liste the fields of the query and the fields of the table.. but something is wrong... When my fields are numbers i put them in brackets? IN this case i have...
  19. V

    DELETE Functions!

    It works great.. thank you so much!:)
  20. V

    DELETE Functions!

    I have a tables that lists all the names of the tables i want to delete. i want to write a procedure that will go and check the values of this table find the corresponding table delete the values. it will be repeated until no more values are found this is what i have so far... Dim rs As...
Back
Top Bottom