Search results

Sorry, I meant & "'" & ..... & "'" & Cheers Have a good day!

Phew, I got it to work. "'"Me![cboCustomerSearch].Column(1)"'" Thanks for the hints

Thanks for the quick reply. I tried the single quotes but I get a 'expected expression' error (note, originally I had a numeric column). Without the single quotes the debug_print gives the following; SELECT * FROM tblApplication INNER JOIN tblCustomer ON tblApplication.cust_id =...

Thanks for the quick reply. With single quotes i.e. ''Me![cboCustomerSearch].Column(1)' I get an 'expected expression' compile error. The debug_print gives the following; SELECT * FROM tblApplication INNER JOIN tblCustomer ON tblApplication.cust_id = tblCustomer.cust_id WHERE...

Thanks for the quick reply. I tried the single quotes but I get a 'expected expression' error (note, originally I had a numeric column). Without the single quotes the debug_print gives the following; SELECT * FROM tblApplication INNER JOIN tblCustomer ON tblApplication.cust_id =...

Hi I'm using the following vba to reset the record source i.e. (Me.RecordSource = strFilter) strFilter = "SELECT * FROM tblApplication INNER JOIN tblCustomer ON tblApplication.cust_id = tblCustomer.cust_id " & _ "WHERE (tblCustomer.cust_short_name) = " &...

I have a table with an OLE object field. I display a list of records in a listbox where the OLE field is not displayed. The listbox is single select and unbounded. I wish to use a command button to reference an OLE field and activate it. I beleive I can reference the OLE field with something...

Yes, I beleive they are all dates. Thanks for the reply. I haven't been able to return to this problem but now that I can I am trying out different drivers to see if I get a better result.

Hi All, Using Access 2003 to link to Oracle I get the following message on some tables; 'Invalid field definition 'DATE_CONFIRMED' in definition of index or relationship' Any ideas on what may hbe causing this?

Hi, I have an ODBC connection from MS Access to Oracle. On some linked tables I get the following message 'ODBC--call failed' 'Microsoft][ODBC Driver Manager] Function sequence error (#0)' I've used two drivers with the same result 'Oracle in instantclient10_2' 'microsoft ODBC for Oracle'...

I thankyou You are correct. I'll see if I can un-group something cheers bob

Thanks I tried putting the where clause where you suggested, it got rid of the error but I but I'm still getting duplicate customer_no rows. I took the where clause from an example on the Net which is supposed to show distinct on one field only, but I'm not sure how setting the count equal to...

Hi, When I place the following code into a query I get a syntax error (syntax error missing operator in mgrwms_party.customer_no WHERE mgrwms_party.customer_no IN (SELECT T2.customer_no FROM mgrwms_party AS T2 GROUP BY T2.customer_no HAVING COUNT(T2.customer_no)=1);) code: SELECT...

Sorry about the spelling! I must have been staring at it too long. I'm not getting the error I was before but the values are bit strange, but I'll should be able to sort that out Once again Thanks fellas bob

I hope someone can help me. I'm pulling my hair out. I'm getting an error on an rst.open. 'No value given for one or more required parameters' I'm using ADO Here is some of the code: ================================================================ whereis = "...

Thanks fellas. The count works now.:)

I have an ODBC connection from an ACCESS database to a MYSQL database. One of the tables contains just over 5 million records. If I try to count the records using the code below, I get a message box with 'Overflow' text and an OK button. If I try to display the records by double clicking the...

I'm working from within Access. I wish to create a graph in excel from vba Access and display it in a access report. I think I know enough of the vba to create the graph but how do I reference it back into an access report?:confused:

I want to run AutoExec at db startup and in it call a function to change the current database permissions for the user so thay cannot edit the tables. What vba code is required for the function? :)