Recent content by NT100

Thank you for the suggestions. Let me try a temporary table for new records and a follow up operations to put those records into an actual table. Thank you.

I have no idea of doing the new records in the subform and then save it for the selected Octopus card. I have built an applications. I need to enter expense transactions into a subform (datasheet style) of frmExpense. I prefer to write scripts to save the the new records in subform of...

Have any samples to do the key and the addition of records?

Hi, I've a main form in which a listbox is created for the keys of electronic payment cards (e.g. Unique key: 1, 2, 3....). Once the particular key (e.g 2) is selected from the listbox. I expect that a subform is available for adding new transactions for that key (e.g. 2). Since subform can...

Thank you for your concern. I want to put all in scripts to have a better management and maintenance instead of looking each control and inspect its properties. This could be a tedious work and prone to error. Best.

Thank you, theDBguy. It works with the properties setting for Multiselect. However, when I coded it as "Forms("frmTutor").Controls("lstPQual").MultiSelect = 1", it ran into the error code of 2448 again. How come?

Thank you the suggestion. However, I set it as Forms("frmTutor").Controls("lstPQual").MultiSelect = 2 ' Extended. It runs into error of Run-time error '2448' You can't assign a value to this object. I read the nets and found and got the information that this is MS ACCESS' bug. Pls...

Tried but no response at all. Do I need to write a script for it? what will you suggest? Best.

I changed to use listbox for populating a recordset. For example, there're 3 items highlighted in black. When I deselect one item in the populated listbox, the background color doesn't disappear, how can I turn the background color to white to indicate to the user that he/she has deselected it?

I'm sorry that my question is not unclear. The details are listed below I have two tables; tblPQual has record(s) of tutors' post qualifications tblPQual (ID, AutoNumber; TRef, unique key of tblTutor; S_Code, Code of the Post Qualification and is foreigner key of tblSpecialty) e.g. TRef...

Only one combo box is used. A recordset of all qualifications populates the combo box. I need to highlight/mark the items in that combo box with another recordset of tutor with his/her qualifications.

I managed to pop a combo box with all qualifications a tutor may have by a recordset. I also need to pop that combo box with the qualifications a particular tutor has. I have no idea on this structure. I would appreciate if you have any idea.

Thank you for the advice. This is my first time to use combo box in vba. I did it now.

I've a list box of tutor and combo box in a form. The combo box is populated the qualifications by using DAO recordset in vba. When I click a list box, I want a particular tutor's qualification is highlighted/marked in that combo box and that selected qualification in the combo box scrolls up...

Yes, it works fine after the omission of "[TPCode]=" & iTPCode" in the query. I overtook my query. For the date comparison, it seems that I only focused on the syntax without looking into the detail limitations of "Between" usage. Thank you very much.