Recent content by Wildboy99

Here seems to have an answer: http://www.lebans.com/DownloadFiles/rownumber.zip I donwloaded it but can not open the file. Has any of you guys opened this file before?

I see your point, the problem is, how you you store the calculated rank order into table record? And I have tried several ways of calculating rank in query, been on it several days without success Serialize method, system respond " unrecognized function" Select(Count(*)............ All rank =...

Thanks for suggetions I have read through some threads about ranking in qury. I need to record rank into the table, because later I need to use the rank as criteria for tblPrize Apart for the top 3 prizes, there is also 7th, 17th, 27th................. and also a prize for placed second to...

Many thanks for your reply. I do have another table tblGamefield, that stores necessary game details, Relationship is as follows: One to many Name(one name in tblAddressBook) to Participants(many games in tblGames) GameField(one gamefield in tblGameField) to GameField(many gamefield in...

Hi Guys, I have been serching on topic about rank, but mostly are using queries, not exactly what I wish to do. Here is where I am at: Two tables, tblAddressBook and tblGameRecords. [Name] in tblAddressBook is (one to many) linked to [Participant] in tblGameRecord In a form: frmGameRecord...

Sorted! found an old thread that did exactly what I need https://www.access-programmers.co.uk/forums/threads/listbox-multiselect-append-selected-to-subform-datasheet.304242/ Thanks

Thank you very much for your information, it help me sorted out my problem.

Thanks for reply, Is there a sample of setting up the macro? Rather run apend query, can the items be added directly to subform2? (As there are colums in subform2 linked to the main form, which has to have values)

Hi Guys, I have been going throung old threads for days, trying to find answer for similar issue, but no luck. I am not capable of writing SQL/VB, but been using Access with built in functions, or do slight modification from the sample NorthWind. Here is my issue: I have two tables, tabel 1...

I am from Taiwan, been using Access for own record keeping from Office 97 until now. Lately trying to creat new data base with more complicated form work, and come across with some problems where I do not familiar with Visual Basic. Therefore I am here seeking for help, looking forward to...