Recent content by looneytunes

I have a form which is opened from the DoubleClick event of another form. when I view the code for this form, it has the following pieces of code: Private Sub ToggleLink_Click() Private Sub FilterChildForm() Private Sub OpenChildForm() Private Function ChildFormIsOpen() Private Sub...

i would greatly appreciate a reply. if u need more info. pls let me know. thank you

thanks for your reply. i have put both pieces of code into the OnLoad event (i hope this is what you meant) but it still shows the message box before opening the form. here is the code: --------------------------------------- Private Sub Form_Load() DoCmd.GoToRecord , , acNewRec Select Case...

hi, i have a form, which when opened, gives me a blank record. which is what i asked it to do in the OnOpen property. however, i also need a msg box to popup - but after the form has been opened. i tried placing both pieces of 'code' into the OnOpen property, however, the popup displays first...

hi modest i greatly appreciate your reply and the time it must have taken. thank you. i always like to know what i'm doing when using code - and your explanations do help a lot. thank you :D

hi, I was using the KnowledgeBase on the Microsoft website, and found a way to have a table have picture path names, rather than having to store each picture in the dbase. I was told I need to use a Module and call it Module1. I would be extremely grateful if someone could let me know what it...

sorry if this has come up before. I have a dbase and have a query which calculates the "final price". a form is based on this query. i have another query, and i need it to lookup the "final price" field and display it on this query. i hope it makes sense would be grateful for any help, thanks

i got it. i had to rightclick on the toolbar at the top, customize, then drag and drop things like startup onto the toolbar. thanks

hi, i have set startup options for my dbase by going into Tools then Startup. I changed it so it doesnt show the tables etc, and shows only a form. i have also set a password on it. i know the way to edit a dbase with startup options is to hold down the shift key and then open it. however, i...

thanks Pat and Chilen007 i think i'm getting there now. if i have probs, i'll let u know! :D Cheers

thanks for ur reply. however,my dbase is fairly big to upload, nearly 9MB. i have tried the cascade delete option. i even applied it to all my relationships! i cant get it to work. is there any other way? or can anyone hazard a guess as to what i am doing wrong? at the moment, i am going to the...

hi thanks very much it works great. but one problem. i want it to delete details of the car, customer and invoice. at the moment it will only delete invoice. if i try and include other fields from cars and cust. tables, it says "specify the table containing the records you want to delete" i...

thanks for all the replies. greatly appreciate it. after thinking about it more, i will need to keep the invoices as mentioned above. however, is there a way to delete invoices after 3 years automatically? i greatly appreciate ur help. thank you

i have 3 linked tables. (invoice, customer, cars) i have a form showing details from all three tables. i want to be able to press a delete button whereby the records in all three table will be deleted. i have managed to do it for one table - however, it doesnt delete the records in other...

hi - unless i'm missing something, Tools - Customize - (in the categories) PivotTable/PivotChart... then drap and drop anything u need onto the top toolbar