I have 2 forms, question and answer. I want to make a single datasheet of them. But I don't want to allow duplicates, so how do I make that if the question name is already in use, it will put the answers to the same question?
Novice
Windows 7 64bit 
Access 2010 64bit
I have 2 forms, question and answer. I want to make a single datasheet of them. But I don't want to allow duplicates, so how do I make that if the question name is already in use, it will put the answers to the same question?
VIP
Windows XP Access 2010 32bit
Don't really understand what you want. How would there be duplicates? Need to know more about your data structure.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Novice
Windows 7 64bit Access 2010 64bit
Yeah sorry about that, I found a way to go around that problem. But now another question:Originally Posted by June7
Is it possible to hide the add new record in datasheet form? I want that it can be done only through code.
But only the new record row must be hidden. Allow additions doesnt work, since I can't type in the form afterwards.
--------
Windows 7 64bit Access 2010 32bit
AllowAdditions should not affect typing in the form. AllowEdits would affect that. Setting AllowAdditions to NO is what you should do.
VIP
Windows XP Access 2010 32bit
Setting the form's Allow Additions to No should still allow edits to existing records but not show the New record row.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Posting Permissions
Reply With Quote