Recent content by whoisit

Thank you very much Looks very complicated really appreicate thisso for example i say i want to create three DVDs using the titleId 01045 Will it automatically create these copies with date purchased as today's date and copyId in the form of D01045A, D01045B, D01045C etc. THANK YOU again really...

Urgent, can anyone please help THANK YOU

Thanks a lot i was struggling on this bit for some time THANK YOU

I placed this code in the before event property for most of my forms. Before i close the form this code prompts whether you wish to save the new record. Private Sub Form_BeforeUpdate(Cancel As Integer) Dim Msg, Style, Title, MyString, Response If Not Confirm Then Beep Msg = "Do you wish to...

Thanks a lot spacepro it was actually the second code i wanted but now that i've seen the first one i may consider it Now how do i make a macro execute the module Any solutions please THANK YOU

trucktime Thanks a lot after all these attempt i have finally got it to work Thanks for the all the help and the number of replies you made THANK YOU

sorry trucktime but i have another problem As shown in my attachment everytime i open the form this message is shown Please Help, really appreciate all the previous help THANK YOU

I would like to create a module which will run a delete query and when the query is run i would like to show the message "Are you sure you would like to delete this record" and options Yes/No This module will then be put on a macro so when i click on the button "OK" the module will be run Any...

Trucktime, sorry but the code is not working Thanks for the help below are screenshots of my form and subform and if you could give it another try it would be really appreciated What happens is you type in the memberId and the moneyOwed automatically appears which is done by the code...

Thanks trucktime I did replace code with the name of my subform What i forgot to mention was that the field MoneyOwed is on the subform and not main form. When i enter the memberId on the main form, the subform then displays the money owed. May be that why the code did not work. If the money...

Thanks for the reply best suggestion i have had from anyone so thank you FoFa but the problem is i am a complete beginner at VB so i have no idea where to start Any extra copies they want to add will be done manually by typing in the copyId and other fields manually Further help would be...

Any ideas Please Help THANK YOU

Trucktime the code you gave me does not work, when i type in the name of my subform "frmAddNewLoanSub", it says that it cannot find the field "frmAddNewLoanSub". Any suggestions THANK YOU

With my macro how do i get it to open my mail merge document and then automatically print it out If it cannot be done with a macro then VB would be fine THANK YOU

i am currently working on a video rental database How do i make sure that no member who owes money makes a loan Below are the fields in my 2 tables. A loan is made through the form "frmAddNewLoan". The two table are related via the field MemberId. The field MoneyOwed is a currency field, not a...