Search results for query: *

i already did. now im using the checkbox from active control and its working

Hi, i have a form with three checkbox, for example: (Check8) (check9) (check10) and i have a button "select" to select all the checkbox. I inserted the code: Me.Check10 = true i have tried too Me.Check10 = 1 but when i press the button appears the following mistake: "run-time...

Hi, I have created this code to save the info of one table in excel : but in the end i stay with two sheets: sheet1 and F01Incos01. Can u help me? i just want to stay with the sheet "F01Incos01" Private Sub Command329_Click() Dim newExcelApp As Excel.Application Dim newWbk As Excel.Workbook...

thanks! it's working :D

how can i bound?

hi, so, i have this table: "T_MES" date1 date2 31/08/2015 09/09/2015 How can I change the date through a calendar? I create a form with two textbox.. and in the properties I select this: PROPERTY format: shortdate Show date picker: for dates so, efverytime I click in the textbox...

Thanks what is the best option? i want to complete one table (with just one line: fec_date fec_fichero) but i don't want to type the date in a inpubox for example i want to select the date through a calendar i'm working with access

Hi, How can i insert the value of a textbox with format: Date in a table ?

ok done. but now i have another problem there is my code: strTxtPath = "G:\Joana\INC01.txt" Set ts = fso.CreateTextFile(strTxtPath, True) ts.Close DoCmd.TransferText acExportDelim, ("Inc01 Export Specification"), "Inc01_valor", strTxtPath, True Set ts = Nothing appears the runtime error...

i can't do it anyway. Appears: "the text file specification does not exist

access 2010 :)

i tried your code but i couldn't change manually the specifications in my database

i used this code: DoCmd.OutputTo acOutputQuery, "Interface_F01Incos0" & i & "_valor", acFormatTXT, strTxtPath, False query-"Interface_F01Incos0" & i & "_valor" strTxtPath = "G:\OrcControlo\SCC\Joana\INCOS0" & i & entidad & ".txt" but each time a run the code i get this: |...

i just want to export the data of my table to a .csv file.. :) and save

i forgot. i wanna use vba

Hi i'm trying to export a table from access to a text file i found this info: expression .TransferText(TransferType, SpecificationName, TableName, FileName, HasFieldNames, HTMLTableName, CodePage) can you explain me what i should put in: SpecificationName?

yeees i understand! thank yoou so much for your help :D

Yes you are right. i miss that point! thanks my code works, i add "newWbk.save" before close the workbook thanks

Hi, I have this code: Private Sub Command286_Click() Dim newExcelApp As Excel.Application Dim newWbk As Excel.Workbook Dim newWkSheet As Excel.Worksheet Set newExcelApp = Excel.Application Set newWbk = newExcelApp.Workbooks.Add Set newWkSheet = newWbk.Worksheets(1) Dim i As Integer For i...

sorry i was using access queries. but i already solve the problem thanks :D