Search results
-
G
yet an other newbee... (syntax question)
Hi, I am trying to create a report from vba with a condition. So far I have tried: Dim IntCompanyCode As Integer DoCmd.OpenReport "Invoice", acViewPreview, , Inv_Nr = 15 and: IntCompanyCode = 15 DoCmd.OpenReport "Invoice", acViewPreview Invoice.Filter = "((Inv_Nr) = " &...- gussi
- Thread
- Replies: 2
- Forum: Modules & VBA
-
G
Extra ' in excel
Extra ' in excel, please help Hi all, When I use: objDB.Execute _ "SELECT * INTO [Excel 8.0;DATABASE=" & strExcelFile & _ "].[" & strWorksheet & "] FROM [" & strQuery & "]" I get an extra single quotation mark (') at the begining of every post in Excel. Does anyone know why and how I...- gussi
- Thread
- Replies: 0
- Forum: Modules & VBA
-
G
SQL in access,
Hi all, I want to create a module that exports data to excel. I found some help on the internet but I can't get it to work. This is my code: strExcelFile = "H:\TEMP\test.xls" strWorksheet = "test" strDB = "H:\TEMP\testdatabas.mdb" strTable = "tabel" strQuery = "query" strString = "Name"...- gussi
- Thread
- Replies: 2
- Forum: Modules & VBA