Specific Record In A Report
Feb 4, 2008
Erm, hi this is my first post!
Basically im creating a db that the company i work for will use for invoicing creating orders storing the clients we have and so on. This is my first time using access and ive been working on this project for a few months so my vba knowledge is pretty poor to say the least.
What i need is for the orders form to view the current order i have open in report format. Everything on this order form works and is linked to the invoice report that i created, i even managed to get it to print the current report. I just cant seem to get it to view the specific order im looking at, ive tried loads of things from using my crap vba to queries..
Would greatly appreciate some help on this as my boss needs this db completed asap.
Cheers,
MarcF.
View Replies
ADVERTISEMENT
Feb 11, 2014
I can open a report right with a wherecondition that opens a report based on an agent name..
DoCmd.OpenReport "SelectPSReport", acViewPreview, , "[PS_Agent]='" & Me.CboAgt & "'"
But it returns every record for that agent and I want to be able to specify the date that goes with the name.
For example Tom has a record for Feb 10, Jan 10, and Dec 13. I only want to see the record for Dec 13.
I am able to see this in my form by having a combo box for the agent and the date (the date box being based on the agent box). So now how can I add a condition to include the date combo box?
DoCmd.OpenReport "SelectPSReport", acViewPreview, , "[PS_Agent]='" & Me.CboAgt & "' And [PS_dDate]='" & Me.Cbodt & "'"
Adding the condition gives me and type mismatch error, which I think may come down to the date combo box on the form having 3 columns (only 1 is visible).
View 12 Replies
View Related
Jun 9, 2014
I work in psychological testing and I have created a database to store some data for our patients' test scores. I have a main form with demographics and then 5 buttons on the main form that open into 5 other forms (one form for each test). I also have created a button on the main form to run a Report; however, I would like to filter the report to only show the current record (e.g., Patient ID #1 only).
(Can this be done?) How should I go about filtering the report to show only the open record? Expression is preferred - I'm not very good with code.
I'm also assuming that since each form is linked by the primary key of Patient ID, I should be able to see all data from each form (main + 5 others) in the report for that specified Patient ID... (?)
View 4 Replies
View Related
Oct 3, 2014
I have one table with some info about my clients, I have a form, where I must choose this clients from combobox and then after clicking button Print must open report with info about specific (chosen from combobox) client and some another texts that doesn't change. Final result must be printed report as invoice.
I can't create report with only specific record information.
View 5 Replies
View Related
Jul 23, 2013
I want to hyperlink from a query direct to the relevant record in a specific form. I have a hyperlink field in the form which shows up in the query. When clicked in the query, this hyperlinks to the form but I cannot make it select the correct record in the form.How do I get it to select the correct record?
View 3 Replies
View Related
Oct 3, 2005
Hello, I have just spent ages doing searches and reading everything I can on locking. But, I have yet to find an answer as to how I can lock a specific field in a specific record.
e.g. Staff enter customer details, then at the end of the day the admin (me) checks it over and presses a big old button that stops them from locking certain fields in the current record only - they must still have access to the unlocked fields of the current record, and it must not lock any other records.
I'm guessing there's some VB code in the form of fieldname.lock = true, but then it locks the field throughout the whole table!
Can anyone tell me how to do this please?
View 11 Replies
View Related
Jul 9, 2015
I am new to access i have a problem which is i have made a form which contains a subform and a read only subreport, what i want is the ability to select a record in read only subreport as in the picture attached and make a button that when i press on it, it should copy the values of the itemsID field, Packing field, ContainerNo field and origin field from the selected record and then paste them in the subform below.
Also i want to add more then one item, so the when i press on another record it should paste the values below the first record.
View 12 Replies
View Related
Nov 8, 2013
I have a continuous form for which the recordsource is a query that retrieves dates from 10 days in the past to 10 days in the present. I want the record with today's date to be at the top of the form. The record with the oldest date is always on top. Is this a scrolling issue? How can I get the record with today's date to appear on top?
View 5 Replies
View Related
May 12, 2005
DoCmd.OutputTo acOutputReport, "MD Form",".xls" "C:Documents and SettingsKevanAlderton.THERMOSHIELDDesktop", True
any ideas what is wrong ??
many thanks
View 3 Replies
View Related
Mar 21, 2006
Is there any way to put a shortcut on someone's desktop that will open a specific report in an Access database? I'm thinking back to the days of DOS when one simply added an argument to the command. I don't want to put it in startup and have it always go to that report. I just want non-Access users to go right where they need to without menus, etc.
:confused:
Thank you.
View 2 Replies
View Related
Jan 12, 2006
I'm having issues with reports. What I want to do is only print specific dates in a report. I have read and tried everything to accomplish this but it just isn't working. Any suggestions????????????
View 2 Replies
View Related
Feb 14, 2014
In the footer of my report I have a field that sums the Transaction Amounts - =Sum([Transaction Amount])
I would also like to break the totals down further by Transaction Type Codes.
Something like =Sum([Transaction Amount]) where Transaction Type Code = AL-Exp-Paid
View 4 Replies
View Related
Jul 7, 2006
I have a report with grouping on a code - I would like to do a page break on the second code - I don't know where to start on this.
View 1 Replies
View Related
Sep 8, 2014
I want to show ( or print ) on a report a specific URL on Google Maps with the ActiveX control "Microsoft Web Browser".
I managed to use the Google API on a form to show the actual URL found with X and Y coordinates.
Now I'd like to show the same URL on a report to send to the customer as a reference. Is there a way to get this done?
I already put a ActiveX control (Ms Web Browser) on a report and used the same URLstring in the ActiveX control , but nothing is shown on the screen.
View 7 Replies
View Related
Sep 5, 2014
I have report which record source is a Union Query, The query contain Order Details and a single row for "Freight Charges", I just want to set Freight Charges show in Report at last row.
View 3 Replies
View Related
May 20, 2015
I am trying to print a report for a specific Client. There are several routing records with dates. What I want to do is print the report for a specific Client that is in the primary table and a Date within the routing table. Each routing record has a Date field.
One client can have many routing records.
Example: John Smith in client
Routing record in the Routing table. I want to report on one Routing record with a specific date.
View 3 Replies
View Related
Apr 18, 2006
Hi
I need to print a specific form based on the selection made on a combo box.
I have been able to set it up to open the relevant form when the user selects an option from the combo box, but am unable to find a way to be able to print the specific report based on the selection.
I have a command button which prints a report based on the data in my current form, but would like it to also print the specific form based on the combo box selection.
Is this possible, and if so how is it possible?
Thanks in advance,
me
View 5 Replies
View Related
May 17, 2013
I have an excel spread sheet that is linked into access 2003 via a table. This spread sheet is updated by personnel in another location and I have to run a weekly report on engines stored in that table that are below a certain performance level. The column heading is MGT Margin and I have to list all of the engines that are below 20 degrees. Can I run a query that looks at this table and produces a report of all the engines that are only below 20 degrees? I currently have to cut and paste each engine from the updated spread sheet every week onto a separate spread sheet and import that into access to run the report. Can a query be used to run the required report? I have attached a screen shot of the query that I am putting together to try and run this report.
View 5 Replies
View Related
Feb 13, 2015
Actually I need to select printer before printing report. That's why I need to call printer dialog to select printer using "PrintObject" in macro. But it's print the form not report. I need to print a specific report.
View 1 Replies
View Related
Mar 3, 2005
Hi,
Does anyone know some code that will take me to the record whose field "A" has value "B"?
It sounds very simple but I can't find anything the does it!
Basically I have a table or enquiry records, some of which are related. I just want to be able to click on a button to take the user straight to the related record. The current design does this using a filter but this is pretty rubbish as it meanhs that in order to search on all records I need to select all records again first.
View 1 Replies
View Related
Sep 29, 2005
The following is a function in my Form "Enter"
--------------------------------------------------------------------------
Private Sub PoNum()
Dim strForm As String
Dim strwhere As String
strForm = "GoodOne"
strwhere = "[Forms]![GoodOne]![Orders3].[Form]![PO_Num] ='" & txtPO & "'"
If [txtPO] <> "" Then
If DCount("[Po_Num]", "Orders", "[PO_Num] ='" & txtPO & "'") = 0 Then
MsgBox "Sorry, No record matched"
txtPO.SetFocus
Else
MsgBox "yes"
DoCmd.Close acForm, "frmPopUp"
DoCmd.OpenForm FormName:=strForm, wherecondition:=strwhere
End If
End If
End Sub
------------------------------------------------------------------------
"Orders3" is the subform of Form "GoodOne" .
When the user enter the PO Number in txtPo, and press "ok" , it will go to
that record.
BUT it just show a new blank reocrd instead.
What's wrong with the programme ??? (is it the matter of subform ?)
Thanks
View 3 Replies
View Related
Jun 2, 2015
I want to create a Macro saves the report in a specific location, and uses two fields within the report to generate the name of the file. For example, "[Sales Rep Name] + [PayPeriod].pdf" and it should be saved in a predetermined folder.
View 1 Replies
View Related
May 14, 2013
I have a table that is linked into access 2003. This table is updated by personnel in another location and I have to run a weekly report on engines that are below a certain performance level.
The column heading is MGT Margin and I have to list all of the engines that are below 20 degrees.
Can I run a query that looks at this table and produces a report of all the engines that are below 20 degrees?
I currently have to cut and paste each engine from the updated spread sheet every week onto a separate spread sheet and import that into access. If a query can be used to do what I am after I can use similar principles in other reports I have to run.
View 5 Replies
View Related
Jan 13, 2014
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.
View 2 Replies
View Related
Jul 30, 2013
I have a form which runs specific queries and opens a report using combo boxes, these work perfectly fine if I just try to run them in the form. I have put the form into a navigation form and if I try to run the same query I get parameter queries popping up instead of just running the query and opening the report.
View 2 Replies
View Related
Oct 23, 2014
I'm trying to have users enter multiple IDs from a table into a text box separated by newline chars, and then (once they press a button) have some sort of macro or code read each line and pull a report I've created based on the ID. Is that possible?
Example:
Table
ID
DataPoint1
DataPoint 2
DataPoint 3
1
d1
d4
d7
2
d2
d5
d8
3
d3
d6
d9
Text Box (User will enter values and hit OK)
2
3
Report
ID: 2
DataPoint 1: d2
DataPoint 2: d5
DataPoint 3: d8
-------Page Break------------
ID: 3
DataPoint 1: d3
DataPoint 2: d6
DataPoint 3: d9
View 2 Replies
View Related
