Tabular Data Design

[pbaldy]

I'm doing great Ram; hope you are too.



To be more accurate, that opens the form with the old values in it but moves to a new record (ie you can still navigate back to older records). If you only want to add records, either set the form's Data Entry property to Yes or use the data mode argument of OpenForm to open it in data entry mode. Either would be more efficient if you didn't need to be able to navigate to older records, as the form wouldn't load them.

That said, normally a form and subform are kept in sync with each other via the master/child link properties of the subform control. Are those set correctly? It doesn't sound like it.

[Ramsi2001]

Yes Paul... I missed this property... And i am sorry to bother you for this..

Thanks a lot again!!!


Regards,
Ram

[pbaldy]

Twas no bother; happy to help.

[Ramsi2001]

Hi Paul,
Good Afternoon!! How are you?

I have a question on Reports. I have two master-child tables and for each record in the master table, i have multiple rows in the child table.

Now, i have to design a report in such a way that I have to print the fon record in the master table followed by the related records in teh child table.

For example:
TasK 1 --- Description

Task 1 --- Name1 -- Hours1 -- Rate1 -- Amount1
Task 1 ---- Name2 -- Hours2 --- Rate2 --- Amount2

TasK 2 --- Description

Task 2 --- Name1 -- Hours1 -- Rate1 -- Amount1
Task 2---- Name2 -- Hours2 --- Rate2 --- Amount2.

How can we design this kind of report?

Please help me!!!

Thanks in advance,
Ram

[pbaldy]

A couple of ways come to mind. If you create a query that includes both tables, you should get a row for each detail record, with the main record data repeating. If you create a report with the wizard, it will as you what you want to group on, and you would use the description from the main record. You can set up the same thing in Sorting and Grouping. That would get you the look you describe.

The other way is with a report/subreport, where the report was bound to the master table and the subreport to the child table.

[Ramsi2001]

Hi Paul,
I have understood the option of Sorting and Grouping.

But I have a question on the query option. I am still new to access

After joining two tables in the query, do i have to manipulate using the recordset. Or is it the query that does it for me.

Because, if i join the two tables, i will get the results as a set of records that includes the columns from both the tables. The how can i get the values of how i described?

Am I clear of what i want to ask?

Please let me know...

[pbaldy]

Can you post the db? Yes, you'd get fields from both tables in the result. With the proper selections in Sorting and Grouping, you'd have a group header section and a detail section. You'd put the fields from the main table in the group header and the fields from the child table in the detail section.

[Ramsi2001]

I think now i got it.

Thanks a lot Paul.

If I have any issues, I will send the DB as well.

Thanks again.. You are my saviour!!

[pbaldy]

Happy to help Ram!

[Ramsi2001]

Hi Paul,
Good Afternoon!!

I have one question for you.

I am trying to design one report for my manager. But she is very adamant about the design. She wants this report to look like the one she maintains in Word document.

Can you suggest whether it is better idea to create a report or open a word document with same format and fill in the details.

Here is the attached file of that word document.

[pbaldy]

That appears to be an Excel spreadsheet, not a Word document. I'll proceed on that basis, and clarify at the end. I don't see anything offhand that would make it particularly difficult to create as an Access report (not quite sure what's going on at the bottom). It would just take some time to move everything around until you achieved the same look.

That said, it would also not be that hard to populate an Excel template with the values. You open a recordset on the data, and you know to place the Project Description field into cell D4, etc. It might be a bit more work if you're unfamiliar with automating Excel, so I'd probably only go that way if the goal was to end up with an Excel spreadsheet.

If it really is a Word document, the Excel comments probably still apply. I've never needed to automate Word, but my understanding is that you can use bookmarks to populate specific points in the document with your data, much as you would with Excel. Like I said, I've never automated Word, so "no warranties, expressed or implied".

Like I said, unless part of the goal is to end up with a Word/Excel file, I'd likely create a report, which could then be exported to PDF. In my experience, that's the format most likely to be sent out (though Excel is a contender).

[Ramsi2001]

Hi Paul,
Thanks for the reply.

with the report design, my only concern was that tabular borders around the sheet.

Is there any code to be written to get that kind of tabular look with borders and dotted lines? or is it just the part of design. If so, what to use from the toolbox to get that kind of report?

PLease help!!!


Thanks in advance,
Ram

[pbaldy]

There's a line tool and a rectangle tool, so some combination of those. Both are solid lines by default but have options to make them dashes or dots.

[Ramsi2001]

Thanks a lot Paul!!!

As always, You are very helpful!!


Regards,
Ram

[pbaldy]

As always, happy to help!