Search results

Yes brav, my mistake.It works.Thank you.you are legend

Yes, this is exactly what i want ,but this code is giving me error. So im sure there must be easiest way for the most of the things in the application ,but this is how i did it so far with my knowledge.no it education, no idea of programing

this is the db

Upload a stripped DB.. How to Upload a Stripped DB. To create a Sample DB (to be uploaded for other users to examine); please follow the steps.. 1. Create a backup of the file, before you proceed.. 2. Delete all Forms/Queries/Reports that are not in Question (except the ones that are...

wtf ive tryed everything :(((

the debuging its saying that it cant find the field.so there is the mistake in the code.its a subform in the form called "fourniturenerrorsub" and the field is in the subform called "code field".

not working :(

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 Mihail, at the moment im working on MO 2013 and its telling be that it cant save the DB as v 2003 becouse of the new feutures im my DB.Also with zip is over 2mb and i cant upload it here :(

thank u man, so becouse i had no idea of vba im doing exactly the same as this guide http://www.youtube.com/watch?v=Ri2Y9-16AEo so... 1.the form is "fourniturenform" and the code is for this form so... u see i have "add record" button.That what i want is the combination of "lila + code" to do...

I'll be thanksful if u help me.do i need to send u jyst the vba code or all the database

Okey, thanks, 1st way with indexing not posible for my situation, so can you help me with any other way with the VBA code, so when i hit the ADD button to return a message that the values alreadi exist in a1 and a2

already have primery key and this is B1, but my question have nothing with this

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

i've solve it.U were close.Its : "INSERT INTO tablename(a1, a2, a3, a4, " & _ ",a5, a6)"

now its running, but i want to double them and then its not running, becouse i cant have all the "insert into" fields in 1 line. But even now when its running ive tried many ways to carry over the "INSERT INTO" line to a 2nd line but i dont know how.Anyone who can do this?is it possible?

the code like this is WORKING...i just wanna make it bigger but i dont know how to carry over the line with "INSERT INTO" code...there is the problem ive already test it

Private Sub addrecord_Click() 'add data to table CurrentDb.Execute "INSERT INTO FourniturenSample (Lila, Code, LilaP1, CodeP1, ColorP1, quantityP1, LilaP2, CodeP2, ColorP2, quantityP2, LilaP3, CodeP3, ColorP3, quantityP3, LilaP4, CodeP4, ColorP4, quantityP4, LilaP5, CodeP5, ColorP5...

I've tryed this..still giving me syntax error :(

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?