I have a macro which generates a report every time the user tabs to a field on my form. I want the user to continue tabbing within that form and be able to view the report. Instead, the focus (tab) switches to the report. How do I get the focus (tab) to stay on the form?
View RepliesI'v looking for since a couple months a go to make a report direct from access form using crystal report but i havent found it yet. I'v tried this code and its giving me errors. " run time error 1004 method range of object _global failed "
how to make a report using crystal report direct from ms access as front end application ? is it possible to use crystal report ?btw i use database sql server 2008 and MS Access 2007 as my frontend application.here's the code that i'v found and gives me an error
Dim CR As New CRAXDRT.Application
Dim rep As CRAXDRT.Report
Set rep = CR.OpenReport(Range(" ??? ")) * i getting error in this line, what should i do to fill it ??
rep.ParameterFields(1).AddCurrentValue "Boston"
rep.ParameterFields(2).AddCurrentValue "Cars"
rep.Database.Tables(1).SetLogOnInfo "tool", "db_tsel"
rep.ReadRecords
rep.PrintOut promptUser:=False, numberOfCopy:=1 ' promptUser:=True doesn't work
Hi,
I've been given an existing database to modify, and I'm struggling somewhat to see how the author has implemented certain functions.
On a main menu form (autoexecs on starting the database), there are various "Search By" option buttons to generate a report, ordered in various ways. The "On Click" field for each of them refers to a macro, called Buttons, and a line in that macro dependant on the type of search (e.g. OnClick = Buttons.byPerson).
The Buttons macro runs an OpenReport command, the report corresponding to the search type (e.g. Buttons.byPerson has an OpenReport command for the "Report by Person" report).
However, when I click the search buttons (or indeed run the corresponding reports) I instead get another form which allows the search criteria to be specified - this then generates the report (I would assume based on the relevant query - e.g. Person Query), but I cannot understand how this works.
Google searches have not helped much as I can't seem to find an adequate search phrase to use, and I've been staring at the thing for some hours now. Any help getting me off in the right direction would be much appreciated!
hi guys,
i have a form with a button. when i press the button it opens a report :
DoCmd.OpenReport "popreview", acViewPreview, acWindowNormal
the problem is that the report is in the backround and i cant use it until i close the form.
the form is setup as a popup.
is there any way to use the report and have the form opened at the same time?
thx, max.
Hey all,
i have designed a invoice form and am having trouble taking the values on the invoice form to a report. The report will act as an invoice to be printed. On my form there are mutliple fields from 2 tables such as 'invoice master table' which includes details such as invoiceid,invoicedate, customer number,employee number. The second table(used as a subform) that is used in the form is 'invoice details table' which contains details such as productid, retailprice, quantity. I have made other fields on the form to do calculations such as total price, price of each product depending on the quantity. I was wondering how i would design a report that contains these details from the form.
All help would be great :) have a nice day:cool:
I have a form, which has a subform on it...
i want to export the info from these forms straight into a report, can this be done ? if so how please
Hi
I'm pretty new to all of this. I've set up a simple database. I have a form in it for inputting information and then there is a command button on the bottom which prints out a report I've created with the information on it. This is all working great except it prints evey record and I only want the current record printed out.
I've tried the help and it goes into detail about OpenReport and PrintOut in macros. I have no idea what a macro is or what to do with it.
Can anybody please help me and give me step by step instructions as to how to print out only the current record in the report from the command button.
Your help is greatly appreciated:)
I have a form (entry screen to enter data) I then created a report in the layout I need for my order form. I want to creat a button that a user can press and it will print the current record to the report (order form layout)
Here is my current code for the print button on the form page:
Private Sub btnPrtOrderFrm_Click()
On Error GoTo Err_btnPrtOrderFrm_Click
Dim stDocName As String
stDocName = "rptOrders2"
DoCmd.OpenReport stDocName, acNormal
Exit_btnPrtOrderFrm_Click:
Exit Sub
Err_btnPrtOrderFrm_Click:
MsgBox Err.Description
Resume Exit_btnPrtOrderFrm_Click
End Sub
The only problem is when I tell it to print if I am on record number 2 on the form, it prints both record 1 and record 2. I only want the current record i am in to print. Any ideas much appreciated
Dean
Is there a way to print a report for only the form you are on.
Let say Iv got a list of customers on a form and I have a query for all the customers.
Can someone help me do this in a better way? I have built the two queries below to give me a montly sum of some church contributions. On the "Reportsfrm" form I have two combo boxes to choose the month. One of the combo boxes is setup to choose the months of the year names. This is used merely to put the name of the month on the Monthly Report. The other combo box chooses a number from 1-12 which is used in the first query below to choose the month for the query. This works fine, but makes the DB user use two combo boxes. Does anyone know of a way that they can just choose the month by name? Thanks in advance for your help.
SELECT MemInfotbl.ContribDate, MemInfotbl.ContribAmt, Month([ContribDate]) AS ContribMonth
FROM MemInfotbl
WHERE (((Month([ContribDate]))=[Forms]![Reportsfrm]![Monthcbo]));
SELECT Sum(Monthlyqry.ContribAmt) AS SumOfContribAmt
FROM Monthlyqry;
Hello,
I have made one form for report purpose. When I enter Start date and End date, I get report of the date range. What I am looking that I want to print the start date and end date in my report. How can I reference date text box in my report?
thanks
mithani
I have a report that, when closed, I would like to refresh the main form, or subforms in it (Whichever is easier)
Main form: frmMain
Sub form A: subWebLCSel
Sub form B: subWebPartSel
Report: rptLabels
I tried:
forms!frmMain!subWebLCSel.form.requery- told me it cant find the field subWebLCSel
Forms!subWebLCSel.Requery - tells me it cant find the form subWebLCSel
Any ideas?
Hey guys,
Any way in which i can create a report from a form ???
Hi,
just a thought i have just come up with, is is possible to have a print preview of a report on a form?
I was just wondering if it was possible to have record information on one side of the from and then a screen shot/ scaled down view of a report on the other. Would it involve the bound property object? Haven't done any research on the matter, just something that crossed my mind.
Any ideas wlecome
I have a form which records the progress of a complaint investigation. There are 3 reports I would like to run from this form using command buttons. They are report_long (shows all activity) report_short (summary) and logsheet.
The primary key is complt#.
How do I ensure that the complaint being printed is the complt# I have on the form?
I need help...
ok, what i have is a table with all the fields, comp_id, Yr,Values
i need to put 2 combo boxes coz the user needs to choose bet. 2 years and get the difference of the value within each yr. I got this part already but my problem is, i need to do a report and what i need to do is everytime the user chooses 2 yrs. the report should come up showing the difference of 2 yrs and the comp_id and type under each yr plus the difference of there values.
*note i already did the whole report including yr, comp_id,data_type*
Im just having a problem in the form structure..
am i exmplaing this clearly?
Pls help..thanks
I have a form that pulls a number of records from a number of different tables. I want to see basically the same information in a report. Is it possible to export the set up to a report so I don't have to build a report from scratch?
Thanks,
Kelly
I have a form where user enters begin date and end date and then he click view report button, but I cannot get it to do anything. I cannot figure out how to set up the button that it would read the two dates and open the report between twose 2 dates.
View 7 Replies View RelatedHello all!
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?
Many thanks.
Krava
Please bear with my ramblings, but I’m not sure what you may find relevant.
I am currently doing work for a service company where the employees are required to wear the company’s uniform. When someone joins the company they are required to purchase their own uniform. After a year, the company buys the replacement uniform. Each year on the anniversary date, the employee is given their annual evaluation. At that time they are given a requisition to go to the uniform supplier for new uniform articles.
Each item in the uniform has a life span. For example, shirts and pants are replaced each year, winter coats and spring/fall coats are replaced every three years, caps every two years etc.
I have a form which lists the item no., description and cost of each item and when they are due to be replaced. For example
Winter coat last replaced on 2003/11/10, replacement date is calculated to 2006/11/10
When this employee has his evaluation this November, he will be entitled to a new winter coat. The calculations are done by clicking an option button beside the item on the form. Clicking replaces the issue date with Date() and adds three years to the issue date using DateAdd for a new replacement date. Clicking the button also indicates that the item is to be replaced.
NOW, I have all this working.
What I would like to do is find some way of printing the requisition from this form before closing it. Something along the lines of:
If Option1 is yes
Print this item on the requisition
Endif
And do this on every item on the form, if it’s yes, print it on the requisition, if its no ignore it.
The option buttons are not part of the underlying tables or query only part of the form.
If I’m doing this backwards, please let me know. I’m well ahead of my deadline.
I have a form and the information on the form is displayed in a report so the user can print it out.
I have placed a command button on the form so that when you press the button you can print the report.
I was wondering if there was a way how i could just get it to print of the specific page i was on at the time.
Thanks for any help
Is there any way to embed a report in a form?
What I want to do is something similar to using a subform, but I want to use a subreport as part of a region of a form (linked by the master/child fields).
The reason for this is because it is impossible to draw lines on a form. I MUST be able to do so (I've been through all the API stuff and after 3 hours, I realize it's just not an option). I can easily get a report to look the way I want it, and I want to display the section that has lines in the report.
Yes, I realize that it's read-only; there will be another interface for getting the data in. I just want to display it graphically with connecting lines.
Thanks,
SHADOW
I had made my own database for my own business.
I am trying to print a report from a form. Once i enter an order detail i finish off by printing a letter. At the moment we are doing this via a query by entering the order id.
I want to automate this so for the form record i am in i want a button to print a report for that record only.
I know this can be done as i rember doing this in college but i cant get my head round it at the moment.
Please help
hi guys. i am currently working on an human resources information system. i am currently using ms access 2003 and the report form looks like this:http://i114.photobucket.com/albums/n258/lushh_16/reports.jpgthe function of this form, is once a button is clicked, the appropriate report for that button will be generated and will automatically be viewed in ms excel. the problem is that i don't know the VBA code that will perform this function. i read books about access, but unfortunately i can't find the exact answer to my question. so, if anyone could give me some idea on where i can find sample codes for this function, i would very much appreciate it. thanks in advance.
View 4 Replies View RelatedSo far this forum and everyone here has been a good help!
Now, I want to have a form with one button. (others of course but this one button is special) that when someone clicks it, it prints multiple reports at once.
BUT each report has a query obviously that searches out what records to pull between two dates. Now, ive somewhat tried this before but what ends up happening is when they click on it.. (there is 4 reports printing) it asks the person 4 times the dates its between. Which is a hastle and people would not be happy about.
What i want is when someone clicks this button, it comes up with one prompt. This promt will then print out the 4 reports with the date provided.
On each report im using the "between" statement in the query to pull results.
This is open to you! PLEASE help! Thanks so much,
Jon
I want to display Form and Report Simulteneously.
I am calling DoCmd.FormOpen in Open Method or Report.
I want report to be open and Dialog box should be sent back side of report.
Any help How to achieve that ?