Search results

  1. C

    Excel 11 Component

    Guys, I have added an excel component to a form but I'm having trouble accessing the cells etc via vba Do I need to declare it as a spreadsheet? Spreadsheet0.(Intellisense pops up but nothing with regards to ranges cells etc) Any help would be appreciated. Thanks
  2. C

    converting data types with linked tables

    Hi, I have 2 linked tables, I would like to join these tables in access, however the first table's field is a memo and the second table is a number. I have tried to cint() the field in a query but I get an error message "Explicit conversion from datatype text to smallint is not allowed" Any...
  3. C

    forms!.... .value problem

    Hi, most of this code works fine... SELECT Forms!FRM_UKBA_AMENDMENTS_INPUT!ACCOUNT_NUMBER.value AS Expr1, Forms!FRM_UKBA_AMENDMENTS_INPUT!SORT_CODE.value AS Expr2, Forms!FRM_UKBA_AMENDMENTS_INPUT!PRODUCT_IDENTIFIER.value AS Expr3, Forms!FRM_UKBA_AMENDMENTS_INPUT!VALUE_LINE_IDENTIFIER.value AS...
  4. C

    Binding a table to an excel sheet on form

    Hi, I would like to bind a table in my database to an excel sheet on my main form any ideas how I can do that? Thanks
  5. C

    Textbox value not inserting

    Hi, Can anyone tell me what i'm doing wrong with this insert statement? INSERT INTO TBL_PROCESS_NAME VALUES( ' & [Forms]![frmIntroduction]![txtProcess_Name] & ' ) the form is loaded when the query is run, i've tried taking out the & and the ' but to no avail, all i get in the table is...
Top Bottom