Computer Learning Zone CLZ Access Excel Word Windows

It is a miracle that curiosity survives formal education.

-Albert Einstein
 
Home   Courses   Templates   Seminars   TechHelp   Forums   Help   Contact   Join   Order   Logon  
 
Home > Courses > Access > Templates > ABCD > Part 5 > < Part 4 | Part 6 >
Back to ABCD Core Part 5    Comments List
Upload Images   @Reply   Bookmark    Link   Email  
Syntax error
Dg Ewing 
      
3 years ago
I am using the "tab" and "isprimary" construct of the core 1 ABCD db and the 1st 2 "tabs" primary coding works, I copied it to the 3rd and 4th tabs/forms and it gives syntax error...
Dg Ewing OP  @Reply  
      
3 years ago

Alex Hedley  @Reply  
            
3 years ago
Appears MemMstrID doesn't exist on the Form
Can you see the SQL in the error says
' = AND
Dg Ewing OP  @Reply  
      
3 years ago


MemMstrID is a nonvisable field on all 4 forms.   the 4 forms all have two hidden fields: , memmstriid/URLID, memmstrid/emailID  memmstrid/phoneid, memmstrid/AddressID,  ....I literally copied the code from the first form URL to all the others and changed the urlid to emailid/phoneid/addressid .....the first 2 forms work....it is as if there are hidden characters.  I have moved all the code to one line, and added msgbox. and I am getting blank values for memmstrid and phone ....
Dg Ewing OP  @Reply  
      
3 years ago

Dg Ewing OP  @Reply  
      
3 years ago

Kevin Robertson  @Reply  
          
3 years ago
Is there a value in the memmstrid field in the Phone Table?
Dg Ewing OP  @Reply  
      
3 years ago

Dg Ewing OP  @Reply  
      
3 years ago
The two on the right work, the two on the left do not,  double double, and unseen characters?  spider crap ??? I do not understand the need for "  and I tried one line code, no errors but it did not work, I could add isprime for every record
Dg Ewing OP  @Reply  
      
3 years ago

Dg Ewing OP  @Reply  
      
3 years ago
table is populated
Dg Ewing OP  @Reply  
      
3 years ago

Dg Ewing OP  @Reply  
      
3 years ago
I deleted all the records in phone and added 3, when I tried to change primary from middle one to new one I got this
Dg Ewing OP  @Reply  
      
3 years ago
i have a msg box that wants to return MemMstrID and PhoneID,  it is only returning MemMstrID
Kevin Robertson  @Reply  
          
3 years ago
Try referring to the Combo Box Name instead of the ID.

msgbox memmstrid & " " & ComboBoxName
Dg Ewing OP  @Reply  
      
3 years ago
I just added me.refresh and tabbed first 3 lines and it gives me the abort, ignore or retry, and if I click ignore IT WORKS....WTF
Dg Ewing OP  @Reply  
      
3 years ago

Dg Ewing OP  @Reply  
      
3 years ago
Try referring to the Combo Box Name instead of the ID, why would it work on two of the 4 four forms not referring to combo?
Dg Ewing OP  @Reply  
      
3 years ago
All is working and I am believe/convinced I had two problems.  I need me. refresh for newly added records and :

I copied the following from the template into my code and the above SYNTAX error

DoCmd.RunSQL "UPDATE AddressT Set IsPrimary=FALSE WHERE MemMstrID=" & MemMstrID & _
        " AND addressID<>" & addressID

I copied it to note pad and the copied back and it worked--also when I copy from the template my "insertion" is turned off so when I type it types over the existing char until I turn "insert" back on (the key above delete on my keypad)...I am convinced that when I  copy , there are ascii control characters being inserting/translated (line feed, end of txt, backspace, or or...)

this is the 2nd time that I think this same problem happened, the first time I thought I was having trouble with double double,   This happens all the time coping txt from the web into a field.  


Richard Rost  @Reply  
          
3 years ago
If it happens again let me know exactly what you're doing so I can reconstruct the problem on my end - with the stock template, of course. If you'd made any changes to it, I can't promise they'll work. :)

This thread is now CLOSED. If you wish to comment, start a NEW discussion in ABCD Core Part 5.
 

 
 
 

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Login
My Account
My Courses
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
PCResale.NET
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

LinkedIn
Copyright 2025 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 5/17/2025 8:15:05 PM. PLT: 1s