Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: HAH
  • Order by date
  1. HAH

    Oracle Update through Access 97?

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

    recordset not updateable

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

    Getting Grand Total from the Sum of Numbers in a different table

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

    Linking Images

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

    Linking Images

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

    Simple compile error

    Repair the database, this should fix the problem. HAH
  7. HAH

    Linking Images

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

    FORM CURRENT 'refresh' PROBLEM

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

    Error #306 on a Linked Table

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

    Open Recordset Problem

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

Part and Inventory Search

Back
Top