Search results

it worked. thank you

strINSQRY = "INSERT INTO {Ferramentas_Obras_Stock} ( {IDFerramenta,IDObra, IDMOVFerra, IDMovimento} ) VALUES ( {'1', '1', '1','1'} ) ;" CurrentDb.Execute strINSQRY, dbFailOnError

Now gives a run-time error 3134 syntax error in INSERT INTO statement

Hi, thanks. How can insert numeric and text fields because in the all table i have these 2 type?

hi, i put this code: INSERT INTO Ferramentas_Obras_Stock (IDFerramenta,IDObra, IDMOVFerra, IDMovimento) VALUES (1, '1', '1','1') but gives a compile error in Ferramentas_Obras_Stock

The variables are defined in a global module as public

Dear Arnelgp: Thank you for help. I want to open that form to create 2 records in the Ferramentas Obras Stock tabel. 1 record of entry or out in the warehouse (an IDOBra) of the tools quantity, and 1 record of entrey or out in the work place (other IDObra). I dont know to update the table...

I have this database to control the spares in several places(Obras), in the movimentos 2 form we introduce if is a out (saida) or entry (Entrada), we put the place (Obra), for that movement we have several ferramentas (tools), we put the tool (ferramenta), the quantity. After i want to update...

hi: What is happening now is that i stored some value in variables but when it pass the until instruction they become empty: Private Sub Command25_Click() Dim tipomov As String Dim UltimoIMOVFerra As Long Dim Obra As Long Dim Armazem As Long Dim Data As Date Dim IDMOV As Long Dim IDObra As Long...

I put Me.[Movimentos e Ferramenta].Form.Recordset.MoveNext it pass that part without error but gives a new error in this expression: Forms![Movimentos]![Movimentos e Ferramentas].Form![Stock] = Forms![Movimentos]![Movimentos e Ferramentas].Form![Stock] - Forms![Movimentos]![Movimentos e...

Hi, i put the buttom in the main form and the code is: DoCmd.GoToRecord , "Movimentos e ferramentas", acNext

I have a main form "Movimentos" and a subform "Movimentos e Ferramenta", I want to set focus in the subform, see the values of each record (use acnext) and in the end add a new record. I tried several expressions but gives always error. can someone help? Thank you.