Re: clipboard.settext isnt working in Access2007 ?? help ?

Tech-Archive recommends: Speed Up your PC by fixing your registry

<g.matters@xxxxxxxxxxxxxxx> wrote in message news:1179840847.779893.121710@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

here is sample of my code used on a form in
DAtabase ACCESS 2007 [big snip]
clipboard.SetText GKM, vbCFText
Every time i go to run this it comes up with erro:
Runtime error 424 Object required

That's because VBA does not have a Clipboard object. You'll need to use the various API clipboard functions instead. Also, you need to post your VBA questions to a VBA (preferably an Access VBA) newsgroup. This group is for the full version of Visual Basic (VB6), which is different in many ways.

Mike



.

Relevant Pages

  • Re: New at Programming
    ... >> In sci.physics, Androcles ... The definition of an lvalue is a bit technical ... to int and denies the subexpression ... >> It's still legal to go .sigless. ...
    (sci.physics)
  • Re: Damn you, FEDEX! or Nikon D40 lost in Springfield, MO blackhole.
    ... the 2 mp Mavica he had been using with a Nikon D40. ... After shopping around, he got me to order one for him. ... The shipper had it insured, but from what I have read it could take weeks to sort this crap out. ... You may get your insurance from FedEx and a couple weeks later they find it and deliver it. ...
    (alt.photography)
  • Re: 2007 access
    ... Access Runtime error that means: ... be that the Provider isn't recognizing the new format. ... Word users take advantage of ADO DB connectivity, even the Word VBA ... Here's the connection string for Access 2007. ...
    (microsoft.public.word.newusers)
  • Re: Empty "If Me.Recordset Is Nothing Then" clause causes runtime error 3021 (Access 2003)
    ... If you use VBA to delete all records in a recordset that is ... records that don't exist any more - runtime error 3021. ... after all records have been deleted (eg. by calling MoveFirst). ... However I thought calling Requery makes ...
    (microsoft.public.access.formscoding)
  • Re: Empty "If Me.Recordset Is Nothing Then" clause causes runtime error 3021 (Access 2003)
    ... If you use VBA to delete all records in a recordset that is ... records that don't exist any more - runtime error 3021. ... after all records have been deleted (eg. by calling MoveFirst). ... However I thought calling Requery makes ...
    (microsoft.public.access.forms)