Page 2 of 2 FirstFirst 12
Results 16 to 22 of 22
  1. #16
    Synergy.ron@gmail.com is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Oct 2020
    Location
    washington
    Posts
    126
    yes! i have watched steve's youtube videos at least 5 times. (what does that say about me!) Yet when working on my app, it fails. The latest is a syntax error: If forms!"switchboard"![txtserial] = "" Then . i've tried every combination of [], ()and "" marks to grock the proper syntax. And yes, the form field names are spelled correctly..... What amI doing wrong??? thanks....

  2. #17
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,398
    try

    If forms!switchboard!txtserial = "" Then

    or

    If forms("switchboard").txtserial = "" Then

  3. #18
    orange's Avatar
    orange is offline Moderator
    Windows 10 Office 365
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716

  4. #19
    Synergy.ron@gmail.com is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Oct 2020
    Location
    washington
    Posts
    126
    Attachment 45040 thanks. Isee why you say I should reference rs.fields("serial"). But, even hat throws an error?

  5. #20
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    In my second post I said posting pictures of code isn't that helpful. Since I can't read what comes before your recent pic (e.g. was db declared anywhere, or is it still at the top of your module?). Or is it that "utility" doesn't exist as spelled? Or is it that rs is no longer declared or is out of scope? I have suggested posting an up to date db and/or code instead of pictures but haven't convinced you it seems. Hope you find a solution.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  6. #21
    orange's Avatar
    orange is offline Moderator
    Windows 10 Office 365
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Agree with micron, post all the code or provide a copy of the database with enough data to show an issue along with instructions to get to the problem area.

    I note you are still trying to use rs.serial vs rs!serial or rs.Fields("serial")

    DAO openRecordset info

  7. #22
    Synergy.ron@gmail.com is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Oct 2020
    Location
    washington
    Posts
    126
    thank you... good info....good tips!!!

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

Similar Threads

  1. Replies: 21
    Last Post: 09-29-2017, 01:30 PM
  2. Replies: 6
    Last Post: 06-26-2015, 08:55 PM
  3. Replies: 17
    Last Post: 03-16-2014, 10:52 PM
  4. Replies: 3
    Last Post: 12-27-2013, 02:33 PM
  5. Replies: 1
    Last Post: 03-03-2012, 10:17 PM

Tags for this Thread

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