Replies

Why did MS think it necessary to make yet another format for this sort of thing. Practically everyone has Acrobat already, so why couldn’t MS just go with that? Are they really so greedy that they have to make everything work only in their own format? Just bugs me that they are so arrogant towards users.

Thanks, I get it now.

This can be done more elegantly by including the “thru” in a package with the end date:

=[Forms]![frmCriteriaHP]![txtDateType].[Caption] & ” ” & [Forms]![frmCriteriaHP]![txtStartDate].[Caption] & (” Thru ” + [Forms]![frmCriteriaHP]![txtEndDate].[Caption])

Now the “thru” won’t print unless the end date is entered.

These MSys… tables are showing up in my backend database. They were never there before a few months ago. Again, only some of my original tables have MSys table represetnatives. I can see that Access may have these “in the background” but I am wondering why they are showing up where I can see them. Mainly, they are cluttering up my database window. Could it be I set some obscure setting that makes these show up? And why are not all the tables represented?

Thanks, but why are these all of a sudden showing up in my database window ?- they were never there before.

Thanks. That answers that. I did try using the splitter several times and each time it shows the relationships on both front and back ends. I don’t ususally use the splitter and just do it manually. From now on, however, I’ll be sure to change any relationships in the backend rather than the front end.

Sounds to me like you will have to settle for continous main form with all the details showing. Maybe a datasheet would be better for this. Just bring everything together with a query and sort by client and year. Then everything for each client will be together in order. You could use a popup form to enter new payment info for a client and then requery the main form to show the new entry (you can even go right back to the records you were looking at).

You could use DLookups or recordset code to update the other database. DLookups are easier, but may be slower.