Recent content by Atajames

Hi Zemp! I also thought about using the "INSERT" statement to insert record in my access database. Do you know how to write the codes? In case you do please help me do so. James

I entered this line code at the bottom: frmtrans.data1.recordset.update I now have the "run-Time Error 3426", that points to the new code and says: 'This action was cancelled by an associated object'. I'm still stock. Thanks!

Thanks Zemp! I did the search, but I couldn't find an answer to my problem. In fact many problems related to mine weren't answered. These are my codes: Private sub cmdSubmit_click() frmtrans.show frmtrans.data1.recordset.addnew frmtrans.txtfields(0)=frmcustumer.txtId.text...

Hi Guys! I have a Microsoft Access 7.0 database that I built from the Vis.. Data Manager. I also have another form with textboxes. I'm having troubles adding the textboxes data into the database automaitically. Please, I urgently need your help

I entered set db = opendatabase("C:\[Documents and Settings]\craig\[customer info].mdb") but I now have this error: run-time error '3044' invalid path.

I changed the directory and the name of the database. So these are the new codes: set db=opendatabase("c:\inforamtion.mdb") and I now have this run-time error: 3343 UNRECOGNIZED DATABASE FORMAT. Please help James!

I entered set db = opendatabase("C:\[Documents and Settings]\craig\[customer info].mdb") but I now have this error: run-time error '3044' invalid path.

Hi Guys, I'm having problems opening my database. Please tell me what's wrong with this codes. Dim db as database dim rs as recordset set db = opendatabase("C:\Documents and _ Settings\craig\customer info,mdb") When I run the program, I have this error message: Unrecognize database...

Thanks I refereced Microsoft ActiveX Data Objects Recordset 2.7 and Microsoft ActiveX Data Objects 2.x library and it worked just fine.

I'm new at VB and I'm working with an ADODC, but I cannon see the database datatype, and the findfirst, findlast extentions do not appear on my pop up menu. What reference object library do I need to be able to fully use the DATABASE datatype. Please help! Thanks!

Hi ALL, I trying to write a program and the database I'm using is MS Accesss 7.0. However, I need some functionalities on MS Access 2000. When my database was converted in Access 2000, the program could not recognize it. What should I do? Please let me know. James!