Recent content by proe

I still have a screen pop asking me to enter the action value..! once I do it it does put it on my table but I do not want the user have to enter the value everytime he adds a record.! How could I just enter a the value on the SQL code. I think I am complicating myself "INSERT INTO...

Hi Chris, What I am suppose to acomplish withi this? Is this will allow me to move hte filed that I call action with the value ADDED into my table?!

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

OKay, I have just learned how to use the DCount.. How can I see what is the value on DCount? Dim CNT As Integer DoCmd.Echo True, "running" CNT = DCount("LOCATION", "DIE_TABLE", "[DIENAME]='" & Forms!DIE_FORM![die_name_in] & "'AND[COLORS]='" & Forms!DIE_FORM![colors_in] & "'AND [LENGTH]='" &...

Thanks, I try to change the name in my query to DCount and I got this in my error compile: "Argument not optional". I am not sure what to do with your second sugestion. let me put my code here: Private Sub Move_Click() With CodeContextObject DoCmd.Echo True, "running"...

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