Never mind, I think I have a workaround. My problem really was that I couldn't get the subform to expand from the datasheet. I added a field on the subform with just some garbage, but it seems to instantiate a new record and allow me to open up the subsubform. Thanks for your help! We'll see if this works.
In fact, I named the field 'Instantiate', set it to a byte, and just type '1' into it. Hilarious. And annoying. But if it works, who am...
esperance
Last Activity: Dec 5 '10, 09:34 PM
Joined: Jul 17 '10
Location:
-
-
Thanks for your replay Nico! I was able to add a sub-sub-form (which I didn't know you could do to a datasheet, but it looks beautiful).
Now this is the problem: to add a record to sbfrmLINKImageD oc the record has to already exist in tblDocs. What method would you suggest to add a new record?...Leave a comment:
-
In Access 2010, at least, you can go to File->Manage Users and Permissions, and it allows you to change all these things for every database object. What version of Access are you using?Leave a comment:
-
Why is order status your bound column?Leave a comment:
-
Does knowing the amount of stock each day matter? Because you could remove the date field, add a "new_stock" field, and use it to make a calculated field that gives a new total.
Also, POS means point of sale, right? Not piece of sh**? :DLeave a comment:
-
You could use a combobox, with it's RowSource based on a table containing the information/checkboxes you want to display. For example, I have 2 tables: tblPC and tblUsers.
tblPC: PCID*, ComputerName (txt), UserID (num)
tblUsers: UserID*, UserName (txt), Awesome? (yes/no)
tblPC and tblUsers are related 1:many by UserID.
frmPC has a combobox with it's RowSource set to tblUsers, and a Column Count of 3 (Column Size = 0,1,1)....Leave a comment:
-
Good call nico. Then the user, when adding the mistake, just selects the current period from a combobox or something rather than a tab.Leave a comment:
-
Facilitating data entry in a many-to-many relationship
I am trying to create forms to facilitate data entry in a many to many relationship. Using Access 2010.
I am currently working with three tables: a table of images, a table of documents, and a linking table between the two.
tblImages: ImageID* (autonum), URL (text)
tblDocs: DocID* (autonum), etc.
tblLINKImageDoc : ImageID* (num), DocID* (num)
frmImages contains a subform based on the linking table. What I want to...
No activity results to display
Leave a comment: