Search results

  1. I

    Form Criteria

    I use a form to select the perameters for data to be exported a to an excel sheet. Is it possible to export the dates selected on the form text boxs to a worksheet as well.
  2. I

    Calculate Cell Values

    Hi The rows can change not the column.
  3. I

    Calculate Cell Values

    Hi I have found this code which calculates a cell value but the code is restricted to Range("B1:B3"), my problem is that the column range can change depending on data exported to excel, can anyone advise on how to overcome this! Dim rng As Range Dim Lraw As Long 'Calculate moving average Set...
    • IanT
    • Thread
    • Replies: 6
    • Forum: Excel
  4. I

    Vba

    Hi I need to be able to select the last cell in a column of data and use the value in a vba function, can any help with this! The column of data will change as I run a report. Thanks.
    • IanT
    • Thread
    • Replies: 3
    • Forum: Excel
  5. I

    Number of weeks in a month

    Hi Is there a way of calculating the number of weeks in a month!
  6. I

    List Box

    Is it possible to: 1 Centre the data in a list box column 2 Format the data from number to currncy Can anyone help!
  7. I

    Sub Reports

    I have a report with sub reports attached, when the data chabges in volume the subs move up and down the page, is it possible to stop this and make the subs static on the page.
  8. I

    String to Number

    Hi How can you convert a string to number format. I have tried format, but when I export the data to excel the data is still in string format!
  9. I

    Listbox

    Hi Does anyone no how to unselect rows which have been selected in a listbox using code!
  10. I

    Input Box Error

    Hi I am using a input box but when you select cancel during the input process it errors and debug appears. There is code to deal with errors but for some reason it does not work! Has anyone any ideas!
  11. I

    DCount

    Hi Can anyone see what I have done incorrctly as this does not work! Thanks in advance..... =DCount("[call type]","qryISAHistoryCount","[Label] = 'Call'" And "[User] = 'Craig'")
    • IanT
    • Thread
    • Replies: 1
    • Forum: Forms
  12. I

    Link to Access Table ODBC

    Hi Can anyone advise me on code which would create a link to a access table using ODBC. I need this as the database is on a network. Thanks in advance....
  13. I

    Break Lock on Table

    Hi Is it possible to break a lock on a table! Thanks in advance...
  14. I

    Table Data Type

    Hi Is it possible by using code to change the Data Type in a table from text to number!
  15. I

    Printing Report

    Hi Can you put in code that when a document is printed it prints 2 sided! Thanks in advance
  16. I

    Call Form_Load()

    Hi Does anyone no how you can call the Form_Load() of another form from a existing form!
  17. I

    SQL Insert Into

    Hi I am using this code to append data to a table, the code appends once ok then if you try again there is a error saying it cannot append any records. Can anyone help! Dim db As DAO.Database Dim SQL As String Dim strActivityType As String Dim strNow As String Dim strProdCode As String Set...
  18. I

    Goldmine

    Does anyone no if it is possible to replicate the current address data on a Goldmine form to a form in Access.
  19. I

    Input Message Box

    I am using Input Message Box to obtain filter data. Is it possible to catch when someone uses the cancel button on the input box. If cancel is used I would like to responed with code a message box for example!
  20. I

    Check Excel Sheet Open

    Hi I am using the code below to check if a Excel workbook is open or not. The problem is that it does not close the workbook correctly, can anyone advise me why yhis is happening! Function ExcelDocTest() Dim xlApp As Excel.Application Dim Wbk As Excel.Workbook Dim BolYN As Boolean Set xlApp...
Back
Top Bottom