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...
Appears MemMstrID doesn't exist on the Form
Can you see the SQL in the error says
' = AND
Dg EwingOP
@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 EwingOP
@Reply 3 years ago
Dg EwingOP
@Reply 3 years ago
Kevin Robertson
@Reply 3 years ago
Is there a value in the memmstrid field in the Phone Table?
Dg EwingOP
@Reply 3 years ago
Dg EwingOP
@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 EwingOP
@Reply 3 years ago
Dg EwingOP
@Reply 3 years ago
table is populated
Dg EwingOP
@Reply 3 years ago
Dg EwingOP
@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 EwingOP
@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 EwingOP
@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 EwingOP
@Reply 3 years ago
Dg EwingOP
@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 EwingOP
@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.
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. :)
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
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.