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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by mharpe

  1. mharpe

    Transaction log controltype property problem

    Thanks for all your help... Here's the solution: This didn't work: If rst!(ctl.Name).Type = dbMemo Then This works: If rst.Fields(MyCtrl.ControlSource).Type = dbMemo Then Thanks you all
  2. mharpe

    Transaction log controltype property problem

    Thanks for your help Aceman... I'm new at using VBA to let access to the things I want... so sorry for not being clear when asking questions.. I tried to use the recordset code you gave me but I'm still getting an error. The error is: "Type declaration character does not match declared data...
  3. mharpe

    Transaction log controltype property problem

    I know and I did follow his advice and saw that... But I didn't write this piece of code myself (see link for original code) and I saw any comments with it that it didn't work..And the creator states that it has been tested properly.. What would then be the proper way to make a difference...
  4. mharpe

    Transaction log controltype property problem

    Sorry if i wasn't clear enough... Hope you can still help me out... Here is the whole code I used: http://www.tek-tips.com/faqs.cfm?fid=291 My problem is in this piece of the code: If (MyCtrl.ControlType = dbMemo) Then Hist = "tblHistMemo"...
  5. mharpe

    Transaction log controltype property problem

    Hi, I'm also trying to make a changelog.. I have a piece of code that checks if a control on a form is a textfield or a memofield.. I'm using this code for it but the MyCtrl.ControlType results in a numeric value everytime so the statement is False everytime.. Does anyone know why this doesn't...
See more

Part and Inventory Search

Back
Top