Search results

In the control source property of the textbox that will display the total price =DLookup("[UnitPrice]", "ProductList", "[ProductID] = " & me!cboProduct) * me!txtQuantity BTW, direct from Access help on DLookup Function: You can also use the DLookup function in an expression in a calculated...

In the Macro, within the OpenReport command, is the report you are trying to open listed in the dropdown? Did you do a repair and compact on the new db?

Are you really in St. Paul? :) Yep, I love livin' and workin' in this "sleepy" little town.

My suggestion as this point would be to create a new database in Acc97, then import all of the objects from the corrupt database. You need to make sure your relationships are imported also. Then do a repair and compact on the new db. Hope this helps!

http://www.microsoft.com/downloads/release.asp?ReleaseID=12878&area=search&ordinal=1

Create a new module, name it "modSendAttachments" insert the following code Public Sub SendMessage(DisplayMsg As Boolean, strObjectName As String) Dim objOutlook As Outlook.Application Dim objOutlookMsg As Outlook.MailItem Dim objOutlookRecip As Outlook.Recipient...

Try: txtList.value = txtList.Value & ", " & lstOptions.value This will separate the entries with a comma, if you don't want the comma, use txtList.value = txtList.Value & " " & lstOptions.value

Is your combobox on the master form or subform?

How does your subform relate to your master form. Like if your master form displays customer information, your subform might display all orders for that customer. What is your relationship?

Open the subform in design view, then open the datasource query. Delete any criteria referring the Master form. Like maybe you have as a criteria =Forms![MasterForm]![ID]. Do this for all subforms. Then open the master form in design view. Click on each of the subforms and then show the...

Check the other workstations for missing references. Open the module and select Tools then References. Are any of the checked references preceded by MISSING: ?

Post the code you have so far.

Don't hard code the relationship to the master form in the query for the subform. Create the relationship with the Master/Child properties of the subform.

If you are using Access XP, you can simply link the address book as a table. Choose link table then select Outlook from the "Files of Type" dropdown. I know you can't do this in Access97, but I'm not sure about Access2000.

I've never been able to use SendObject to send more than one attachment. You have two choices. The first choice is to export the report as snapshot and rtf formats to create temporary files. Then create an outlook object that would attach the two files that you just created. Or, you can use...

You can create a command button that will allow the user to select a file name and store the location of the file in a table that associated the file with a patient. Is this what you are looking for?

Do you have a field on your form named txtEmailAddress that contains an email address for the recipient?

I sent you a pm. Doesn't matter, email it to me at cgaborik@christensenfarms.com

Try placing a breakpoint on the first line of code and step through to get a better idea of when the code stops sending emails. Since you have an On Error Resume Next statement as an error handler (bad idea, in my opinion) you may be skipping records that you think the emails are fine, but maybe...

;) Brilliant minds think alike!