Recent content by tj007

mstrmage1768 & TheAceMan1 Both replies are helpful and working fine. Sorry it took so long for me to answer. Thank both of you.

flyover789 Sotty it took so long for me to answer. I have applied your advice and it worked as you stated. Thanks again.

Thanks mstrmage1768 It worked fine. How can I add a message to inform the user that value they have entered is not in the list "do you want to add the value?"

You can link or Import the Oracle tables to Access through ODBC. First create a data source. Open your Access database and go to the Insert menu and select Table. Make a selection to Import or Link the table. Click on the files of type down arrow and select ODBC. You need to select the data...

Hi I need some help. We have an Oracle database that I have link from Oracle to Access 2003. I can see and query the data without problems. The link table name is Oracle_RT_DATA and the Access database name is TMSR.mdb. I have created a query from the Oracle_RT_DATA table name qryrtdata. I...

Hi I have created a table with the contact information.I have a form with a combo box name contact and there is a dropdown list with the names fro which the user can select. Sometimes a new contact is manually type in the form field. How do I populated the contact table with the new contact and...

Thank you I changed the date to a string and I was able to obtain the correct information.

Do I need to convert the date field to a string then do a comparison?

I have supressed other columns, however what is the formula for showing all records for {invoice_podate.INV_DATE}column which comes before >={invoice_podate.NREF_PODATE} column for the same record?

Hi I am tying to compare dates from two fields I would like to show all records that have a INREF_PODATE that is greater than the INV_DATE. I am trying to show when payments were made before an invoice was received. {invoice_podate.INV_DATE} >={invoice_podate.NREF_PODATE}

Strange, I went to another computer and the statement converted the text field perfectly. You guys talk me some valuable skills. Thanks

willi The field is a text and raw data in the form i posted e.g. 20031106. Th statement you posted was formatted text 030803. The REF_PO_DATE is formatted text 20030806. ??? I am still working on it.

oops, this is what happened when I tried this statement UPDATE inv_podate SET inv_podate.REF_PO_DATE = "#" & CDate(Mid(REF_PO_DATE,5,2) & "/" & Mid(REF_PO_DATE,7,2) & "/" & Mid(REF_PO_DATE,1,4)) & "#"; REF_PO_DATE #12/10/0 #04/11/0 #04/11/0 #04/11/0 #04/11/0 #04/11/0

Thanks leslie I will try this. I have been summoned to something else.

Sorry, typos UPDATE inv_podate SET inv_podate.voc_date = "#" & CDate(MID(voc_date,4,2) & "/" & Mid(voc_date,2,2) & "/" & Mid(voc_date,6,2)) & "#";