Search results

To email something check out the SendObject Method. Something with (IMHO) more power and flexibility is the Collaborative Data Object for NT Servers - a mouthfull, but a Google search for the two words CDONTS newmail will find info about it. CDONTS requires that your IIS server be set up to...

Unless I'm missing something, your problem is pretty straight-forward. You'd want to code the "OnClick event of a "Print" command button something like this: If you require a from- and to-date, write If IsNull(Me.FromDate) Then Msgbox "Enter a From-Date for the report" DoCmd.GotoControl...

For the AfterUpdate event for the control that contains the query criterion, put in a line like Me.Requery Were it my form I'd probably put the query criterion on te main form (an unbounded control) and have the query results on a subform. In this case the requery would be more like...

See your "how to do this?" inquiry. Solution emailed a minute ago.

OK, OK - sending it to you by email.

I'll see if I can gin something up and email it to you. Is your email correct on this site?

I'd build a query that takes FirstName, LastName, and maybe MI and Company from the table, and adds a calculated field that results in LastName, FirstName MI. Use the calculated name field (and company if desired) as the recordsource for a combo box. If the AutoExpand property for the combo box...

Sigh - tis will take longer to explain than to do. An approach: Define a table "tblSpecialties" containing a row for each job, say "Gastroenterology", "Internal Medicine", "Psychiatry", etc. The field containing the job/specialty will be the record source for a combo box called cboSpecialty...

Here's something that might work: 1. Add a Yes/No-type field to the underlying table (call it "tblSample"), call it "Print" 2. When you open your form, reset this field in all the rows to No/False. Something like Docmd.Runsql "Update tblSample Set Print = False Where Print = True" might work...

Think I read this topic somewhere here about a week ago. The slickest reply I saw was to define a text box with a Solid (not Transparent) background in a "sympatico" background color. When you update the filename, adjust the text box's Width property to something like...