Looking for DAILY news and commentary? Join us on my other channel “Coffee With Steve” for daily videos where we discuss Technology, Software Development, Politics, Culture, and many other things. Coffee With Steve: th-cam.com/channels/eXAUvo5xxDY_b-lSknPC1A.html
Hi Steve!! I am working on DBs with many columns (many data for each record) and its hard to work with them. The purpose of my work is to hand in information in an excel file, with a nice formatting, and I couldnt find the way to do it yet, not even with an ExportwithFormatting function. The best option for me would be to export the data in Excel (may be using a Report) with a nice format so as to easy our job. could you help me? Thank you!!! Great tutorials!
Steve, I have a question. I am trying tto use the reports grouping method where I can separate data by year, week, month. In my query, i have create week numbers, month numbers, and year numbers using the DatePart() function. Now in the group on of the report I can group then based on the week, month, or year number that I created. However, I am trying to create a button that would switch the grouping from weekly to monthly, but I do not know how to write the code that would replace the Group on value from Week to Month. Would you please let me know how I can achieve that using VBA?
Hi Steve, I would like to thank your for All efforts, your videos are the best on TH-cam. I want to create a report contain subreports where the user can modify subreports from form (add or remove subreports ) by using macro. would you please write the main steps. Thanks again.
That is a very complex thing to do. You have to open the report in design view through code. Additionally if someone were to try to run that code while in a run-time environment, they would get an error since you can't open anything in design view. It would be best to leave the data set of the subreport with 0 records, then tell it to auto-shrink.
I'm sorry, you misunderstand me I made without less/greater, It is same as mentioned =Nz([MyFields], "N/A") give me #Size!. Note my fields are numeric.
Hi Steve. I need your help in ms access. I am working on excell and ms.access both i copied data from excel to access for maintaing reports. Have you any suggestion that i only work and data will save in access with the link. I only can print my desire reports.
How do you update page numbers so they are grouped by customer? Customer A shows Page X of Y and all page numbers apply to only that Customer. The next Customer shows only their Page X of Y.
Hey Steve, I have a report that launches from a form. When I launch the report from the form it operates exactly as yours does. However when I use that form with a keyword search it only returns one value in the report; and I want all search results to show up. Would that be due to a coding error or am I missing something obvious?
Programming Thanks Steve. I haven't used a query, I stuck to using solely forms as my database has only one sheet. So now I just have to alter the code in the report to reflect all search results.
Under the report properties go to the format tab and look for the "Page Header" property. Make sure it is set to "All Pages". Also, if your detail is allowed to be larger than one page in height, it will not print on the second page.
Looking for DAILY news and commentary? Join us on my other channel “Coffee With Steve” for daily videos where we discuss Technology, Software Development, Politics, Culture, and many other things.
Coffee With Steve: th-cam.com/channels/eXAUvo5xxDY_b-lSknPC1A.html
Hi Steve!! I am working on DBs with many columns (many data for each record) and its hard to work with them. The purpose of my work is to hand in information in an excel file, with a nice formatting, and I couldnt find the way to do it yet, not even with an ExportwithFormatting function. The best option for me would be to export the data in Excel (may be using a Report) with a nice format so as to easy our job. could you help me? Thank you!!! Great tutorials!
Learned something new. Thank you
Steve,
I have a question. I am trying tto use the reports grouping method where I can separate data by year, week, month. In my query, i have create week numbers, month numbers, and year numbers using the DatePart() function. Now in the group on of the report I can group then based on the week, month, or year number that I created. However, I am trying to create a button that would switch the grouping from weekly to monthly, but I do not know how to write the code that would replace the Group on value from Week to Month. Would you please let me know how I can achieve that using VBA?
Hi Steve,
I would like to thank your for All efforts, your videos are the best on TH-cam.
I want to create a report contain subreports where the user can modify subreports from form (add or remove subreports ) by using macro.
would you please write the main steps.
Thanks again.
That is a very complex thing to do. You have to open the report in design view through code. Additionally if someone were to try to run that code while in a run-time environment, they would get an error since you can't open anything in design view.
It would be best to leave the data set of the subreport with 0 records, then tell it to auto-shrink.
Hi Steve,
How can I make NULL Values in my report fields as "N/A" on printing?
I tried with in Control Source, but it give me
Thanks.
I'm sorry, you misunderstand me I made without less/greater, It is same as mentioned =Nz([MyFields], "N/A") give me #Size!.
Note my fields are numeric.
What type of data is in the "My Fields" column?
Numbers
Hi Steve. I need your help in ms access. I am working on excell and ms.access both i copied data from excel to access for maintaing reports. Have you any suggestion that i only work and data will save in access with the link. I only can print my desire reports.
How do you update page numbers so they are grouped by customer? Customer A shows Page X of Y and all page numbers apply to only that Customer. The next Customer shows only their Page X of Y.
Hey Steve,
I have a report that launches from a form. When I launch the report from the form it operates exactly as yours does.
However when I use that form with a keyword search it only returns one value in the report; and I want all search results to show up. Would that be due to a coding error or am I missing something obvious?
Nessan Harpur The query that your report is based on probably uses that keyword field as part of the criteria for one of the fields.
Programming Thanks Steve. I haven't used a query, I stuck to using solely forms as my database has only one sheet. So now I just have to alter the code in the report to reflect all search results.
Can someone explain to me what "Back Color" is?
I have the same issue as Caroline Jc- I see just one Company address and not all !
How Insert the File Name Into the Footer in Microsoft Access?
how to hide header, footer and detail column if no data in all row? in ms access query based report??
I"m not sure I get what you meant.
I could not attach picture here, so i will email to you, thanks.
How do you print the header on every page
Have you figured out how to do this by any chance?
my report header was not printed on the 2nd page of my report? how can i fix this?
Under the report properties go to the format tab and look for the "Page Header" property. Make sure it is set to "All Pages". Also, if your detail is allowed to be larger than one page in height, it will not print on the second page.
How to do line in 2021?
How to change the date format? i want to put the name of the day and month
You're looking for the FormatDateTime function. msdn.microsoft.com/en-us/library/a912f2a0(v=vs.90).aspx
thank you a good tuorial
Thank you.
not sure where i went wrong, i cant see all companies, just one? it doesnt repeat itself
Try comparing your version to the work file.
can you help me?