Results 1 to 1 of 1

Dot(.) VS Bang(!)

Threaded View

  1. #1
    Forum Contributor
    Join Date
    04-23-2009
    Location
    IOWA
    MS-Off Ver
    2010 Professional
    Posts
    270

    Dot(.) VS Bang(!)

    I know there are lots of people who come here and are new to Access and VBA. With that in mind I figured I would mention this topic, as not long ago I saw no difference.

    Me.Quantity
    Me!Quantity

    This is a big discussion really, some people say Bang(!) is faster then Dot(.), but I figured I would show you one of the most basic differences.

    Lets say I have a form called Order Details. In order to use the top one "Dot(.)" there would have to be a field on the form called "Quantity". By using the "Bang(!)" if there is a field in the attached recordset it will update it.

    Feel free to correct me if I am wrong. Just thought I would share.

    Dan
    Last edited by shg; 06-12-2010 at 01:06 PM.
    "I am not a rocket scientist, I am a nuclear engineer." - Split_atom18
    If my advice has been helpful to you, then please help me by clicking on the "Star" and adding to my reputation, Thanks!

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1