Search results
-
B
Access VBA - Dynamically assign properties to variable with of custom type
Thank you for your answer. Yes, that is what I'm doing now: Select Case regionName Case "projectName" projectRegion.ProjectName = regionValue Case "projectNumber" projectRegion.ProjectNumber = regionValue Case "projectDescription"...- bandwagon
- Post #9
- Forum: Modules & VBA
-
B
Access VBA - Dynamically assign properties to variable with of custom type
Getting into my project details is too steep a challenge for me at the moment. And way beyond the scope of my question, which I'm sorry I cannot ask in a clear way. I appreciate your help but I think I'm just going to go to McDonald's and get some fries.- bandwagon
- Post #8
- Forum: Modules & VBA
-
B
Access VBA - Dynamically assign properties to variable with of custom type
Yes, I want to save them for subsequent use. I've edited the code above so it shows the global variable projectRegion. I could then update the database with something like... UPDATE tblProjects SET tblProjects.projectName = projectRegion.projectName WHERE ...- bandwagon
- Post #5
- Forum: Modules & VBA
-
B
Access VBA - Dynamically assign properties to variable with of custom type
In my very best plain English, I have created a custom type with several properties. I want to assign values to those properties via a loop.- bandwagon
- Post #3
- Forum: Modules & VBA
-
B
Access VBA - Dynamically assign properties to variable with of custom type
Hi Everyone, A transient, virtual hobo, with only enough skill to be highly dangerous. You all know the type, as evidenced here: The code I'm attaching, far below, does not work (shocker). It attempts to dynamically assign values to the properties? of my variable (of type ProjectRegions)...- bandwagon
- Thread
- Replies: 9
- Forum: Modules & VBA