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...

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...

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...

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...

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...