Search results

Hello, I have a problem with comparing IDs using VBA, for example if i was using MySQL i can write If Mystring = "g????" then ...... Which means it will only look for all the IDs which start with g. HOw can i do this in VBA? Cheers

Hello, I am trying to design a database that would allocate projects to volunteers automatically. I am a Nervous programmer on Ms Access and VBA, so any help would be appreciated. Here is how i hope the system should be able to do, I have created all the necessary tables, queries and a form...

Hello, can someone help me with this code, I am having trouble making recordsets for it Private Sub Command0_Click() volstring = Null 'String to hold the volunteers that have been processed DoCmd.SetWarnings False 'Cretae a loop, we'll do our own exit condition later Do While 1 = 1 'If...

I am working on a system that would allocate the projects to volunteers. The volunteers choose 3 projects that interest them, Choice 1 being the highest priority and 3 the least. Each project should only be allocated to one volunteer and a volunteer should be allocated to the First choice unless...