Search results

Hi guys, i would like to hide/show button depend on is there anything in a fielld.My current code is not working at the moment so pls help me where is the mistake: Private Sub Form_Load() If Form![fourniturenErrorsub]![Code Field] <> Null Then errorbtn.Visible = True Else errorbtn.Visible =...

Hey Guys, I have a form where im fillind data into boxes and then i have "add record" button which is sending the data to a table.The code is like this: Private Sub addrecord_Click() CurrentDb.Execute "INSERT INTO tablename(a1,a2,a3,a4,a5,a6)" & _ "VALUES('" & b1 & "','" & b2 & "','" & b3 &...

Hey guys, Im using "INSERT INTO tablename(a1,a2)" function but i have to many "a" objecjts. How to carry over to a new line without having error?

Run time error 3061. Too few parameters. Expected 2 this what i got from this: Private Sub Command498_Click() CurrentDb.Execute "INSERT INTO FourniturenSample(Lila, Code, LilaP1, CodeP1, ColorP1, QuantityP1) " & _ "VALUES(" & Me.txtlila & "," & Me.txtlilacode & "," & Me.txtlilapart1 & "," &...

Hi guys, i have a problem and i can't find a solution so far.So, i have a form, where im giving a criteria for a query through combo-box.I want a button that will save the results from the query in a new table, after i choose the value in the combo box.I know that cloud happend with make-table...

Hi everyone, I'm new into doing queries for MS Access and I don't have an idea how to program the following issue. So for example I have quantity of products into column A.They are sorted good, but i need to give automatic number (into column B) per every product, depend on the sorting as...