LordofTzeentch
New member
- Local time
- Today, 03:24
- Joined
- Nov 22, 2005
- Messages
- 5
Hi im pretty new to all this and need some help
Im creating a program for a wargame that i play that will create army list s for me. I have everything how i want it but Im having trouble figuring out how you get a value from a query into a variable the code i have atm is
Dim Point As Integer
DoCmd.OpenQuery "QryMagicPoints"
Point = "SELECT [QryMagicPoints].Points from QryMagicPoints"
According to websites that ive vistited this code should work but everytime i run it i get
Run Time error '13'
Type Mismatch any help would be appreciated
Im creating a program for a wargame that i play that will create army list s for me. I have everything how i want it but Im having trouble figuring out how you get a value from a query into a variable the code i have atm is
Dim Point As Integer
DoCmd.OpenQuery "QryMagicPoints"
Point = "SELECT [QryMagicPoints].Points from QryMagicPoints"
According to websites that ive vistited this code should work but everytime i run it i get
Run Time error '13'
Type Mismatch any help would be appreciated