anyone know y...
- Thread starter yessir
- Start date
Few comments and ideas
Hi yessir!
Well looks like your problem might be that the names in the "Where" statement you are putting together don't match the table field names. You are using the names of the form fields, but the sql statement is looking at the table. So change the parsing of the where statement to use the table names (and make sure that you edit the name of the fields first in the table and remove any special characters like '/' and '#' etc. first). Also don't forget that if you leave spaces in the field names, you have to enclose them in brackets in your where statement. (a space will signal that you are at the end of the field name, unless it is in brackets) Probably would be a good idea not to have spaces in your table field names. ([Phone Call] becomes PhoneCall)
Also, regarding the total at the bottom of your form; instead of printing the total number of pages at the bottom of each page, how about printing "Page 1 of 14", "Page 2 of 14", etc.
Here's how:
1. Make Page Header and Footer visible; place check next to PageHeader/Footer under View menu item (all the way at the bottom under 'Toolbars', just click on the arrows under 'toolbars' and the list will expand and become visible.
2. In the page footer create a text box control, and copy the following into the 'Control Source' property (don't forget the =):
="Page " & [Page] & " of " & [Pages]
Good Luck and email me again if you have more questions.
Normajean
Hi yessir!
Well looks like your problem might be that the names in the "Where" statement you are putting together don't match the table field names. You are using the names of the form fields, but the sql statement is looking at the table. So change the parsing of the where statement to use the table names (and make sure that you edit the name of the fields first in the table and remove any special characters like '/' and '#' etc. first). Also don't forget that if you leave spaces in the field names, you have to enclose them in brackets in your where statement. (a space will signal that you are at the end of the field name, unless it is in brackets) Probably would be a good idea not to have spaces in your table field names. ([Phone Call] becomes PhoneCall)
Also, regarding the total at the bottom of your form; instead of printing the total number of pages at the bottom of each page, how about printing "Page 1 of 14", "Page 2 of 14", etc.
Here's how:
1. Make Page Header and Footer visible; place check next to PageHeader/Footer under View menu item (all the way at the bottom under 'Toolbars', just click on the arrows under 'toolbars' and the list will expand and become visible.
2. In the page footer create a text box control, and copy the following into the 'Control Source' property (don't forget the =):
="Page " & [Page] & " of " & [Pages]
Good Luck and email me again if you have more questions.
Normajean
Similar threads
Solved
SQL Error
