Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. JoanaSantos

    Checkbox access

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

    Access - creating workbook (excel)

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

    Select data through a calendar - vba access

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

    Date

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

    export table from access to csv

    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?
  6. JoanaSantos

    access vba

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

    union tables

    i have two tables: month1 Fec_Data - Fec_Ficheiro - CC1 - Total1 1 22 2 25 4 30 month2 Fec_Data - Fec_Ficheiro -...
  8. JoanaSantos

    Insert querie in a textbox

    how can i run a querie and insert the result in my textbox? the result only have one field: fec_data 21/04/2015 the query is a union between two tables(select) INSERT INTO Balancetes_data ( fec_data ) SELECT DISTINCT T_MES.fec_data FROM T_MES INNER JOIN BALANCETES ON T_MES.Fec_Data =...
  9. JoanaSantos

    zip access vba

    Hi, I want to zip some files in my folder. i used this code: 'Compacta e Zip Private Declare Sub Sleep Lib "kernel32" ( _ ByVal dwMilliseconds As Long _ ) Sub compactar_BD01() Application.SetOption "Auto compact", True 'nome do zip / nome do ficheiro origem Zip...
  10. JoanaSantos

    zip access vba

    Hi, I want to zip some files in my folder. i used this code: 'Compacta e Zip Private Declare Sub Sleep Lib "kernel32" ( _ ByVal dwMilliseconds As Long _ ) Sub compactar_BD01() Application.SetOption "Auto compact", True 'nome do zip / nome do ficheiro origem Zip...
  11. JoanaSantos

    export one column to excel

    Hi, how can I export one column from access to excel? using access vba thanks
  12. JoanaSantos

    Find duplicates

    Hi, How can I find duplicates between two tables on access? VBA table1: CC e Total table2: CC e Total
  13. JoanaSantos

    Import from excel

    Hi, how can i import two columns from excel: "D6:D" and "F6:F" to one table in the access (with VBA)?

Part and Inventory Search

Back
Top