String concatenation...should be an easy one.. 2

[herbal]

Hello. I have a label with the following string:

The membership committee hereby approves these minutes as a summary of actions taken at the membership committee meeting on __________ as evidenced by the minute wraps filed on club premises.

How do I replace the _________ with today's date? I know the command is Date(), but I'm not sure how to do this.

Secondly, how do I direct a textbox to display the company name for the database in use? I feel like this should be simple as well but Access's help files blow.

Thanks,
Herbal

 

[cghoga]

Create a filed and set its control source to:

="_____" & Date() & "_____"

You may have to play with spacing.

The 2nd issue can be handled using a query. If it is a database for each company, you can create a label to go on the report and set its text to whatever the company name is. If the company names are stored as fields in a table then you will need a query or a filter to get the particular company's data, then include a field on the report bound to that field.

Hope this helps.

 

[THWatson]

herbal
Regarding Issue #1...

Create an unbound text box, rather than a label, in your report. Set its control source to
="The membership committee hereby approves these minutes as a summary of actions taken at the membership committee meeting on " & Date() & " as evidenced by the minute wraps filed on club premises."

You may want to show the date in full, for example May 28, 2004

In that case, the control source would be...
="The membership committee hereby approves these minutes as a summary of actions taken at the membership committee meeting on " & Format(Date(),"mmmm dd, yyyy") & " as evidenced by the minute wraps filed on club premises."

Tom

 

[herbal]

problem #1 has been solved.

Problem #2 - I'd really like the report to take the company name from the company property of the db properties that way I don't have to manually change every report in the db. Any suggestions?

 

[THWatson]

Herbal
Can you explain a little more about how things are set up?

Do you have a table with a number of companies in it, so that each company would have an ID?

Tom