Access XP Questions Galore - Project Due 12/10/01

[Nephalim]

Originally posted by Nephalim:
I should just start one BIG thread for all the access questions i'm going to have this w/e

Originally posted by Pinky:
Yes you should.

So, here it is, my "BIG" thread! And hopefully some links to my other threads:
1. Microsoft Access and the User Interface (http://www.sharkyforums.com/ubb/Forum12/HTML/002284.html)
2. Access 2000 ComboBoxes from Hell (http://www.sharkyforums.com/ubb/Forum12/HTML/002135.html)
3. Continuous Forms (http://www.sharkyforums.com/ubb/Forum12/HTML/002249.html)
So here is my next question:

Is it possible to have multiple detail records in a report? I have four expense logs that I would like to list under their respective Horse (being that horses is the business I'm currently invovled in) and each Horse under it's respective Owner. As I see it now, and surmise is the way it really is, there can only be one detail record in a report. However, I hope to find out different. Thx. Hmmmm... maybe I can create a new table with a composite key and derive the record from that? Access sucks!

------------------
~ And that is my humble opinion.

When I was a boy I was told that anybody could become President. Now I'm beginning to believe it. - Clarence Darrow

The greatness of a woman’s power is measured in the size and amount of the balls she clutches in hand. -Me

"Tink"
1 GHz Tbird on A7V, 384MB PC133 RAM, Samsung 19" 900IFT, Radeon 64MB DDR VIVO, SB Live! MP3+, 42.9GB IBM HDD, Plexwriter 8/4/32, 3C905CTXM nic, Intellimouse Explorer

[This message has been edited by Nephalim (edited December 08, 2001).]

[Nephalim]

Anyone know where I might find a comprehensive guide to SQL in Access??? Oh, and for those who were wondering, this project is being done in Access 2000 format.

[Nephalim]

Is there a way to zoom in when creating reports... I'm having problems seeing what I'm doing!!!

[Nephalim]

Also, is there a way to total(in the parent report) subtotals from subreports? HELP!!!

[This message has been edited by Nephalim (edited December 09, 2001).]

[Nephalim]

I have another question. But first, I'd like to extend my impression that no one is posting to this thread!!! I hope it doesn't have anything to do with the fact that I'm posting about homework... I STILL NEED HELP!!!

Anywho, here's the next and possibly most important question: How can I export a switchboard to another database? It won't let me!!!

[Grizzly]

Sorry Nephalim, but I get the impression that no one here has a clue how to make Access Forms. I think I made one once a few years ago, but that was long ago.

Good luck with the project.

[Nephalim]

Originally posted by Grizzly:
Sorry Nephalim, but I get the impression that no one here has a clue how to make Access Forms. I think I made one once a few years ago, but that was long ago.

Good luck with the project.

Thanks Grizzly. Wow, all this expansive programming knowledge and no one knows about Access? I guess I'll have to get down and dirty and BE that person myself then.

BTW, the project has been extended to Wed., the 12th... so please feel free to post any answers if you are one of those "Access" people.

[Scuttle]

Right, there are ways to do number one, because i'm getting taught it after Christmas. Which while helpful in that there is a way to do it, means bugger all as i can't offer any assistance. http://www.sharkyforums.com/ubb/tongue.gif

Not a clue on the other two though...

May be of use:
Continuous forms (http://www.google.com/search?hl=en&q=Continuous+Forms+Access+XP)

http://www.sharkyforums.com/ubb/smile.gif


------------------
Cries of agony and hatred flow through your head. You lift the dagger, and the hatred flows over your arms and seeps into your skin whereas the cries die in the fiery corpse of life