Search results

yeah problem was i dint know how the string should looked like since i never used sql be for and even now im still not sure lol, but yeah ill do this next time i going to use SQL at least i will see how it look like and it will help me learn how it should look like, thx for the tip Mark.

Thx to every one who spend time on this its really appreciated, if any one figure out why the DAO is buging out if the record is changed let me know, thx again :)

Look like that worked: CurrentDb.Execute "UPDATE Tbl_Facturation " & "set [Ec_ID] = (" & Me.Ec_Txtb_ID.Value & ") " & "where ID = " & Me.Ec_List_Facture.Value SQL have a really weird syntax... first time using it, well thx Cronk you gived me the last push i needed to figure this out :) i...

i had to remove the ; at the end to make it work CurrentDb.Execute "UPDATE Tbl_Facturation " & "set [Ec_ID] = 0 " & "where ID = " & Me.Ec_List_Ec_FactureLier.Value work fine and using sql actualy solved my problem! yay now im trying to make this to work: CurrentDb.Execute "UPDATE...

trying to use sql to replace the DAO function to see if i got the same issue but i cant find the right syntax i got: missing parameter, expecting 1 error on this line: CurrentDb.Execute "UPDATE Tbl_Facturation " & "set [Ec_ID] = 0 " & "where ID = Ec_List_Ec_FactureLier.Value;" some advice...

if you download the DB i uploaded you will have all the code i use, i dont get any error nothing happen when clicking the add or remove button after changing record. this is the add button code: Function AjoutFactureEc() Dim dbs As DAO.Database Dim rst As DAO.Recordset...

Ok the upper right list was broken it was not returning the right value, i deleted it and made a new one and now its returning the right value but the Add and Remove buton keep breaking at some point it not entering the function condition and not executing the loop. im still trying ti figure out...

hello guys, im working on a form that allow the user to attach a bill to bill list of a specific provider and for that i am using a DOA function to edit a value in the bill table when adding or removing it. it work fine if i open the form and add or remove on the actual record but if i change...

Yeah i have seen the ribbon setup but i don't really like it, my forms are all in popup mode and i hide the Access window so ppl see only what they need, i guess i will have to switch on c# in Visual studio so i can do what i want and not what i can lol hoo well thx ridders for taking the time...

Hello stuartam, I am looking to create a MenuBar for a form and the information on the web is very limited and vague, i was wondering if you still have the module you created, i was not sure how to put the code in this tread in module and form and if it was debug or not. im using access 2016...

Hmmm i am not sure if i should hide under my desk in shame :o or break my head on a wall :banghead: that was the most noob failure i did so far lol... and i copy past it for all section of the form and dint even notice it... i wonder why it dint break sooner tho. its all fixed now a huge thx...

Hi ridders thx for taking time to post here. You dint miss much they are almost the same the circled text on ThirdClick.jpg is darker. i removed the data in DB to upload it so you guys will get a better view of the problem. just open the form: Frm_Facturation click the list box and enjoy the...

Hi arnelgp thx for the reply, The funny thing is there is no code on click event i dint put any there yet, the only thing that list have is the macro in AftherUpdate event to get the selected record. I deleted the list and made a new one but it dose the same thing lol, it only do that when i...

Hey all! I am having a weird issue, when i click on my listbox items it make some text label of my form duplicating over it self every time i click on the listbox, it look like if i set the font weight darker and darker on every click and i had the same issue with button once too. The only way...

Hello! I am fairly new in Access but i have a good base in coding logic and i am learning fast. I got a new job and i need to rebuild their access software because its very messy and causing trouble so i may need a lot of your access wisdom and knowledge. thx in advance for your tips and...