Recent content by khodr

Dear Awake, You statement doesn't look correct, in my example I will consider you have to combo boxes in a Form. combo 1 called : Results combo 2 called : VUS then Create another combo called : detected and paste the below statement into it, and things should work correct. =IIf([Results]="Not...

You can create forms and then add the forms to one form as sub forms where you link each form to other related form where every form will have one deatil and other form have many this is just a guess I haven't try it to see how it could work check it out

I will go through the LINK here is the attached file for the result of the sql it providing me a number

I didn't know what is the point break, and in which line it needs to be placed I inserted the "dbOpenDynaset" but still not working

JHB, thanks for taking the time to go through my Post, I tried your code but still its not updating anything in the tblProducts, the corrected code Private Sub PurchaseOrderNo_DblClick(Cancel As Integer) Dim rs As DAO.Recordset Dim dbData As Database Dim strSQL As String Set dbData = CurrentDb...

Hello Guys Using SQL with Double Clicking the PurchaseOrderNo I want to update my data in the tblProducts for the data into pQTYinStock I wrote the below code when I double click to run the Code everything seems to be OK, and no errors shows up, but my data is not updating enclosed find attached...

I tried my best to understand your question but if I understand you correctly I think in the required data table you need to add a field to save user name or user number and then you can create a query and call the user number or name and the required date and if there is data belongs to this...

PsyOr You are welcome any time mate

You are most welcome sa7ar feel free to post any question and this forum is full of experts and answers Happy New Year 2013

Sa7ar, I am stuck, I am trying to convert the database to an earlier version, but it won't, actually I used some controls and features which only works with Access 2010, you got to try this Open Microsoft Access 2007. Create a new Blank DataBase . Click OK. Goto External Data menu and the...

With DateDiff Function you can do lots of date and time calculations for the current task of yours Check this link I hope it's helpful for you http://allenbrowne.com/casu-13.html

Well it's a problem when we are sure about something it's not surely correct Happy new year for you too

Lol, that was really tricky, I haven't notice it, actually it made me crazy because I tried all Recordset Tutorials and it wasn't working, so that is why, anyway I am sorry guys for that, I will check it and see how it will go, thanks again.

Guys, attached is the table and the form, its very basic but actually I have no Knowledge about Coding recordset on Access I can get what I want by linking the table to the form and do search and get the data, but what I want is to Use the DAO recordset here. again help is appreciated.

thanks for the followup, find the attached file for error descriptions