I need help; this is wha i have
Dim action as String
...
...
action = "ADDED"
...
...
DoCmd.RunSQL "INSERT INTO MASTER_DIE_TABLE (M_DIENAME,M_COLORS,M_LENGTH,M_QUANTITY,M_LOCATION,M_ACTION,M_DATE) VALUES...
I have a little problem when I use this query.
What I am trying to do is pull out a list of records from a table:
A11
A12
A13
..
..
A19
..
..
A20
..
..
A121
A122
..
So when I write my query I say to give me whatever is between A11 to A18... and I was expecting A11,A12,A13...A18, but I am...
I am using a query to get the Count(*) from a table. On the Query I used Expr1:Count(*)
I am having problems when trying to used:
If Expr1 = 0 then.... The result of the query is 0 but when I used that statement in a Subrouting using VB and I trying to luse the If statment it seems like the...