Search results

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

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

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

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

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

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

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