Recent content by catcoota

Lynn_AccessUser Thanks a lot for the example, i got the idea Pat Hartman I've just seen the database, & i liked the idea but i couldn't apply it in my database i don't know why? I noticed that Order table in north wind is linked to Order details thru 1:M relation ship where both fields...

Hi I have a basic question related to database child-forms If I have 2 tables, one called tblorder (orderID, productID, date) and another one called tblproducts (productID, ProductName, Category) and they are linked throuh 1:M relationship (one order could have multiple products) I want...

Pat Hartman Hi, I really don't want to delete anything, I am doing all of this just to test how it works, and how to run sql code, coz I am a newbie in VBA and really want to learn it but I can't get it to work properly, BTW: the relationship & cascade delete features are set correctly...

Hello Actually ProductOrder is a query, I used this query coz my form is based on 2 tables. By the way, OrderID is AutoNumber Any suggestions?

namliam Thanks for the help, I added the DAO & it recognizes it now :) But, um facing another problem I made a test to see if it works or not, I made a form, which has a button, when I click on the button the following code run, so I see the record set where OrderID = 3...

Thanks namiliam 4 the note :) I have used WayneRyan way, but I am facing a problem When I write Dim dbs as Database , the (databae) word does not get coloured so that it doesn't look like to be recognized by the program! in addition to that when I run the program the debugger runs and tells...

Hello Thanks again, but I still can't get it to work! :( any suggestions? BTW: what is the method to change the text into a combo? Thanks

Hi mark curtis Thanks dear, I used your way, but it is not working, I opened the program, clicked Ctrl+P and then Ctrl+S and then Ctrl+N and then Alt+F4 but it is not working ghudson Thanks but ur way didn't work either, it shows me the Close Program windows that has the (Shutdown, Cancel...

Hey thanks very much WayneRyan I am just a newbie in Access VBA, but I am enjoying it I'll study ur codeand If I faced a problem, i might come back to ask u :rolleyes: By the way, do u recommend me to visit any sites that gives me some detailed lesson about VBA loops and other coding stuff in...

Hi Thanks very much for the reply Pat Harmnan I tried ur solution, but unfortunately I still can't solve the problem! maybe I didn't understand u well? Anyway, I did this I made a query called ProductOrder based on the 2 linked tables Orders & Products and then I went to a form bound to the...

Hi Actually um not sure of the answer coz i havn't tried it yet, but if you join the 2 tables using a query, and then make a form out of this query In the Create form Wizard, when u select the query, click next and then u will have select by wish table u want to be ordered and then u have to...

Nice information :) i didn't know how to read at all & now i got it. & i would also to know how to delete a record which has a specific value, for instance, I wanna delete a record where the primary key (ProductID = 10) , and what is the command which adds a new record. Thanks again 4 the help

Yah, exactly that's what i want to do :)

Thanks everyone for ur support But i still can't find a way to break the security :o

Hi how are u all? I have a subform which has multiple records, i wanna write code which reads the records one by one, in other wards, i need a loop & an array to read it, but i donno how to read (a record) using an array in Access. Anyhelp is highly appreciated