Search results for query: *

Thanks, it works. Life can be so easy...

Hi Ken, I didn't know that it's possible to set individual columns to be locked. Can you please tell me how to do this? I've never worked with Datasheet forms before... Recordset Type is set to updateable snapshot but I don't know how to set a specific column read-only. Thanks in advance

Hi Ken, thanks for your reply. The listbox is populated by a query and can have thousends of rows and up to ten columns. So a combobox is unsuitable. I also thought about using a textbox beside the listbox to enter the values, but in this case I would need as many textboxes as the number of...

Hi all, does anyone out there know if it is possible to implement an editable listbox in Access? I have a multi-column listbox and one column's values should be editable for the user at runtime. A simple datasheet (sub)form wouldn't fit my needs, that's why I'm thinking about such horrible...

Thanks scriverb, your tip with DLookup was very helpful for me, too. thanks again :-)

Thank you for your hint. it helped me a lot :)

Hi there, I am using a MSDE database with an Access Project (*.adp) as frontend. The database runs on various computers so that I have to change the connection properties in the File/Connection menu in Access. But I need to make this change in VBA code defining connections I need, too. How can...

Hi there, I am using a MSDE database with an Access Project (*.adp) as frontend. The database runs on various computers so that I have to change the connection properties in the File/Connection menu in Access. But I need to make this change in VBA code defining connections I need, too. How can...