Search results

  1. E

    Excel backcolor cell from Access

    Hello all... How can I change the backcolor of an excel cell from access?? I've got this variables: Dim sheet As Object Dim con As Connection Dim appexcel As Object 'Excel.Application and then: Set appexcel = CreateObject("Excel.application") Set conn =...
  2. E

    open and write an excel file

    Hello all! I'm having problems opening and writing into an excel file, the code i've got is the following: Dim xlApps As New Excel.Application Dim xlwrkbs As Excel.workbook Dim xlsht As Excel.worksheet Set xlwrkbs = GetObject("Text.xls") Set xlsht = xlwrkbs.worksheet(1) xlsht.cells(1, "A")...
    • Eliot
    • Thread
    • Replies: 1
    • Forum: Excel
  3. E

    long and complicated query...

    Hello all! I find it difficult to build a query... The scenerario is the following: I have a table that keeps information for weeks about some files (e.g: if the file has been sent). Then I have another table with information for days in a month (the data for every day). What I should do is...
  4. E

    dynamic query

    Hello all!! I need to create a query dynamically, and I can create it in the report code, but how can I assign that query as the report query?? I'm missing a sentence and can't find out what it is...
  5. E

    Number of registers in access

    Hello all!! I've got a question and I can't find the answer, hope you'll help me!! I'm developing an application in access 2003, almost finish, and i'm not sure whether the application will be capable of keeping all the amount of data that will be inserted in it... It will be about 4000...
  6. E

    creating a report from a form

    Hey! I got the solution, the problem was that all the textboxes where created on over the other, so i only could see the last one, that had as a value -1... Solution: add a left margin everytime!
  7. E

    creating a report from a form

    Hello, My report is already created, but I need to create the textboxes by code from a form. I found a way to do it in the microsoft site, but no way to have it working. My code is the following: DoCmd.OpenReport "test4", acViewDesign Set rpt = Reports![test4] Set rcset =...
  8. E

    create a report from a form

    Hello, i need to create a report from a form. I found a way to do it in the microsoft site, but no way to have it working. My code is the following: DoCmd.OpenReport "test4", acViewDesign Set rpt = Reports![test4] Set rcset = CodeDb.OpenRecordset(querystring) rpt.RecordSource = querystring...
Back
Top Bottom