Recent content by c19h28O2

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

Rabbie, Thanks for the reply. I didn't design the database or the tables that I am trying to join, In an ideal world they would both be a number but as I say I had no input on the table design. So back to my original question, is it possible to convert (in access) a memo field to a number...

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

Apolgoies, 9 is a text field and both 10 and 7 are date fields on the table...., i did have it working but its very very temperamental! Any ideas?

Guys, the code should like this this..... 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...

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

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

Hi SJ McAbney, This solved the problem, INSERT INTO TBL_PROCESS_NAME ( PROCESS_NAME ) SELECT Forms!frmIntroduction!txtProcess_Name.Text AS Expr1; I clicked on the Design View and then back to the sql view and it started working. Thanks for your help

Thanks, that would make sense re the apostrophe. I've amended the code but the inserted is blank. I've double checked the form name and the textbox name, also the field is unbound (not sure if that makes a difference) also the form is running when I input the value into it. Any ideas what else...

Ahh i see what you mean, that was meant to mean, "its one field so do i still need to declare what field to input" but i suppose your not a mind reader so apologies for that! Its in an append query. Thanks Michael

Hi, The table has only one field? when i run the query the table shows a value of [forms]![frmIntroduction..... so it looks like its not replacing the value with whats in the text box, but it is inserting data..

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