Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
conditional formatting
I am trying to use conditional formatting on a subform, but it's not working. This is what I'm doing: In the conditional formatting dialog box I choose "Expression Is" from the formatting criteria drop down list. Then I entered [Forms].[WindowTreatmentQuerysubform]![Original?]=False...- jsullivan
- Thread
- Replies: 0
- Forum: Data Management Tools general discussion
-
Duplicate Data Problem
I have a database with two tables: One contains Rep names and their personal info, the second contains center info ie: location, address, phone etc. The two tables are linked through the location field in a one(center) to many(reps) relationship. I need to create a report that lists all the...- jsullivan
- Thread
- Replies: 1
- Forum: Data Management Tools general discussion
-
Generate numbers / letters
I need to generate a series of numbers automatically, each time a new record is entered. However, the series of numbers needs to always start with "CAD". It would be preferable if there is a way to include the date within the line - but I don't know how to do this. Something like...- jsullivan
- Thread
- Replies: 2
- Forum: Data Management Tools general discussion
