in
All Tags » VBA » query (RSS)

Browse by Tags

  • Importing Psinfo csv into access query

    Hi I am guessing I might need VBA code here but firstly the problem. I have used Psinfo to create a csv (psinfo.exe \\* -s Applications -c -t ? >inventory.csv) Then I wanted a summary of who had what on what machine so i thought i would import it into access. However this imports fine with pcname...
    Posted to Access (Forum) by microsoft on 04-27-2010

  • ACCESS 2003 - HOW TO REFRESH/REQUERY THE QUERY IN SUBFORM AFTER RECORDS ARE DELETED

    USING VBA TO DELETE A RECORD ON A TABLE/QUERY BEING VIEWED IN A FORM, HOW CAN I REFRESH (NAMES IN PARENTHESES) THE TABLE/QUERY WHILE THE USER IS STILL VIEWING IT IN THE FORMS' SUBFORM ..... HERE'S THE HIERARCHY OF CONTROLS, ETC. A QUERY (QRY_ASSIGNED) ...ON A SUBFORM (QRY_ASSIGNED_SUBFORM) ....
    Posted to Access Forms (Forum) by microsoft on 04-15-2010

  • Query database form

    I have a TAB control placed on a form. The first TAB is used to find the user's desired record(s). On the first TAB are the following; a COMBO control, and a TEXT BOX control. Using the COMBO control, the user selects the FIELD he/she would like to search. The TEXT BOX allows the user to then put...
    Posted to Access (Forum) by microsoft on 04-10-2010

  • VB will not pass parameter value to Access query if the WHERE clause has a less than < sign

    I have an Access query that receives its parameter from VB. The parameter is [DC], defined as =now() - Forms!DaysClosed!DaysClosed. This allows the user to enter the number of days before today in the DaysClosed form and then filters the data using the [cost codes closeout] query. The problem is that...
    Posted to Access (Forum) by microsoft on 04-10-2010

  • VBA query times out, ignores connection timeout setting

    I have a VBA form that is timing out accessing a MS SQL server view. I have two button on this form. On runs a report preview a la the standard wizard setup. The other run code in the form where I open the view and loop through the rows outputting a text transaction file. The view takes about 1:14 minutes...
    Posted to Access (Forum) by microsoft on 04-10-2010

  • How do I query an Excel 2007 table using VBA in Access 2007?

    Background: I have an Excel file, used for data tracking purposes, with columns of information changing depending on the month and year when the file was downloaded from the server. I can't tap into the server using SQL or something else, and I can't stop the output file from randomizing some...
    Posted to Access (Forum) by microsoft on 03-12-2010

  • Query record count in vba

    What's the best way to find out how many records in a query via VBA?
    Posted to Access (Forum) by microsoft on 03-05-2010

  • How Do I Check a Multi-Word String and Build a SQL Query in VBA

    Hi Experts! I need some help from a VBA string guru. My Access database has a form that allows the user to type search criteria for various fields and run a report against their search criteria. When they click the Print Report button, VBA code builds a query by looping through the form controls and...
    Posted to Access Coding/Macros (Forum) by microsoft on 03-04-2010

  • VBA Report Recordsource Issue/Question

    don't want to hear about the structure of my database. I just want to know how to accomplish this task. I have I series of colonies that consist of the same table. I have a variable that holds the colony number from login. I would rather not make a few copies of the same report. I have a report with...
    Posted to Access (Forum) by microsoft on 02-15-2010

  • Filter on split form

    I have a split form sourced from a query(qry1). I need to put two combo boxes (cmb1 and cmb2) on the form to filter the data sheet part (field1 and field2). When user chooses the value in either of these combo boxes, the data sheet will filter accordingly. Meanwhile, other combo box, which the user doesn't...
    Posted to Access (Forum) by microsoft on 02-02-2010
Page 1 of 7 (70 items) 1 2 3 4 5 Next > ... Last ยป