Search results

Try creating a cross tab query from the current datasource and setting it as the datasource for a new report.

Could you post the structures of both tables? Where do you store the StudentID and the Date they are actually accredited?

If you are planning to use an Exchange Server, you can link an Exchange object (Calendar) into the database. Changes can then be made through Outlook or the database. Just select Exchange as the type of file to link.

I haven't done much with security, but it seems to me that you would need to split the db. Converting the front end db to an mde will prevent users from importing/exporting the forms, reports, and modules. Then I would password protect the backend db.

Select distinct Table1ID from Table2 where Table1ID not in (Select Table1ID from Table1) In other words, Select the Distinct ForeignKey from the Many table that doesn't exist as a PrimaryKey in the One table.

In the datasource property for the totals textbox.

What you need to do is create the text message in code by referring to the textbox controls on the form. I'm going to guess at the fields, so you'll need to replace the code with your field names. Like this Dim strEmailTo as string Dim strSubject as string Dim strText as string...

Is it possible that the app is waiting for input from the user? Like the output type, and filename? and the the first parameter should be acOutputReport, not acReport

GREAT!! Glad it worked for you. ~Charity

I just really enjoy helping people learn. I'm glad you were able to figure it out! Let me know if you need any more help. ~Charity

yes.

[Forms]![CustomerService]![sfrmComplaint]![specific] sfrmComplaint is now a subform of the CustomerService form, so you must reference the parent form control, then the subform control, then the specific combo box. This line equates to The value of the control named "specific" which is a...

Try ="( " & Format([Date],"dddd") & " Week " & DatePart("ww",[Date]) & " )" & DatePart("ww",CDate("12/31/" & [year])) The function can't find the datePart of a string value, so you should convert the string to a date.

Form Unload event of your form that displays the information use forms!yoursearchform!yourcombobox.requery

Is your letter being printed from a report? If so, set the can grow and can shrink properties for the memo field in the report.

Check the lookp setting for the fields on the tables and make sure you aren't referencing a missing table/query/field.

Okay. Great. Now do you notice that when you change customers, the complaints are filtered for that specific customer? Another benefit of this setup is that when you enter a new complaint, the customerID will automatically be linked to the ContactID on the main form. Now for your dropdown...

Open the CustomerService form, and delete the controls out of the Header. Save this and rename the form as sfrmComplaint. Then rename Contacts1 to CustomerService and change the BorderStyle to Thin, Sizable, or Dialog. Increase the height of the detail section, and from the toolbox, select...

Next, if I understand your question. You want a drop down list in your Customer Service form that will list all complaints for the current customer, and allow you to select the complaint from the list, and display that selected complaint in the subform? I think there are some other issues that...

First, I'll answer the obvious issue that jumped out at me. You are getting a type mismatch error, because your ContactID is a numeric field, and you are attempting to join to the CustomerID field which is of text type. Change the data type of the CustomerID field in your CustomerService table...