If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Report with buttons to open forms
Is it possible have a report which is from a query (which is based on
numerous other queries) that has buttons to open a specific form for each record on the report? I would like users be able to open the report and select a button which opens a specific form based on the results shown on the report. Any suggestions would be appreciated. Thanks. -- Donna N. |
#2
|
|||
|
|||
Report with buttons to open forms
Donna,
Reports don't support functional buttons, nor their events. Your best bet is to create a form that lists your records, and use a button on it , to call a form for a specific value. You should be able to use the same query used on your current report to feed the form. -- hth Al Campagna Microsoft Access MVP 2007-2009 http://home.comcast.net/~cccsolutions/index.html "Find a job that you love... and you'll never work a day in your life." "Donna" wrote in message ... Is it possible have a report which is from a query (which is based on numerous other queries) that has buttons to open a specific form for each record on the report? I would like users be able to open the report and select a button which opens a specific form based on the results shown on the report. Any suggestions would be appreciated. Thanks. -- Donna N. |
#3
|
|||
|
|||
Report with buttons to open forms
Al,
That's what I was afraid of as far as functional buttons on a report. I already created a form for that purpose, but I needed to also have the records numbered in sequential order and could not find a way to do that on the form, so I went with a report. Is there a way to show the records sequentially numbered on a form? Thanks for your help. -- Donna N. "Al Campagna" wrote: Donna, Reports don't support functional buttons, nor their events. Your best bet is to create a form that lists your records, and use a button on it , to call a form for a specific value. You should be able to use the same query used on your current report to feed the form. -- hth Al Campagna Microsoft Access MVP 2007-2009 http://home.comcast.net/~cccsolutions/index.html "Find a job that you love... and you'll never work a day in your life." "Donna" wrote in message ... Is it possible have a report which is from a query (which is based on numerous other queries) that has buttons to open a specific form for each record on the report? I would like users be able to open the report and select a button which opens a specific form based on the results shown on the report. Any suggestions would be appreciated. Thanks. -- Donna N. . |
#4
|
|||
|
|||
Report with buttons to open forms
Is it possible to have the functional button call a different form for each
different record? Thanks again. -- Donna N. "Al Campagna" wrote: Donna, Reports don't support functional buttons, nor their events. Your best bet is to create a form that lists your records, and use a button on it , to call a form for a specific value. You should be able to use the same query used on your current report to feed the form. -- hth Al Campagna Microsoft Access MVP 2007-2009 http://home.comcast.net/~cccsolutions/index.html "Find a job that you love... and you'll never work a day in your life." "Donna" wrote in message ... Is it possible have a report which is from a query (which is based on numerous other queries) that has buttons to open a specific form for each record on the report? I would like users be able to open the report and select a button which opens a specific form based on the results shown on the report. Any suggestions would be appreciated. Thanks. -- Donna N. . |
#5
|
|||
|
|||
Report with buttons to open forms
Donna,
Why do you need to sequentially number your records? If it's used to identify a particular record, for purposes of filtering a report, that would be better handled by an Autonumber field in your table. Since it would be calculated, and change as sorting changed, it would be useless as a record identifier. -- hth Al Campagna Microsoft Access MVP 2007-2009 http://home.comcast.net/~cccsolutions/index.html "Find a job that you love... and you'll never work a day in your life." "Donna" wrote in message ... Al, That's what I was afraid of as far as functional buttons on a report. I already created a form for that purpose, but I needed to also have the records numbered in sequential order and could not find a way to do that on the form, so I went with a report. Is there a way to show the records sequentially numbered on a form? Thanks for your help. -- Donna N. "Al Campagna" wrote: Donna, Reports don't support functional buttons, nor their events. Your best bet is to create a form that lists your records, and use a button on it , to call a form for a specific value. You should be able to use the same query used on your current report to feed the form. -- hth Al Campagna Microsoft Access MVP 2007-2009 http://home.comcast.net/~cccsolutions/index.html "Find a job that you love... and you'll never work a day in your life." "Donna" wrote in message ... Is it possible have a report which is from a query (which is based on numerous other queries) that has buttons to open a specific form for each record on the report? I would like users be able to open the report and select a button which opens a specific form based on the results shown on the report. Any suggestions would be appreciated. Thanks. -- Donna N. . |
#6
|
|||
|
|||
Report with buttons to open forms
Al,
I need to be able to rank order these records each time the query is run as the order may change throughout the day as users call up the form. -- Donna N. "Al Campagna" wrote: Donna, Why do you need to sequentially number your records? If it's used to identify a particular record, for purposes of filtering a report, that would be better handled by an Autonumber field in your table. Since it would be calculated, and change as sorting changed, it would be useless as a record identifier. -- hth Al Campagna Microsoft Access MVP 2007-2009 http://home.comcast.net/~cccsolutions/index.html "Find a job that you love... and you'll never work a day in your life." "Donna" wrote in message ... Al, That's what I was afraid of as far as functional buttons on a report. I already created a form for that purpose, but I needed to also have the records numbered in sequential order and could not find a way to do that on the form, so I went with a report. Is there a way to show the records sequentially numbered on a form? Thanks for your help. -- Donna N. "Al Campagna" wrote: Donna, Reports don't support functional buttons, nor their events. Your best bet is to create a form that lists your records, and use a button on it , to call a form for a specific value. You should be able to use the same query used on your current report to feed the form. -- hth Al Campagna Microsoft Access MVP 2007-2009 http://home.comcast.net/~cccsolutions/index.html "Find a job that you love... and you'll never work a day in your life." "Donna" wrote in message ... Is it possible have a report which is from a query (which is based on numerous other queries) that has buttons to open a specific form for each record on the report? I would like users be able to open the report and select a button which opens a specific form based on the results shown on the report. Any suggestions would be appreciated. Thanks. -- Donna N. . . |
#7
|
|||
|
|||
Report with buttons to open forms
Donna,
Tell me about the fields in your records. Do you have a field that you are sorting on? Let's say that each record has unique CustID autonumber field, and the records are sorted by that value... CustID 23 31 32 33 47 etc... Then a calculated field ([SeqNo]) with... (use your own field/object names) =DCount("CustID","tblYourTable","CustID " & CustID) CustID SeqNo 23 1 31 2 32 3 33 4 47 5 etc... -- hth Al Campagna Microsoft Access MVP 2007-2009 http://home.comcast.net/~cccsolutions/index.html "Find a job that you love... and you'll never work a day in your life." "Donna" wrote in message news Al, I need to be able to rank order these records each time the query is run as the order may change throughout the day as users call up the form. -- Donna N. "Al Campagna" wrote: Donna, Why do you need to sequentially number your records? If it's used to identify a particular record, for purposes of filtering a report, that would be better handled by an Autonumber field in your table. Since it would be calculated, and change as sorting changed, it would be useless as a record identifier. -- hth Al Campagna Microsoft Access MVP 2007-2009 http://home.comcast.net/~cccsolutions/index.html "Find a job that you love... and you'll never work a day in your life." "Donna" wrote in message ... Al, That's what I was afraid of as far as functional buttons on a report. I already created a form for that purpose, but I needed to also have the records numbered in sequential order and could not find a way to do that on the form, so I went with a report. Is there a way to show the records sequentially numbered on a form? Thanks for your help. -- Donna N. "Al Campagna" wrote: Donna, Reports don't support functional buttons, nor their events. Your best bet is to create a form that lists your records, and use a button on it , to call a form for a specific value. You should be able to use the same query used on your current report to feed the form. -- hth Al Campagna Microsoft Access MVP 2007-2009 http://home.comcast.net/~cccsolutions/index.html "Find a job that you love... and you'll never work a day in your life." "Donna" wrote in message ... Is it possible have a report which is from a query (which is based on numerous other queries) that has buttons to open a specific form for each record on the report? I would like users be able to open the report and select a button which opens a specific form based on the results shown on the report. Any suggestions would be appreciated. Thanks. -- Donna N. . . |
Thread Tools | |
Display Modes | |
|
|