Report Based On Selection

[Ron A.]

I would like to have a report produced based on a query and have the report
grouped by a selection in a combo box. Is this possible with an average
knowledge of Access or does code have to be written? Thanks

 

[Ron A.]

After reading my post, I realized it was too vague. I have a query from 2
tables (tblPurchase and tblPurchaseDetailsExtended) with the following fields:

PurchaseID
PurchaseNo
VendorID
InvoiceNo
PurchaseDate (criteria: Between[Begining Date] And [Ending Date])
CardHolderID
PaymentMade (yes/No)
PaymentDate
Comment
PurchaseDetailID
PurchaseID
PurchaseCategoryID
Item
Quantity
Price
ExtendedPrice

I would like to have records returned by the date range input by user and
have the user select a purchase category from a combo box to sort the report
by. Thanks

Ron

 

[Tom Wickerath]

Hi Ron,

I have a ready-made sample that shows you how to base a report on a date
range. I suppose you could do it with macros but, frankly, it's a lot easier
IMHO to use VBA code. You can download the sample using this link:

http://www.accessmvp.com/TWickerath/downloads/customdialogbox.zip

If a person is selecting a purchase category from a combo box, wouldn't you
want to limit the report to just that category of products?


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________

:

After reading my post, I realized it was too vague. I have a query from 2
tables (tblPurchase and tblPurchaseDetailsExtended) with the following fields:

PurchaseID
PurchaseNo
VendorID
InvoiceNo
PurchaseDate (criteria: Between[Begining Date] And [Ending Date])
CardHolderID
PaymentMade (yes/No)
PaymentDate
Comment
PurchaseDetailID
PurchaseID
PurchaseCategoryID
Item
Quantity
Price
ExtendedPrice

I would like to have records returned by the date range input by user and
have the user select a purchase category from a combo box to sort the report
by. Thanks

Ron
__________________________________________

:

I would like to have a report produced based on a query and have the report
grouped by a selection in a combo box. Is this possible with an average
knowledge of Access or does code have to be written? Thanks

 

[Ron A.]

Thanks Tom. I used the sample you provided and altered where needed and it
works great, but I did notice that since using the sample that the User
Permissions for the database are not available. Is this by design?

 

[Tom Wickerath]

Hi Ron,

I'm not sure what you mean by "User Permissions for the database are not
available." Can you explain some more what you mean?

Thanks,

Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________

 

[Ron A.]

The ribbon does not have the Administer Tools that you would use to set user
permissions or to replicate a database. All other databases I open this shows
on the ribbon, but when I open the one I just made with using the module from
the sample database posted in your reply...user permissions is not available.
Hope this explains enough. Thanks.

 

[Tom Wickerath]

Hi Ron,

The ribbon is a new feature introduced with Access 2007, so I assume that is
the version you are using, right? I'm not using Access 2007 on a daily
basis, as I do 99.9% of my work using Access 2003. My understanding is that
Access ULS (User Level Security) still works in Access 2007, but only if you
are using the .mdb file format. I *believe* Microsoft has removed the GUI
tools used for administering ULS in Access 2007. If you convert to the newer
..accdb file format, then there is no support for ULS at all.

Also, replication was removed from Access 2007 (in both the .mdb and .accdb
file formats).


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________

:

The ribbon does not have the Administer Tools that you would use to set user
permissions or to replicate a database. All other databases I open this shows
on the ribbon, but when I open the one I just made with using the module from
the sample database posted in your reply...user permissions is not available.
Hope this explains enough. Thanks.
--
Ron A.
__________________________________________

:

Hi Ron,

I'm not sure what you mean by "User Permissions for the database are not
available." Can you explain some more what you mean?

Thanks,

Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________

:

Thanks Tom. I used the sample you provided and altered where needed and it
works great, but I did notice that since using the sample that the User
Permissions for the database are not available. Is this by design?

 

[Ron A.]

Thanks Tom,

Thanks again for clearing this up for me. I was able to convert the
database back to an .mdb and set up user groups and permissions.