Recent content by ocp&mcsd

Guys, Please, I need your help..

Hello mr. datAdrenaline, when filling the form of two fields, another form will open with the same number of feilds filled along with other field to be edited.

Guys, I need your urgent help...

Thank u Mr. datAdrenaline I want to have them in another form with other feilds to be edited. But, how to do it?

Hello, How r u? I have a small problem. I have a form with 2 text field, and one button. Text one is cheque start number. Text two is number of cheques. For example, if cheque number was to start from 3, and, number of cheques was 5, I want when clicking the button to insert into the table...

Thanks alot my dear....

OK Mr. Ken , I am waiting

Do you mean something like this: if me.ID = DLookup(''[CheckID]", "[Checks]") then insert.... else msgbox... ??

Hi all, How r u? I have a form with textboxes and a button. Under this button I have a code to insert the date from the textboxex to a table. One of these textboxes is an ID. I want the code to check whther the ID exist in that table, and if yes to insert it. This ID is not a primary key...

I want something like: CinemaID , MovieName , Rate 1 , Titanic , 40 1 , Rocky , 30 1 , Cars , 20 1 , Others , 10 2 , Toy Story , 50 2 , The Godfather , 30 2 , Finding Nemo, 15 2 , Others , 5 Like that.... I need your help my dear

I want to do what you have done for me before (See the above replies), but I want to show the same but by Cinema ID.

I want to do what you have done for me before (See the above replies), but I want to show the same but by Cinema ID.

Dear Mr. Rabbie, How are you? I need your help. If I want to order by CinemaID from Theatre table, how can I do it? Sorry for disturbing my dear. Kindly find attached copy of the db.

Thanks alot my dear.

Hi all, How are you? I have two tables, Groups and Members. Each Group has members. I want a query to return the oldest in each group, as: MemberName; GroupID ; Age Jane ; 1 ; 52 John ; 2 ; 51 How can I do that. Kindly, find attached the DB.