Search results

In my opinion you should not print or email forms you should use reports. If you want to e-mail a report which show the data from the current record then have a look at my sample posted >>Here<< it will e-mail the current record

Have a look <<Here>> this will show you how to refer to subforms and their controls etc.

Glad you liked it, hope you got it working for your db.

Have a look at my attached sample (the report mainly), it's not very fancy but I think you will be able to use it to solve your problem.

Have a look at my sample posted Here, it will show you how to code a button to print or preview the current record. If you have any further questions post back.

Put the following code in OnClick event of the control on the subform. I have called it txtDateOut. You have the its label as Date, The name of the control should NOT be named Date ... it is a reserved word in Access.

Have a look at your attached database. The form frmCardsNEW will demonstrate how the combo boxes (Category and Location) should work on a form. You will see that the table CardsNEW only holds the ID number of the record. Now if you open the query QryViewData you will see that locaiton and...

I'm not upset; I just didn’t know whose code it was. When you posted your sample I saw that it was your code I had used so I posted back and acknowledged your work. No

Dave, In my post above I said now I know who to credit.

Have a look at the attached sample. The code is NOT mine.

Here is your db back, what I hope you wanted was a combo in the header to find the record. I also fixed the TypeID in the second sub form.

Have a look at your db now. Sorry I did not see the other replies before I posted, I have added the "DoCmd.RunCommand acCmdSaveRecord" as well. Also I have disabled the controls in the subform when the Main form Primary key is Null. Also after you add or change data in the form...

Use the Wizard. Using the wizard put a command button on your "First" form and then from the list select: 1> Form Operation /Open Form (NEXT) 2> Select Name of form you wish to open.(NEXT) 3> Select first option ( Open the form and find specific data to display) (NEXT) 4> Select what you want...

Why to you have 3 tables and not 1? Make 3 reports 1 for each size of envelope , select the envelope size from the File/Page Setup / Page. When you have 1 & 2 sorted out post back and I will post and example for you. I use access to address all my envelopes also to create and print labels.

I think you should read the attached document, it may help you. It came from <<Here>>

Did you also get this one to work? http://www.access-programmers.co.uk/forums/showthread.php?t=119893

You can put a combo box in the header of the form that will GoTo the record selected. To do this use the Wizard, you will see the 3rd option, use that.

I have just answered you in another thread. How many time do you want to ask the same or similar question? Any way to answer this question. What is the Control source for the combo, I would suggest that you do not have one. When you close the form there is nothing in the data source so when...

Have a look at the sample I posted here. it is the first one and it is called Fill in controls on subform.zip

Have a look at the attached sample. I have sent you the 2000 version if you require 97 post back.