Recent content by Steve G

Thanks Gasman, but I'm just going to stay with the work around.

Out of frustration, I just reinserted the StaffID into the StaffListTable as a numbered field and problem went away.....not the best solution....but a solution nevertheless.

Hi Jdraw, where do I find V-Tools? The StaffID was a numbered field in the StaffListTable, but I removed it in this table and in all referenced forms, queries and VBA.

Thanks for the reply Ranman....but as I wrote, this StaffID appears to be hidden somewhere in the back end (tables database).

Hi guys, Whenever I open the front end of my database, I am now greeted with a Enter Paramater Value Error called "StaffListTable.StaffID" regardless of what Saved As version of front end I open. Therefore, it appears that the Paramater error lies somewhere in this StaffListTable (back end)...

Brilliant again....thanks Arnel https://accessworld-accessworld.netdna-ssl.com/forums/images/icons/icon14.gif

Hi June, Thanks for the reply. Each combo box has it's own imbedded query. The purpose of having a search box in the Main Menu Form is to enable users to quickly identify where participants' completed transactions are at....either in: - QA (form 1) - Assessment (form 2) - Completed (form 3)

Hi guys, I'm hoping some of you might be able to assist with this one: I have one Unbound combo box on Main Menu Form (Search box if you like). - User selects a participant from the combo box and a message box appears to advise the user in which form they will find the most recently completed...

HI Isladogs, yes it does - so thank you very much. Kudos to you also Arnel, because I inadvertently neglected to mention that the participants who were not yet allocated a property were actually being entered in the ParticipantListTable (feeding into the ParticipantTable). So, in essence, I...

Hi Arnel, my filtering kept producing duplicate participants. I adapted Isladogs suggestion to suit. Thanks for your assistance. I really appreciated your prompt response....:D

Absolute legend.....Thank you very much.....top of the pop charts for you isladogs :D

Hi Isladogs, I've been filting the same results as Arnel...I'll give your suggestion a crack....thanks mate!

Hi Arnelgp, thanks for the quick response. What does 1 & 3 and 2 mean? Sorry for my ignorance?

Hi guys, I've hit a bit of a "Pickle", so I'm hoping some boffins might be able to assist me? I am trying to use a query to filter my ParticipantTable to find relevant information. In my ParticipantTable I have the following fields of interest: 1. ID (Primary Key) 2. UniqueParticipantNumber...

Hi Gasman, that didn't work unfortunately. Don't worry anymore...I'll just let staff know that they will need to backspace the pre-approved text up to the first line.....Thanks mate, you've been really helpful....:)