I created a simple form that has a dropdown of all the reports that a user can select. I am using the following command;
DoCmd.OpenReport "rpt_Roadshow2", acPreview, , "RoadShow.RSID = SelectSymbol.Column(0)"
Where SelectSymbol is the name of the ComboBox and Column(0) is the first column of that data field. When I run it I get
Run Time Error 3085
Undefined Function 'SelectSymbol.Column" in expression.
Seasons Greetings to all.. I hope you didnt put on too much weight.
The fog at Heathrow ensured I had a very stressful Christmas.. but thankfully it has gone for now.
i have a question regarding choosing a report to open based on a combo list..
i have a field called jobtype..
this field will always have either
"CASH" or "ACCT"
i have 3 separate report designs.. 1 design for cash jobs, 1 design for acct jobs, and 1 deisgn for both jobs.
i want a form that will allow my user to choose which report to look at..
lets call it form1.. i want to place a combo on my form (combo1) that has the values..
CASH
ACCT
BOTH
i realise that in my report query source.. i can use the following as the jobtype criteria
[Forms]![form1]![combo1]..
Question
I need the combo to realise that if the CASH value is selected.. it should open the CASH report..
if the ACCT value is selected.. it should open the ACCOUNT report..
and finally if BOTH is selected then open the BOTH report..
how can i do this?
I am struggling to pull out a report based on the combo box selection. I have NOI database and want to pull out a report for a specific customer that how many NOIs are generated by this customer..
I have a separate table of customer and another table of NCRs and the customer information comes from customer table.
I have tried the below statement but gives me an error message:
code for Macro that pulls the report in click event:
[CustomerName]=[forms]![CustName]![combocust1]
do i need to mention the report as well in some where in report ?
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 RelatedI have a report based on a query that has data for many dates. At the moment I have put a specific date in the criteria of the query so that I could build the report format. So it now displays all the data for the date i have in the criteria section. I will need to run this report several times per week so the specified date (and corresponding data in the report) will need to be changed to a new date when I open the report i.e. when I open my report I want to show data in the report only for a specified date.
Can I create a date parameter box open up when I open the report? Can I create a form with a button that when I click will open the report displaying data for that date? What would be the best way?I also need to display the specified date on the report.
I have a form with 7 List boxes linked to 7 Query's which in turn are linked to a table. Each list box if for a particular trade.
I am trying to select a person or persons from each List box and then have them sent to a report. I have Code to do one list box, but do not know how to link all boxes with code to a 'Open report' button.
The code I am using is as follows:-
Private Sub cmdOpenReport_Click()
On Error GoTo Err_cmdOpenReport_Click
Dim strWhere As String
Dim ctl As Control
Dim varItem As Variant
'make sure a selection has been made
[code]....
Hello friends,
I would like to add a cmdbutton on a form to view a report.
This report should also include the last modified data of my form. Is it possible to see the data without closing the form?
Or perhaps there is a solution like close the form and open the report (it will use the field SSN as PK) of the last modified (or viewed) recordset?
Any help or code will be appreciated.
Thank you.
I have an Access 2003 database that has a report which prints to the default printer.
We recently replaced the printer and now we cannot open the report in either design or preview.
How can I resolve this problem??
Many Thanks,
DL
This keeps happening to me. I am tired of importing from a backup and making modifications. My report won't open in any view. I double click on it in the db window, and nothing happens. It does the same when I try to open in design view. Have any of you ever had this proble,? What should I do?
KellyJo
Hi all,
The title says it all; how can I make a form appear when something is selected from a combo box?
Thanks in advance,
Atholl
Hello all,
Please help with this:
On opening my database, I have a switchboard that opens up.
How do also run a report automatically just after the switchboard screen opens. To make the switchboard open when I click on my database, I went to tools..> startup. But I don't know how to run a report automatically after that.
Thanks for your help!
I have several reports that open from a Form. All but one of the reports have menu bars on them...one report does not. I've looked at just about everything and I can't figure out what's causing that. Actually, I really don't need the Menu bar on the Reports, so I would like to remove the others.
I've attached a copy of a cut-down version of the file so that you can see what I mean. The file will open up to the Reports. There are two reports listed. The "New Releases" does not have a Menu Bar and is what I want. The "All Movies" has the Menu Bar which I want removed. Can anyone tell me why one has it and the other does not?
Thanks!
I have a list box which contains different types of log entries. Each different log entry type has a different report that goes with it.What I want to do is select an entry in the list box, and click on print, email, pdf or view report buttons, and the appropriate happens, selecting the associated report for the log type automatically.I have a table with the logtype in it, and against that I have a DefaultReport field, which contains the name of the report that needs to be opened for that logtype.
I am getting the correct name for the report no problem at all, I have made sure that the name is right by going to rename report and copy and pasting it.When it goes to open the report I get an error message - Run-Time error 3071, the expression is typed incorrectly or is to complex to be evaluated.I have a debug line running to make sure I am pulling back the correct report name and I am.I have tried putting the dlookup where the report name would normally go in the docmd.openreport and I have also tried using ReportToView as a String and putting that in the docmd.openreport, but to no joy.
I have tried it with and without " around the report name and still no joy, either in the table or by concatenating the dlookup with Chr(34) at either end of it, then it comes up saying the report cannot be found.
I have created a combo box with the values I need from a table. Once I select the correct record from the drop down box I'd like to be able to open the table with just that one record being displayed. Thanks for your help.
View 3 Replies View RelatedI have a form with a subform which has a lookup table (combo box) as a field. I want to be able, when I select a certain item in the lookup to have it automatically open a form. e.g. A field called insurance class - I select motor, I want the motor details form to open. If I select Fire, I want it to open the fire form and so on. I have already created the forms. Please help!
View 14 Replies View RelatedHello,
Please help, I am still kind of new to Access. My problem is. I need to be able to open a form from a selection of a combo box. Thank you in advance.
Hi,
I have created a combo box that allows the user to select a particular customer from the drop down list. I have managed to type in some code that opens the customer form after the user selects a customer, but how do i get it to open the customer form on that particular record selected by the user????
Thanx
Hi I've tried to find an answer to this but having no luck.
I have a form that has two combo boxes the first box looks up the year from the project table and the second box the project number. I want to open the project details that correspondes to these two input values within the combo boxes by pressing a command box.
I've tried the following but just get a syntax error:
Private Sub cmdOpenJobDetails_Click()
On Error GoTo Err_cmdOpenJobDetails_Click
Dim strDocName As String
Dim strYear As String
Dim strJobno As String
Dim strFilter As String
strYear = Me.cmbYear.Value
strJobno = Me.cmbJobno.Value
strFilter = "Select [tblProjects].[intprojectyear], [tblProjects.[intprojectjobno] FROM [tblProjects]" & _
"WHERE [intprojectyear] = & strYear And [intprojectjobno] & strJobno"
strDocName = "frmProjectDetails"
DoCmd.OpenForm strDocName, , , strFilter
Exit_cmdOpenJobDetails_Click:
Exit Sub
Err_cmdOpenJobDetails_Click:
MsgBox Err.Description
Resume Exit_cmdOpenJobDetails_Click
End Sub
Is it possible to open a pdf file that has been saved on a server?
What I have is a table that lists all of the files that have been saved to pdf. There is a column in that table that lists the exact path and file name. There is a combo box on a form that lists those file names. I need to know if there is VB code that will use that specific file name listed in the combo box and open (to view) the pdf file on the server.
Thank you so much for any help and insight provided.
I've got a combo box on my main form which lists different contractors. I've also created a command button on the main form which opens another form and allows the user to add another contractor to the contractor table which populates the contractor combo box on my main form.
However, when the user has added a new contractor and closed this form, this new contractor doesn't show up in the combo box until the main form is closed and reopened.
Is there a way to update the main form without closing and reopening it so that it shows the new contractor in the combo box?
Thanks in advance!
Im using the below code to open a from depending on what option is selected on a combobox.
Code:
Private Sub DirectPCombo_Click()
Dim cboVal As String
Dim stDocName As String
cboVal = Me.DirectPCombo.Value
Select Case cboVal
Case "One"
[code]....
If you select the first item [One] it will open the correct form [TestOne]. But when you select any of the others an error comes up saying that the name is no a form. So I added
Code:
DoCmd.OpenReport stDocName
But the no items would select.I know If split the reports form the forms and make two comboboxes it would work, but it would be better it both could be in the same combobox.
Good morning All,
I have a form with a command button to open a report ( based on a query ) for the currently displayed record. here is the code I have used:
Private Sub CS_notes_Click()
On Error GoTo Err_CS_notes_Click
Dim stDocName As String
stDocName = "InternalSNwithRMAprodMASData"
DoCmd.OpenReport stDocName, acPreview, , "TLAUnit = " & Me.UnitSN & "'"
Exit_CS_notes_Click:
Exit Sub
Err_CS_notes_Click:
MsgBox Err.Description
Resume Exit_CS_notes_Click
End Sub
I believe this came from this forum sometime. When the button is clicked I receive the error:
"Syntax error (missing operator) in query expression '(TLAUnit = 26712B')'
TLAUnit is the report field, UnitSN is the form field.
Any help with the error?
Thanks
Kevin
I hae a button on my form to open a report. However, I get all the records in the database when I only want to see the report with the current record from the form on it. How do I narrow my report?
View 9 Replies View RelatedI have a form with three combo boxes and am looking to open a report based on the choices they make. After each combo box is selected a query is run that makes a table based on their choice. I want to be able to use the appropriate table, without having to set it each time. The data displayed is going to be the same on the report just different data. Any help would be greatly appreciated.
Thanks
Bobby
hi...
firstly, i created some report based on query. then in my form i create list and combox to list down all primary key that had in query..
what i want to do is open report, based on criteria that i selected from combobox or list box...
i create both cbo and list box to compare which 1 is better... but both not working. i mean it works but not show the data as i want to. it open / list all data at report..
i use this code but nothing happen :
for listbox;
StCriteria = "[ID]=" & "'" & ListCustomer.Column(0) & "'"
DoCmd.OpenReport "Invoice Print", acPreview, , StrCriteria
and Cbo;
StrCriteria = "[ID]=" & Me.[cboCustomer]
DoCmd.OpenReport "Invoice Print", acPreview, , StrCriteria
plz help me..i dunno what to do.. :confused:
it works but not correct
I need to create a form that will open up to a report. the form is going to have two options.
one option will open up a report that will show all candidates submitted
the other option will open the same report but only show the candidates that have not recieved a no from the employer.
does anyone know what type of coding will need to go into this and how to go about it.
any help would be greatly appreciated.