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
|
|||
|
|||
error in the report when no data
Hi,
I was wondering if I can get some help with Access report question. In an Access report, There is a number of headers namely Agenda Header, Task Header and SubTask Header. I got error in the report when SubTask is empty or no value. What I would like to be able to do is to be able to generate a report without errors even when SubTask has no record or data. Wonder if anyone might want to help me work around this. Any help would be appreciated. Thank you in advance |
#2
|
|||
|
|||
error in the report when no data
We can't see your data, your control sources, the report section, or your
error message. You might get a perfect solution that meets your needs if you provide more information. -- Duane Hookom Microsoft Access MVP "Associates" wrote: Hi, I was wondering if I can get some help with Access report question. In an Access report, There is a number of headers namely Agenda Header, Task Header and SubTask Header. I got error in the report when SubTask is empty or no value. What I would like to be able to do is to be able to generate a report without errors even when SubTask has no record or data. Wonder if anyone might want to help me work around this. Any help would be appreciated. Thank you in advance |
#3
|
|||
|
|||
error in the report when no data
Thank you Duane for your reply.
Sorry that i did not supply enough info for you to help me out. Basically, I am creating a database for our meeting minutes. It consists of four tables namely meetingminutes, agenda, tasks and subtasks. Table meetingminutes has the following attributes: MM_ID (autonumber & PK), MM_No (text), Agendas (text), DateMinutes (date/time) Table agenda has as follows agenda_ID (autonumber & PK), agenda_No (text), agenda_items (text), MM_No (FK) Table tasks has attributes as follows task_ID (autonumber & PK), task_No (text), task_items (text), actioner (text), MM_No (FK) and agenda_No (FK) Table subtasks has as follows STask_ID (autonumber & PK), STask_No (text), STask_items (text), actioner (text), MM_No (FK), agenda_No (FK) and task_No (text) In the report, the control source is based on a query that is created by linking those four tables together via their Foreign Keys. So in the report, i get errors when there is no data in the SubTasks. However, if i manage to put in data in the agenda, tasks and subtasks tables, I can get the report open up nicely with no errors. There will be an occasion when a meeting minute has data filled up to Tasks and has no items for SubTasks. Hope my explanation would help you to help me. Please let me know if you need any more info from me. Thank you in advance "Duane Hookom" wrote: We can't see your data, your control sources, the report section, or your error message. You might get a perfect solution that meets your needs if you provide more information. -- Duane Hookom Microsoft Access MVP "Associates" wrote: Hi, I was wondering if I can get some help with Access report question. In an Access report, There is a number of headers namely Agenda Header, Task Header and SubTask Header. I got error in the report when SubTask is empty or no value. What I would like to be able to do is to be able to generate a report without errors even when SubTask has no record or data. Wonder if anyone might want to help me work around this. Any help would be appreciated. Thank you in advance |
#4
|
|||
|
|||
error in the report when no data
"Error in the report" where? What control? What section? What control
source? -- Duane Hookom MS Access MVP "Associates" wrote in message ... Thank you Duane for your reply. Sorry that i did not supply enough info for you to help me out. Basically, I am creating a database for our meeting minutes. It consists of four tables namely meetingminutes, agenda, tasks and subtasks. Table meetingminutes has the following attributes: MM_ID (autonumber & PK), MM_No (text), Agendas (text), DateMinutes (date/time) Table agenda has as follows agenda_ID (autonumber & PK), agenda_No (text), agenda_items (text), MM_No (FK) Table tasks has attributes as follows task_ID (autonumber & PK), task_No (text), task_items (text), actioner (text), MM_No (FK) and agenda_No (FK) Table subtasks has as follows STask_ID (autonumber & PK), STask_No (text), STask_items (text), actioner (text), MM_No (FK), agenda_No (FK) and task_No (text) In the report, the control source is based on a query that is created by linking those four tables together via their Foreign Keys. So in the report, i get errors when there is no data in the SubTasks. However, if i manage to put in data in the agenda, tasks and subtasks tables, I can get the report open up nicely with no errors. There will be an occasion when a meeting minute has data filled up to Tasks and has no items for SubTasks. Hope my explanation would help you to help me. Please let me know if you need any more info from me. Thank you in advance "Duane Hookom" wrote: We can't see your data, your control sources, the report section, or your error message. You might get a perfect solution that meets your needs if you provide more information. -- Duane Hookom Microsoft Access MVP "Associates" wrote: Hi, I was wondering if I can get some help with Access report question. In an Access report, There is a number of headers namely Agenda Header, Task Header and SubTask Header. I got error in the report when SubTask is empty or no value. What I would like to be able to do is to be able to generate a report without errors even when SubTask has no record or data. Wonder if anyone might want to help me work around this. Any help would be appreciated. Thank you in advance |
Thread Tools | |
Display Modes | |
|
|