Re: Double Click Syntax

"jeff" <jazzy.jeff.81@xxxxxxxxx> wrote

I did try this, but unfortunately I'm not sure
where my colleagues have the cd for the software,
because it always prompts me to install the help
files when I try and do this. I guess that's my
next step though.

Yes, you need to do this -- newsgroups are not a substitute for Help.

I'm not too sure what you mean by the type of
control (i'm pretty new to this side of access),
but it is just a text box. There is no list box.

The code you show was written for a List Box. I can't imagine that it ever
worked, in any circumstances, with a Text Box.

You really _have_ to educate yourself on Access issues before trying to
maintain the Access database application. Newsgroups are for learning, and
for volunteers to help users "over the rough spots"; they are not a source
for getting freebie work.

A good series of books I have found for the novice is the "Access <version>
Step by Step" from Microsoft Press. Roger Jenkins' "Using Access
<version> -- Special Edition" starts at the beginning and goes farther, as
does John Viescas et al's "Microsoft Access Inside/Out" from Microsoft
Press, both of which are good. Then you're going to need to learn VBA in the
context of Access' object model -- I'm familiar with Wrox Press "Access 2003
VBA" and "Access 2007 VBA" by Hennig, Stein, et al, and recommend those.

Perhaps I need to use a different command
to ItemsSelected?

If it is a Text Box, you should be able to just eliminate the IF...THEN and
END IF statements, leaving only the DoCmd.OpenForm in the code you quoted.

Larry Linson
Microsoft Access MVP


.

Relevant Pages

  • Re: VBA Error #429: ActiveX component cant create object
    ... I have a VBA procedure which sends an email. ... Late binding means you can safely remove the reference and only have ... an error when the app executes lines of code in question. ... Tony Toews, Microsoft Access MVP ...
    (microsoft.public.access.modulesdaovba)
  • Re: how to export a text file to ansys and text file to structure
    ... This newsgroup is for use of VBA in modules in the Microsoft Access database ... software product. ... An Autocad newsgroup would clearly be a better choice. ...
    (microsoft.public.access.modulesdaovba)
  • Re: table field in vba
    ... there is nothing that checks up on us, as there is in the vba editor. ... If you're doing a whole bunch of these things declaring field ... with names like FLPR-Q1 thru FLPR-Q10 ... Tony Toews, Microsoft Access MVP ...
    (comp.databases.ms-access)
  • Re: Adding new values to combo boxes (overriding the item not in l
    ... In the process of updating all my databases with this. ... new at databases (but work in the scientific field) but would like to get ... > Microsoft Access 2003 VBA Programmer's Reference ...
    (microsoft.public.access.modulesdaovba)
  • Re: automate "sending" email via MAPI
    ... I did not leave the original poster high and dry. ... thing in combatting your soliciting business in the newsgroups. ... I work on a fixed fee basis and every customer always knows what my fees ... Tony Toews, Microsoft Access MVP ...
    (microsoft.public.access.modulesdaovba)
Loading