Search results

Thanks for the help. I've looked at this every which way and can't figure out any other way to do it that would meet their needs.

jfgambit: This is for a counselor in a school for schedule changes. She needs current scheduling information and fields for new schedule changes. Due to the nature of the school (self-paced), students can have multiple schedule changes each semester. The report that is generated to be sent...

I have a form with the following fields: Period|Course|C No|Teacher|New Per|New Course|New #|New Teacher|Copy|Update The "Copy" and "Update" fields are yes/no checkboxes. What I want to do: When "Copy" is checked, Period, Course, C No, and Teacher field contents would copy to New Per, New...

Okay....Duh.... Open the form then click on the Print Preview button in the toolbar. That should do the trick.

Maybe you need the command button to be Print Preview and change the printer from print preview.

Yeeeeeee Haaaaaaa! It worked! As soon as I saw your code I knew what I had done wrong. I didn't need to put the Total Units field in the equation! Thank you! Thank you! Thank you!

I tried you code and Access accepted the syntax. However, when I ran the report the Total Units textbox show "#Error". I don't get it. I check the format of all the fields. Field 1 and field 2 are both number fields with field size double and format standard. The Total Units textbox is...

I don't think this can be done. I've used pop-ups for years and the only way you can do this is by closing and reopening the pop-up form.

This might be what you are looking for. Create a command button on the first form to open the second form. Use the Wizard to create this command button. When the wizard asks you if you want to view all the data or specific data, chose specific data. The next wizard window asks which fields...

I need help with a report in Access 2000! How would you do this? If [checkbox 1] is checked and [checkbox 2] is not checked then [Total] textbox should have same value as [field 1]. If [checkbox 2] is checked and [checkbox 1] is not checked then [Total] textbox should have same value as...