ACCESS FEED: Re: [MS_AccessPros] Re: New here & Know Nothing About Databases

Rabu, 29 Juni 2011

Re: [MS_AccessPros] Re: New here & Know Nothing About Databases

Thank you ever so much. It works great!

On Wed, Jun 29, 2011 at 2:03 AM, John Viescas <john@viescas.com> wrote:

> **
>
>
> Pat-
>
> I fixed it. I set it up so you can select multiple recipes in the list by
> holding down either the Ctrl key to select non-contiguous items or the
> Shift key
> to select several together. (Works just like file selection in Windows
> Explorer.) Click the Edit or View/Print buttons to get all the ones you
> selected. File is My Recipe Book.zip. Let me know when you've downloaded it
> so
> I can delete it.
>
> John Viescas, author
> Microsoft Office Access 2010 Inside Out
> Microsoft Office Access 2007 Inside Out
> Building Microsoft Access Applications
> Microsoft Office Access 2003 Inside Out
> SQL Queries for Mere Mortals
> http://www.viescas.com/
> (Paris, France)
>
> -----Original Message-----
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Pat Reynolds
> Sent: Wednesday, June 29, 2011 1:29 AM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: Re: [MS_AccessPros] Re: New here & Know Nothing About Databases
>
> Not sure if I did it right, but I uploaded it. I'm just trying to select
> any 4 recipes to print 4 at a time. Creating and working with databases is
> out of my league. I'm great with all the other Microsoft programs, but not
> that one. The only reason my friend made this for me was that I kept buying
> new recipe programs and as MS changed operating systems, I was having to
> buy
> more and more.
>
> On Tue, Jun 28, 2011 at 12:59 PM, Crystal <strive4peace2008@yahoo.com
> >wrote:
>
> > **
> >
> >
> > Hi Pat,
> >
> > Welcome :)
> >
> > adding on to what Bill said... for ribbon
> >
> > >> File >> Info >> Compact & Repair Database
> >
> > for Access 2007, click round Microsoft Office button instead of File
> >
> > ~~
> >
> > then close database.
> >
> > right-click on the File Name in Windows Explorer or My Computer. choose:
> > >>
> > Send To >> Compressed (zipped) Folder
> >
> > the zip file is then what you will upload to
> > >> Files >> 2_AssistanceNeeded
> >
> > Warm Regards,
> > Crystal
> >
> > *
> > (: have an awesome day :)
> > *
> >
> > --- On Tue, 6/28/11, Bill Mosca wrote:
> >
> > > From: Bill Mosca
> >
> > > Hi Pat
> > >
> > > Feel free to upload your database, but first compact it.
> > > Click on the Office button in the top, left corner and
> > > select Compact & Repair. I can't remember if it is under
> > > Database tools in 2007 or not.
> > >
> > > Once you compact it, zip it and upload it to our Assistance
> > > Needed folder.
> > >
> > > We usually don't just fix something. We prefer to teach,
> > > but maybe someone will find some time to make the changes
> > > you want.
> > >
> > > One thing you can look into...try creating a new report
> > > with the report wizard. There might be a Label report with 4
> > > labels per page. They would probably be 4 1/4" x 5 1/2, but
> > > anything close to that size should work.
> > >
> > > If there is no label that size you can create a custom
> > > label. Just follow the wizard.
> > >
> > > Regards,
> > > Bill Mosca, Founder - MS_Access_Professionals
> > > http://www.thatlldoit.com
> > > Microsoft Office Access MVP
> > > https://mvp.support.microsoft.com/profile/Bill.Mosca
> > >
> > >
> > >
> > > --- reynolds1680 wrote:
> > > >
> > > > I'm brand new to this group. I just decided to
> > > check yahoo groups to see if there was a MS Access group
> > > here. I have no experience whatsoever with MS
> > > Access. Databases are not my forte.
> > > >
> > > > I have a little recipe database that was designed in
> > > Access 2007. I have no problem with the database, but
> > > I can only print one recipe at a time. I need to have
> > > the ability to select several recipes so that I can print 4
> > > at a time onto my letter size recipe card stock.
> > > >
> > > > I did not design this little database, a friend
> > > did. My friend who designed it doesn't know how to
> > > change it so that I can select more than one recipe to
> > > print.
> > > >
> > > > I see that you have a section in your files where it
> > > appears people can upload a database to be fixed.
> > > >
> > > > Is it possible for me to upload this little database
> > > and someone would be kind enough to add the missing item
> > > (I'm assuming from all the reading I've been trying to do on
> > > this that I need some sort of query option).
> > > >
> > > > Pat
> > > >
> > >
> >
> >
> >
>
> [Non-text portions of this message have been removed]
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>