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.
In the report I am trying to generate I want every possible option for a specific field to show. I have it set up now as accessing its options from a table but can change it to a value list if that will be easier. I have listed a sample of what I want and what I am getting to explain what I mean by this. If anyone can help me go from one type to the other I would appreciate the help!
** I put dashes between the columns since this forum doesn't exactly show things in a column.
What I want
Locality-Count1-Count2-Count3-Count4-Sum
1-0-0-2-0-$23.34
2-3-2-8-1-$845.36
3-0-0-0-0-$0.00
4-4-2-0-0-$40.12
5-0-0-0-0-$0.00
6-0-0-0-0-$0.00
What I get
Locality-Count1-Count2-Count3-Count4-Sum
1-0-0-2-0-$23.34
2-3-2-8-1-$845.36
4-4-2-0-0-$40.12
Hello,
I need help with something (i attached a database).
I need to run a report based on user's options so i created a form. There are two comboboxes and 2 checkboxes on the form. If the checkbox is checked i want to consider the choice of the user on the particular combobox. If no, to ignore that column.
The second problem is when the user choose "no choice" i want the query to run for all choices without filtering the combobox.
Any suggestions?
Thank you in advance.
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 Relatedhow can open a report using 2 unbound textbox on a form as user input date criteria
View 2 Replies View RelatedI have a Table with Emp_ID and Details of my Employees. I have created a query and set parameter [Enter Emp_ID]. When I pull up a report, I get a pop-up and it asks me for the Emp_ID. When I input same, I get the information I need. Everything is good so far...
My Question... I have designed a report when user will need to enter Emp_ID and click on a button and they will get the report "EMPReport" without having the pop-up window asking for EmpID.
I have been using the below code but I get the pop-up again and I need to enter the Emp_ID again to view the report
See below Code:
Code:
Private Sub Image11_Click()
If IsNull(Me.Emp_ID) Or Me.Emp_ID = "" Then
MsgBox "You must enter an Emp ID.", vbOKOnly, "Required Data"
Me.Emp_ID.SetFocus
Exit Sub
End If
DoCmd.OpenReport "Rpt_HR1", acViewPreview, , "[Emp_ID]= " & "" & Me!Emp_ID & ""
End Sub
I have a report that is based on a query. The query has filters in it based on user info entered from a form. So the form asks the user to select which division of the company, and the date range for when the info applied to. My issue is that I am trying to set a macro that opens this form whenever some tries to open the report.
But the macro appears to run the query before it opens the form and it gives me a generic message box asking for the division. After I type that in (instead of selecting from a drop down list like I have on my form) another window pops up asking for start date, etc...instead of opening the form I created. What am i doing wrong and how do I get the macro to open my form? If I open the form directly and enter the criteria, it runs the report correctly.
I want to open a report with the results from a filtered form.
I want to use a similar format to the attached Allene Browne search2000 as the base to filter the records initially, but not sure how to get the filtered results into a report and the most efficient way.
I am trying to open a report (rptGMX-IRG) that includes a sub-report (srptRG) based on criteria that is set with two unbound fields on a form (frmGMXbook). This form has two dropdown boxes (cboGMX_No & cboMachSize) and a command button. The first dropdown box includes data located in the main form and the second dropdown includes data that is part of the sub-report.
I can get the report to open properly when I enter data into both fields on frmGMXbook.
However, the problem I am having is the inability to have one or both fields be "Like '*'" and show all associated records.
Here is the code I have on the command button.
Private Sub GMX_Preview_Click()
Dim strCriteria As String
If IsNull(Me.cboGMX_No) Then
strCriteria = "[cboGMX_No] Like '*'"
Else
strCriteria = "[GMX_No] ='" & Me.cboGMX_No.Value & "'"
[Code] ....
I have just noticed when I open one of my forms . the database window becomes inactive and I cannot open another , form , report etc.
View 2 Replies View Relatedi want to open a report but only showing the result of one record in a sub form,
i have a field that is on all rows of the subform,[click to run] and what i want the user to be able to do is double click on this field and it will open the report with only the record information for that row displayed.
I'm trying to use a command button in a form to filter and open a report. I am able to get it to open the report, but I cannot get it to filter the report based on a combobox in the form. I've tried every combination of code I could think of and find. Here is what I currently have:
Code:
Private Sub FilterReport_Click()
DoCmd.OpenReport "Report", acViewReport, "First Name='" & Me.FName & "'"
End Sub
Code:
Option Compare Database
Private Sub Report_Open(Cancel As Integer)
Me.RecordSource = Me.FName
End Sub
"FilterReport" = Form Button
"Report" = Report
"First Name" = Report Field
"FName" = Form Combo Box
This is my data:
Table: "Facility Info"
Data in the table: "facility", "city", "date", etc.
Query: "Q Facility"
Report: "R Facility"
Form: "Main Form" is where the data is entered that goes into the "Facility Info" table.
In the "Main Form" there is a dropdown box where I can select the "facility".I would like to add a button to this form that opens my report "R Facility". But this report is a collection of all the facilities and I would like it to just report the ones for the facility that I selected from the dropdown box on my "Main Form".
I 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 am a bit of a beginner to Access 2003, and I would appreciate any help you can give me? :)
I have a drop down box on a form in Access 2003 with several options when an option is selected from the first drop down I would like a sub catagory of the selected drop down option to appear in the second drop down menu.
For example:
First drop down Hair, Clothes,
If you select Hair it then give the products relating to hair which need to be choosen in the second drop down menu.
I hope this makes sense.
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]....
I would like to put a query into my form so that I can look up a part number, order number, or both, and then open the form for editing. I set up the queries but can't get them into the form. How would I go about doing this? Thanks for helping out
View 2 Replies View RelatedI would like to put a query into a form so that I can look up a part number, order number, or both, and then open the form for editing. I set up the queries but can't get them into the form. How would I go about doing this? Thanks for helping.
View 3 Replies View RelatedI am trying to make a form that will allow me to make several selections and run a report. I want to be able to select from a list of Grade Levels, 9th, 10th, 11th and 12th. After I have picked my grade level or selected more then 1 grade level I want to be able to choose from a drop down list of school district. After I have chosen my grade level and my school district I want to run my report. How do I do that?
View 2 Replies View RelatedWhat I am trying to do is create a form with 2 drop down boxes (A,B,C,D) &1,2,3,4...) what I want to do is make it so if you select option A in the first box only 1,2&3 are available in the second box but if you select option B 3,4&5 will be the only options available.
View 1 Replies View RelatedHi All,
Another totally newbie question here but I'm still trying to figure a few things out. Leave it to me to dive head-first into something without first doing research.
In my database I have a main form where I enter records for customers. Now, I also have a second form that is used to search for records. In this second form I want to be able to first filter the record search with a drop down menu that searches by items such as address, customer name, or city, etc. That way if the person doing the search doesn't know the name of the person they can search by address or vica versa. Once the user selects the search type they enter the name, or address, or whatever they're basing their search on and then click on a "Search" button. I have this button working so that it opens a report with a table which shows all the records pertaining to that search.
My first question is how can I get this to work properly because right now I keep getting the results of past searches, in fact I think it gives me all the records rather than the ones I want.
Once I figure this out, with your help, I'll have another question for you. hehe
Thanks in advance for any help you can provide.
Id like to create a search field on a form, with a similar function to the standard Access 'find and replace' function. Only id like it to be alot more simple than the Access find and replace form.What i have is a Asset DB for the IT assets in the company i work for. We have a lot of phones, printers, computers and about 120 Laptops. The laptops are quite often reconfigured and given to new users, so the laptop details dont change but the user and software config does. I need to keep track of what software is installed where, for licensing reasons.
What i have is a simple form with the laptop name, serial number, operating system, software, location etc etc. What i would like to be able to do is, type a laptop name into a Txt field, hit a search button, then have the fields of the form populated with the laptops current config and then be able to edit the details from inside the form. ive tried using a combo box but i have more than 20 fields that need filling, so anybody whos used the 'me.txtboxname.value = me.combobox.column (1)' may know that you can only use 20 columns.
The default Access 'Find and Replace' system works fine but i dont want users to have to use it. I also dont want them to have to navigate through records using record selectors.
I am using Select Case to filter a form on open and it works fine when I have this:
Code:
Case Is = 2
Forms![Open Opportunities List].Form.Filter = "[Employee] = 4"
Forms![Open Opportunities List].Form.FilterOn = True
But if I want the form to open filtering multiple employee records, like this:
Code:
Case Is = 6
Forms![Open Opportunities List].Form.Filter = "[Employee] = 2 & " And 9 & " And 10 & " And 11
Forms![Open Opportunities List].Form.FilterOn = True
I get a type mismatch error and I am stumped as to why and how to overcome.
How to set all controls in the form I would like to get complete information about all property options.
View 6 Replies View RelatedI'm a new user of Access and I'm required to input a survey into access. The data collected is being analyzed afterwards and therefore there cannot be any alpha content in the original table so I assigned multiple choice options numbers to correspond to the answers. In form view however I need the drop down boxes to spell out the answers, not just the numbers so the interviewer can read them out, I've seen this done on other similar surveys..I also tried going into form view and editing the drop down choices but that changes the table values.
View 1 Replies View Related