Search results

Smacks Head with Hand! :eek: Sigh.. Sometimes you just try to get TOO tricky and it works against you! My solution was relatively easy. 1. Create an Auto number for a Primary key to make the one-many relationship work correctly. 2. Create the subform with the many table and use a combobox...

Hmm.. It works fine on my PC with XP and Access 2003 Did you make sure that you had your references checked? http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='ExportAccessToExcelAsPivotTable.mdb' He states you need these to work it. References: (a) Microsoft...

Thanks Tim for replying. For your question, it is the latter. The information is being stored correctly in the table. But I think that for the code: I will have to make an on current event on the form to check and see if there are any values in the many table that match the keys. If there...

Ok, I have read many posts on multi-select list boxes and thought that the correct way to handle things is a one-many table. So here is my problem. I have a table that is populated by a listbox. The multi-selections go into the many table correctly. But if I change records, and come back...

Check out this page for a solution. http://www.rogersaccesslibrary.com/OtherLibraries.asp TejPal has excel exporting from Access, including multi-select list boxes to excel.