Page 2 of 2 FirstFirst 12
Results 16 to 22 of 22
  1. #16
    Synergy.ron@gmail.com is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Oct 2020
    Location
    washington
    Posts
    42
    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
    Ajax is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    8,955
    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
    15,504

  4. #19
    Synergy.ron@gmail.com is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Oct 2020
    Location
    washington
    Posts
    42
    Click image for larger version. 

Name:	rserror.png 
Views:	18 
Size:	39.2 KB 
ID:	45040 thanks. Isee why you say I should reference rs.fields("serial"). But, even hat throws an error?

  5. #20
    Micron is online now Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    8,727
    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.
    - "doesn't work" doesn't help. Implement changes in copies of your database.
    Iím telling everyone it's good to eat dried grapes. Itís all about raisin awareness.

  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
    15,504
    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 Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Oct 2020
    Location
    washington
    Posts
    42
    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 - Senior Forums