I have developed an Access Database for my Co-Op work term workplace, and everything seems to be running smoothly with the exception of the report generation phase. The company I am at has a set template for all reports (Clients column always goes in a specific place on the page, and the report always contains the same categories in the same locations; things like that). The problem is that, every time I go to make a new report, I have to re-format and re-make the report. Is it possible to save a report`s format so that, when I go to make a new report, it automatically applies that format to the data being used?
I was thinking today if it is possible to fill Access reports based on a specific Word template? I don't want to populate a Word file with Access data as users of my app might not all have Word. Or is there another solution using a WYSIWYG editor where users can format everything according to their needs? That would be fantastic.
What I want to do is save a daily report to a map source, each day the map name changes so for today the map name is "Report2013-10-03", and tomorrow the map name will be "Report2013-10-04".
Is this possible? is there some function like save(Report%s) where %s = date() ?
i have been trying to figure out how to make a textbox if it is null to be invisible on a report.
I selected the detail section on the report, under the Event tab, On Format option then selected [Event Procedure] and then clicked on the ellipses.
Tbl_Receipt_Description is the name of the text box. ******************************************* If Me.Tbl_Receipt_Description = " " then Me.Tbl_Receipt_Description.Visible = False Else Me.Tbl_Receipt_Description.Visible = True End If *******************************************
I am making labels to stick on containers that we're shipping out. Some shipments will have only 1 container and some will have more than 1.Can I have it repeat a label if there are more than 1 container for an order?
For example: Shipment 1 has 3 containers. The label says "3 x DM" and it will make one label.
Can I set it somehow to print that label three times? What about adding incremental text, e.g. 1 of 3, 2 of 3, 3 of 3?
We have a shared personnel access database for our department. Another department is wanting to use the same database. Is there a way to go about deleting all the info and making a template to give the other dept to use?
I am building a database which produces a report which I have formatted as a letter, I know I could have done this via a mail merge etc however...
What I am wanting to achieve is when this report(letter) is run, is there a way that when it is produced from a macro button embedded in a form that this report can then be saved as a pdf attachment within the same access database attached to a client record?
Any definitive way of exporting a query to an Excel file and then saving it as a new file without saving over the original.
I've tried to remove any confidential info from the code below so it's not exactly the same.
Code: Dim XLApp As Excel.Application Dim XLSheet As Excel.Worksheet Dim tmpRS As DAO.Recordset Dim strFolder as String strFolder = ("C:Profiles"& [Name] & "")
[Code] ....
The error seems to be with the SQL statement although that may just be the first error that it got to. I read that you can't refer to a Query if it has a criteria and that you have to write the SQL directly into the code.
I currently have a set of labels that works flawlessly - it has 2 columns and 20 rows. I have a form that I can select which label to start printing on so I use up a full sheet with no waste. [working labels attachment]
The labels I'm trying to print on now are 1.25" x 10", as seen HERE. Since I cannot rotate the whole report 90 degrees, I set up the labels to have one column with six rows instead of 6 columns with one row (landscape instead of portrait).
I copied the entire label printing process from the known working report. For my new set of labels, the label prints great if I have just one record, and/or I start at label #1. If I want to start at label #6, it just prints slightly lower on the page instead of at label #6 position (which is the bottom of the page). [label at #6 position attachment].
How much formatting can be done to a report from Access into Excel? I am trying to (or will be in the next day or so) to create a report to export data and I would like it presented in a specific format. This is hopefully to replace a spreadsheet where someone currently has to collate and re-type a load of info that has already been typed into various other spreadsheets.
Access is going to happily cope with all of those users entering their data to a table, and I would like to be able to output that data to something similar to the end result now? Is there a way to have an Excel template file and simply direct Access what to put in which cell?
Am working in MS Access 2013 and I have a form with a button, I need the button to doattach automatically the pdf-report to the email template(i don't want to attach the pdf to a new email)
Right now the command open the E-mail template and create the pdf-report in the desktop
Code: Private Sub Command18_Click()
Dim oApp As Outlook.Application Dim oMsg As Outlook.MailItem Dim oAttachment As Outlook.attachment Set oApp = New Outlook.Application
I need two reports made but I don't know the programming. The first report comes from a table that has contact numbers and their scan times. Their number comes from one column and their times come from another column in a table that i have. the time comes in this format 6/11/2007 3:46:40 AM. One report I need is those who just scaned in for that certain day. The second report is one to take their times and calculate how long they were scanned in per day, and per week. Is there any such way to do this and how would I.
I'm trying to make reports of all my queries, but when I try to make reports a there's a message saying "enter parameter value". I don't know what to make of that.
I've made command buttons for some of the queries, maybe that's the reason. When I for example try to make a report for the query "Kunder och telefonnummer", I don't see any names nor phone numbers on the report all I'm asked to do is enter parameter value. My database is in the other thread"Delete query" Please help me!
-Two textboxes with client first and last name -Two textboxes with a contact 'email1' and 'email2' for the client -A combobox with a list of templates to use for the email. -A checkbox to include a copy of the statement on the email.
I want the user to be able to press a button which does the following
-Sends an email to both 'email1' and 'email2'. -Attaches a secific report as PDF if the user has selected the checkbox -The body of the email includes a greeting line using the clients name from the record. -The body of the message includes below the greeting line a html email template depending on the users combobox selection.
I made a report that contains 10 textboxes beside each other and i changed the option (can grow) of the textboxes to yes the growing is okay, but i want all the textboxes to grow the same size as the bigger one.
I am creating a registration DB for a school. My tables are all set up and working, but what I cannot figure out how to do is to create a report such that upon opening it, a little dialogue box pops up and asks me "Term" and "Class" and then I type those things in and viola I get a class list.
I have a table which has the fields: Agentname,SaleDate,Branch,Sales, Percentage, Comission, Corrections, rent and Total
Total = Sales-comission+Corrections+rent
This table has the name of the agent that made the sale, the branch(location) where he made it, the date, the commission of how much he gets from the sale, Corrections which is various correction that need to be made like a refund and or bonuses, Rent which he pays and the total.
what i want to do is to get access to make me a sheet( a sales invoice) where i can see the sales for a specific agent for a specific branch. agents can work at multiple branches.
so lets say agent A on branch A sold 400 on 1/8, 300 on 2/8 and 500 on 5/8 i want to get a list of all the days from 1/8 till 31/8 and the records of 1/8, 2/8 and 5/8 automatically attached to the correct dates and the rest of the dates should have a value of 0.
I would like to have one stupid question, because I could not find any answer on this forum. I want save the Form as Report. I can do that from "Menu bar", but I want to do that from the code (VBA or Macro) without inputting the output parameters by users. Do you have any idea how?
Can anyone tell me how to have Access automatically close a report without saving any changes. I do not mind if the user closes the report manually but do not want Access to prompt the user to save changes. I want it to automatically abandon any changes that were made.
I have built several reports and I have set the layout to Landscape. When I go into the reports after a few days, it puts the format back to portrait. How can I stop this from returning to portrait?
Hi all - I'm new here and am very glad to find this forum for some help!
I've been using Access for several years and I do the same type of reports over and over and all of a sudden I'm having trouble.
I typically modify existing queries - changing the name of the department in order to pull up their info - and then I format a report and modify that same report over and over with the "Properties" key where I pull in the new query info and then use SAVE AS to save the report with that department's information.
For the first time ever it will not let me SAVE AS with the new info. Sometimes it just does nothing at all - appearing to save but then the report isn't there - sometimes giving me a pop up box that says it couldn't find the search key - I don't even know what that is!
I can SAVE AS with queries, but not reports. HELP!
