Page 2 of 2 FirstFirst 12
Results 16 to 19 of 19
  1. #16
    CarlettoFed is offline Competent Performer
    Windows 7 64bit Access 2013 32bit
    Join Date
    Dec 2019
    Posts
    255

    Reply

    Look at the attached example.

    Passing Data Issue.zip

  2. #17
    Dave14867's Avatar
    Dave14867 is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Nov 2016
    Location
    Upstate NY
    Posts
    376
    June7,

    Yes, I find it very confusing when to use brackets, when to use an Exclamation point, etc. I have to get a better handle on that. I still am working on trying to understand it better and have been watching videos on it and received a text book today so I can get a better understanding of it. I have developed other db's that worked great and held records for tens of thousands of records and could track materials from when they came in to exactly what lot # of materials they were shipped out on but never got into modules. Now with this one I can see a real benefit to using modules for certain things, the least of which is writing code only once and reusing it but it all falls on who is logged on.

    Once I get my head wrapped around the global variables I'll have it, that's just how it works for me, it may take me awhile then all of a sudden I get it and it makes sense, I know there is a way to do it, I just have to figure out how, then make sure the syntax is correct (Brackets or not, exclamation point or brackets, etc.). For instance, I tried to put "user" in the default field in the field control and Access automatically put brackets around it.

    Thanks so much for your assistance and understanding.

  3. #18
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Using it in a textbox ControlSource, Access expects to find a field name.

    Again, if it's a VBA declared variable, do not use brackets or exclamation point or dot. Those are used with Access objects (field, control, table, query, form, report).
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  4. #19
    CarlettoFed is offline Competent Performer
    Windows 7 64bit Access 2013 32bit
    Join Date
    Dec 2019
    Posts
    255
    Have you ever looked at the example?

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 4
    Last Post: 10-16-2017, 09:09 AM
  2. Compile Error: Sub/Function not defined
    By TheKillerMonkey in forum Programming
    Replies: 12
    Last Post: 04-18-2016, 01:48 PM
  3. Compile Error Sub or function not defined
    By Ray67 in forum Reports
    Replies: 3
    Last Post: 07-02-2012, 04:11 PM
  4. Compile error: code or function not defined
    By GeorgeBrown in forum Access
    Replies: 1
    Last Post: 09-19-2011, 10:25 AM
  5. Compile error. Sub of function not defined
    By plavookins in forum Reports
    Replies: 7
    Last Post: 04-22-2011, 10:15 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums