Search results for query: *

Anybody knows how to send a null date value to Oracle from MS Access? This is either through an update query and/or update statement. Thanks

There is a property called "Allow Edits" have, you make sure is set to Yes?

I would create a small loop to add everything to a Variable then write the value to the textbox for display. For example, no the OnClick even of the Customer you want to see you do something like, Function XXX strSQL = "YOUR SQL STATEMET WHERE CLIENT_ID = " & RecordSetClone(ID) Set...

L.H - Glad that you got it to work!. The use of the form name rather that ME makes it easy for other people to read when you have multimple call to multiple objects all over the place. Also, when you refer to objects in your form you don't even have to use the ME! as the form will know that the...

I agree with markphsd, looks like the extencion of your files may be wrong. Also make sure that the path is 100% correct with no error, typos, or the slash pointing in the wrong direction. MS is special on giving error that have nothing to do with what is going on. The name of you form look...

Repair the database, this should fix the problem. HAH

I wonder, do you have a Picture frame named Map? It looks like you are update such an object instead of the form. If is the form property your code should be Me.Picture or Me!Picture (I never use Me! I use frmName.Picture) I would recomend though to use a Picture frame named Pic1 in a corner of...

Do you have code on the OnChange event of any of you fields? A change on focus may do this to you.

Hello All: I have a linked table from SQL Server 2000 into Access97. When trying to update the data with the recordselector in a form I get a 306 Error "Cannot update without using IS NULL or LIKE operators". I have no clue as how to set the recordsetclone to use those operators...

Have you check the Set of the CurrentDb object. Alse make sure that the table is created, or if the previous database had a TableDef to create the table before you could use it. You may have a line like [code[Set CurrentDb = Dbengine.workspaces(0).databases(0) [/code] somewhere for your record...