Search results

Excellent! Thank you :D

I am having a similar problem...I have tried Pat's solution to no avail but I could be just not understanding... my problem is I have a query based on many sub queries but if any of the subqueries has no records the final query is blank. The condition is not that one field is null and another...

You might also want to create a separate table for doctor sites with the addresses there instead of in the doctor table IF you need to keep track of more than one location OR if you need to keep a history when a doctor relocates. Use DoctorID to link. Doctor Table DoctorID DrLastName etc...

Thanks Pat! I put the code in the AfterUpdate Event and it seems to be working fine. Once again, I learn an important lesson from you. Thanks

Kind of a lame title for the thread but I'm feeling kind of lame..... :o I have a form with subforms. One of the subforms gets populated with a set of records that are questions for a survey. I have the main form's date field's AfterUpdate event coded to add the records but if you modify the...

Thanks Rich. I don't need to print it at all or even need a report at this point. It was just for design purposes that I wanted to print it. Having said that, do you think it's ok to continue with this db and not worry about corruption? Or would you suggest recreating the form or any other...

I am asking those interested to re-address this thread. I did not want to start a new one because I have noticed that is frowned upon however, wasn't sure how to get it started again. I edited the original thread: please review and respond if you can. Thanks :)

MS Access Closes in print preview: Revisited I tried the solution of : new db, import all objects, however, for the one form referred to below, it still causes Access to close. Could it just be that the form has so many graphics that it can't handle the print job? I don't care whether I ever...

Got it...Me.frmsSanswer.requery....thanks again! :D

Thanks Rich> I tried Forms!frmSanswers.Requery but I get an error msg that states "Microsft Access can't find the form referred to...." ideas?

I have a command button on a main form that runs an append query that populates a subform. When I click the command button the form remains blank and I know it needs to be requeried however can't find where to put the requery code. I added "SendKeys "{F9}", True" to the command button...

All right! I was thinking you were referring to the Data Entry property. Much thanks that was driving me nuts!

Thanks for the reply but that doesn't do it.

Is the cursor in the field you are searching? I know this is basic but I sure have made simple mistakes my own self!! :D

Check this thread link: http://www.access-programmers.co.uk/forums/showthread.php?t=68927&highlight=opens+blank+form not sure how else to copy a link. If there are no records in the forms record source the form will be blank.

I have a main form with sub forms on tab controls. The subforms are set to Continuous Forms. Each subform has a different number of records that appear and each record is just one line, but all of them, at the bottom, show a new blank record. If the user tabs to that new record and enters an...

thanks Keith that did it!

I have a main form with a date field I want to be filled in before the user proceeds. I have searched the forum and found the following code which I have implemented however, no matter where I placed it it just keeps on allowing the cursor to move to the next field on the subform and allows...

Thanks Newman, I like it!!!! :D The "divide by zero" problem can't happen in this instance.

Many thanks to those who continue to make my job more easier and help me learn new programming skills!!! :D I have a totals query that has calculated field which does not work if one of the fields it is based on is null. I created a work around (see below). My question is: is this a good...