Recent content by mambo21

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...

Hey, I have decided to change the code because i thought that was the long method of doing it. Here is what I need to do. 1.Run the qryImport1 to import all the first choices to tblTemp_choices(Volunt_Id, Project_Id) 2.Take Volunt_Id and Project_Id from the first volunteer 3. Check if the...

On the form when I click the button it should do the allocation but it bring the error saying that User_defined type not defined I thought the error was due to recordsets, I think the code is right and should work but I can not get my finger around it Any help would be appreciated cheers

The code is for allocating students according to their project choices. As if first choice is taken the volunteer is allocated to second choice and if second choice is taken they are allocated to third choice. That is the code I wrote and I will attach the database that goes with it. cheers

thanks for the code, it was really helpful. I was wondering since it does not work because it doesn't have recordsets. how can i make recordsets for it? Here is the code with new changes Private Sub Command0_Click() volstring = Null 'String to hold the volunteers that have been processed...

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...

If all 3 choices have been allocated the project could be allocated to more than one volunteer. I have tried to use different quiries to see if It can be done this way but no luck so far. I am also trying to do it by VB but no luck with it as well because I have never used Vb before. Any help...

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...