I would like to create a list with sortable headers that the user can drag to group the data, much like Microsoft Outlook. Has anyone been able to emulate the grouping with a ListView, DataGrid, or other object?
I'm just jumping in here and may have missed out on getting a response, but I just have to ask. Does Access VBA not support a constructor method? I see that default properties are another issue altogether, whereas it looks as though the Forms(3) = Forms.Items(3) is more of a constructor issue...
I am trying to use the NodeClick event of the Treeview object through code to select either the first item in a tree or to refresh the contents of the parent node on which I'm currently working.
At the moment, the tree opens up with only the topmost items showing. Each time I click on the item...
To clarify, you want the user to select an option and click a button to show another form with more detail for the selected option?
Just trying to make sure I understand you before I start describing the wrong thing!
Ryan
Thanks, Duane. I actually ended up using a DLookup instead as I needed the report yesterday. It's slower, but it is working. It was showing up as more than 255 characters in the datasheet view, and there wasn't anything in the Format property.
Thanks for your help,
Ryan
For anyone who cares, you can also carbon copy another person with CopyTo:
'Using above code snippet...
'Set up the new mail document
Set MailDoc = Maildb.CREATEDOCUMENT
MailDoc.Form = "Memo"
MailDoc.sendto = Recipient
MailDoc.CopyTo = RecipientOther...
I have a report that I recently updated by adding a few additional fields, one of which needs more than 255 characters to display. I have checked my queries, and they are working fine. The other memo fields grow just fine. This new one, however, grows an additional row and stops at 255...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.