Computer Learning Zone CLZ Access Excel Word Windows

We all have a thirst for wonder. It's a deeply human quality... There's wonder and awe enough in the real world. Nature's a lot better at inventing wonders than we are.

-Carl Sagan
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
Syntax error Upload Images   Link   Email  
Dg Ewing 
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

Alex Hedley
Appears MemMstrID doesn't exist on the Form
Can you see the SQL in the error says
' = AND
Dg Ewing

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 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

Dg Ewing

Kevin Robertson
Is there a value in the memmstrid field in the Phone Table?
Dg Ewing

Dg Ewing
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

Dg Ewing
table is populated
Dg Ewing

Dg Ewing
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
i have a msg box that wants to return MemMstrID and PhoneID,  it is only returning MemMstrID
Kevin Robertson
Try referring to the Combo Box Name instead of the ID.

msgbox memmstrid & " " & ComboBoxName
Dg Ewing
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

Dg Ewing
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
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
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.

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

Copyright 2024 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 2/27/2024 5:32:20 AM. PLT: 0s