Replies

Style is Normal.

I have not heard back, so I don’t know if he deleted Normal.dot or not, nor have I passed on John’s Avery Wizard suggestion, yet. I’d be willing to bet that would work around the problem, but then I’ll always wonder what the trouble was.

Thanks for your thoughts.

Style is Normal.

I have not heard back, so I don’t know if he deleted Normal.dot or not, nor have I passed on John’s Avery Wizard suggestion, yet. I’d be willing to bet that would work around the problem, but then I’ll always wonder what the trouble was.

Thanks for your thoughts.

Yes! Thank you so much.

Yes! Thank you so much.

Thank you both! I always appreciate different ways of tackling the problem.

Mark, you answered a question I have had for a long time – and it’s not one I knew applied to this situation. However, I still have a problem. When I look at my datasheet form in design view, I do not see what you and Charlotte see. Yours are arranged in the “columnar” format. Mine is in the “tabular” format. If I “attach” as you suggest, the label joins the field in the detail area and I cannot drag the newly attached label to the form header area. The only way to get it up there is to break that attachment.

How can I change the design view arrangment to the “columnar” layout? (I have a Word attachment with screen captures I’m not being able to send through, so I hope the description is good enough.)

Mark, you answered a question I have had for a long time – and it’s not one I knew applied to this situation. However, I still have a problem. When I look at my datasheet form in design view, I do not see what you and Charlotte see. Yours are arranged in the “columnar” format. Mine is in the “tabular” format. If I “attach” as you suggest, the label joins the field in the detail area and I cannot drag the newly attached label to the form header area. The only way to get it up there is to break that attachment.

How can I change the design view arrangment to the “columnar” layout? (I have a Word attachment with screen captures I’m not being able to send through, so I hope the description is good enough.)

I did say it badly on several counts. It is evidently the datasheet view I’m having trouble with. The column headings are the field labels. Can I use a caption? When I look at a datasheet-style form in design view, it LOOKS like a the kind of form the wizard makes if you choose Tabular. In the design view, I can edit the column heading directly or in the properties box, I can add a caption for the label or change the label name. And Access continues to display the field name. I can change the style to continuous and get what I want, but I’d like to know if it is possible to modify the column heading in datasheet view.
Thanks.

I did say it badly on several counts. It is evidently the datasheet view I’m having trouble with. The column headings are the field labels. Can I use a caption? When I look at a datasheet-style form in design view, it LOOKS like a the kind of form the wizard makes if you choose Tabular. In the design view, I can edit the column heading directly or in the properties box, I can add a caption for the label or change the label name. And Access continues to display the field name. I can change the style to continuous and get what I want, but I’d like to know if it is possible to modify the column heading in datasheet view.
Thanks.

I am not relating fuel per trip.
I need to produce a log for each truck – one that lists, in chronological order, trips taken and fuel purchase by date for each truck. I can get a report with truck info in the detail and subreports for fuel and trips in the group footer. It works, but since those are 2 subreports, there is no way to look at a summary of one day’s activity – you have to check 2 areas. (I’m trying to match the existing report. It lists dates and trips. There are several trips / day. There may be more than one fuel purchase per day. When fuel is purchased, the fuel amounts is simply included on one of the lines for that date.)

I am not relating fuel per trip.
I need to produce a log for each truck – one that lists, in chronological order, trips taken and fuel purchase by date for each truck. I can get a report with truck info in the detail and subreports for fuel and trips in the group footer. It works, but since those are 2 subreports, there is no way to look at a summary of one day’s activity – you have to check 2 areas. (I’m trying to match the existing report. It lists dates and trips. There are several trips / day. There may be more than one fuel purchase per day. When fuel is purchased, the fuel amounts is simply included on one of the lines for that date.)

I was putting in a partial record (see Mark L’s comment) and leaving the child’s link field null. In that case, yes, I can create a child record in the table. (It was not a logical way to use the system – I was trying to break it!)
Thanks for the response

I was putting in a partial record (see Mark L’s comment) and leaving the child’s link field null. In that case, yes, I can create a child record in the table. (It was not a logical way to use the system – I was trying to break it!)
Thanks for the response

Thank you Mark. While I’m no Access expert, I’ve used, taught, developed in Access for several years. I have been teaching that Referential Integrity precludes having orphaned child records – PERIOD. I wonder how many other yawning exceptions I have missed!

Happy Spring!

Thank you Mark. While I’m no Access expert, I’ve used, taught, developed in Access for several years. I have been teaching that Referential Integrity precludes having orphaned child records – PERIOD. I wonder how many other yawning exceptions I have missed!

Happy Spring!