Search results

I have to pass this value, declared as Variant, from one module (form) to another module (another form). But this variable is not one of the objects of any query, table or forms. It's a variable being calculated in a module. Now how can I pass this value to a different module? Here's the...

Thanks JGC31 for replying. What do you think I should do then? I tried replacing the query name with the original table name, but same result. And as opposed to no e-mails, it actually shows all the e-mails, that means the filter is not being applied. However, the filter IS being applied to...

Happy New Year to ALL! I am trying to e-mail from a form that displays filtered result, but having trouble. Could someone please guide me? I am using DoCmd.SendObject (a routine that I found in a newsgroup). This routine works fine when I am sending it to all the recipients, but not to...

Thank LenB. But I am not quite sure I know how to do that. I can create a combo box for the organizatons, but why combo box for Area? If you could please be more specific and give me detailed instructions, I would appreciate that. Thanks again.

Hi there, I am not sure how this can be done and so I am at the mercy of all you gurus. Here is he situation: I have 3 tables, tblPpl, tblOrg, tblMem. tblPpl - ContactID primary key tblOrg - OrgID primary key tblMem - ContactID & OrgID primary key tblPpl has one-to-many relation with tblMem...

This is how I did it: Me.SubFrmOrg.Enabled = Not (IsNull(FirstName)) Thanks guys.

Thank you both, again. Trucktime - I did replace the name of my subform with yoursubformname. It's working fine now. Thank you! I found out what I was doing wrong (too silly to mention here) :o

Thanks Trucktime & quest4 both for replying to my post. Trucktime - I followed your approach and it's working partially, it does make the subform invisible but it doesn't appear as soon as the first field is filled in. Actually it doesn't appear at all. I did put Me.yoursubformname.Enabled =...

Hello there, I have a form that has a subform (2 actually, tabbed). I have a many to many relationship estabslished, and the data on the subform is taken from the relationship table/query. It's working fine. When adding a new record, if the user accidentally enters something in the subform...

Yes yes.. it worked. Thank you so much Andy. I missed that Popup thing. Couldn't find any code in onOpen event though. Thanks.

Thank you SpacePro. I downloaded the example, and you are right, your msgbox is exactly what I am looking for, unfortunately it's not happening in my case. I compared the properties of the two forms, they are identical, yet yours doesn't maximize but mine does. What am I doing wrong? I...

Thanks guys! I tried creating my own form, trying make it look like a msg box, but it's not the same. For instance, when other reports are maximized, this little dialogue box will become maximized too. Any other thoughts? I am using Access 97. Thank you all

Hi All, This is what I'm trying to accomplish. I have a form, and a user can print a report by pressing a "print button" from that form. I would like to give them an option when they press the "print" button by using a MsgBox. Instead of using vbYesNo or VbOkCancel I would like the two buttons...

Hi there, I have a QBF, and when user inputs the search criteria and clicks on print button, a report prints out based on that search criteria. I would like that report to include the search criteria as well. How can I do that? I am not so good in Access, so please be as much specific as one...

I have a form with a subform in it and I would like to print the contents of that form to a report. I am able to print now, using a "print" command button, but it only prints one record, just the one that is being displayed. I want to be able to print a report with all the records that are in...