Search:

In a continuous form (which is a subform) recording office visits for a patient, I want the "Date" field on the first record for each patient to default to today's date, but each subsequent record to...

I have a combo box “Combo4” bound to “CommitteeID” field in Table “tblAssignments”.
After a choice is made in that combo box, I would like the date in “GradYear” field in “tblAssignments” to be...

I have a table of orders with various items. If [ItemID] 18 is a shirt, and [ItemID] 19 is a tie, what expression do i use to get all of those that ordered a shirt, but no tie? In other words, "18"...

I'm sorry if this has been addressed somewhere before--I have looked and didn't find anything answering this:
I have a query based on three tables. One of the tables has some empty fields. Those...

Thanks--that points me in the right direction. And thanks to Mr. Lebans, too.

Edited by HansV to provide link to post. It's extremely simple: I only had to insert [ before and ] after Post: 566,407.

I have a report with a text box in it that can not grow beyond a 2.5"...

Sorry about the accdb. But, I am embarrassed to remember that the columns only show up in the PrintPreview view, but not in the Report view. I think it is all working correctly.

Post deleted by wsryan

Yes, the columns are set to 2. I tried stretching the subreport wider with no change. Should the text box be as wide as just the one column, or the whole width of the subreport? (I've tried both ways...

I have subreport that has a single text box in that lists a series of items that I want to be into two columns to shorten the height to what we want when we print. Some of the items are longer than...

Thanks, Hans

It works! I appreciate it.

Is there a way to set a default date in a table to be "The second Saturday in May for the current fiscal year"? Or, to run an update query at the start...

Thanks, Hans

It works! I appreciate it.

Thanks, Hans

It works! Thanks once again.

I have what I think is a variation on this theme. I have a series of reports that are repeated every fiscal year that starts in July (Fiscal year 2009 starts on July 1, 2008). I would like to have...

I have a table that lists details for orders. Folks can order diplomas ([ItemID] is 18). Some of those who order a diploma also order hand calligraphy ([ItemID] is 19) on that diploma. I am using a...

Keep together settings:
Report Header=Yes
Detail=Yes
Report Footer=Yes
(I guess the page header and footer have no settings for "Keep Together?)

Thanks again for you time and efforts on my...

OK...thanks for all the efforts from everyone. It is the report footer that wants to go to a second page, seemingly regardless of what I have tried with margins, etc. Now I see that ii is also true...

Not that I can tell--well, they were, but I shortened them and moved them all to the left and that seemed to make no difference.

I have some reports that have page and report footers. It seems that if I change those reports to contain two or more columns, that causes the report footer to go to a second page. I can't seem to...

Thanks, Hans--I'll look into those things, though I'm not remembering why I had that record source set to a query in the first place...

If I change the recordsource simply to the tblIndividuals, it looks like it works OK

The reocrd source for that frmIndividuals is set to:
SELECT tblIndividuals.*, tblFamily.Active
FROM tblFamily INNER JOIN tblIndividuals ON (tblFamily.FamID = tblIndividuals.FamID);

No, I can't. I hadn't noticed that.

I have a form frmFamilies with a subform frmIndividuals
They are linked by fields FamID
However, when the form is opened and a new record entered in the main form, there is not a new form created...

Below is the code used in a function for a form for sending email with an attachment. Can anyone tell me if there is a way to be able to attach multiple attachments? (I am using a "Browse" button to...