I have 3 dynamic combo box. a combo box > filters b combo box and b filters c combo box. showing the field names whereas connected on field ID's. But my problem is when I am running reports (reports in form of charts) on the data saved in the backend through these combo boxes on the form. When I run report it shows ID's of combo box B instead of field name.
View RepliesI have a report in which a textbox generates numerical values and letter values. I want to...On report load - if textbox = numbers then hide otherwise show if it contains letter values.
View 9 Replies View RelatedHi all,
I have an INSERT INTO query that inserts multiple records in an excisting table.
What i need is a functionlity that fills a column called, lets say 'myID' with a query-unique increment.
So, when the query inserts 50 records the ID should increment from 0 to 49.
The next time i might insert 23 rec's and then the ID column should go from 0 to 22.
I tried to call a simple VBA function in the SQL query that returns i+1 and increments i, but that code is only evaluated once every run, so that doesnt work.
any suggestions? maybe in SQL or VBA
Thanks alot!
remvs
I have a label on a form with text including the word "generated".The funny thing is when I switch from Design View to Form View generated becomes genneerraat :eek: :confused: It's easy enough to use a different word but there's obviously a problem somewhere and I'm worried that Access might make a mess of other words too.Anyone have ideas what's going on here?Addition: No matter what words I use, the last 10 or so characters of the text in the label is changed when switching views. I have been playing around with the text a bit more and it appears that the character & is the source of the problem. When I delete the &s everything looks fine again. Anyone care to comment?
View 3 Replies View RelatedI made a report that have 'txtRemarks' field, I just want to get remarks automatically in 'txtRemarks' field based on the other field in report. that is why I used a function like below:
Code:
Private Function Estd_Remarks(Estd_Point As Long) As String
If Me.Estd_Point < 20 Or Me.Estd_Point = 0 Then
Estd_Point = "Earlier Established"
Esle
Estd_Point = "OK"
End If
Estd_Remarks = Estd_Point
End Function
And I wrote in properties 'On Format' event this code below:
Code:
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If Estd_Remarks = "Ok" Then
Me.txtRemarks = "Ranked & Sortlisted"
Else
Me.txtRemarks = "Estd_Remarks"
End If
End Sub
When preview the report then it shows
Compile error
Argument optional
I have a report that is looking up min and max quality specifications for a product. The table with the specifications has a Yes/No check box field for when the specs are defined as "Internal". So the table looks like Product/MinValue/MaxValue/Internal
I want the report to display "TEST AND RECORD" when the Internal box is checked where the MinValue and MaxValue (that are stored in the table) would be displayed otherwise.
I am working on a report and have found a problem. I have a field called "region". The data is geographical and is basically stuff like "southeast", "mid-atlantic", "southwest", etc. I reference this field in the report but the report shows the ID field of the table where this data exists, rather than the data in the "region" field. So, instead of "southeast", it shows "3".
View 12 Replies View RelatedI created a report based off of several tables and queries. Now I need to go in and add another field from different table. The item is not on the field list and trying to edit the expression doesn't seem to be working. Any suggestions?
View 1 Replies View RelatedI have a field in a report that is calculated to generate a dollar amount. Well the people who need this have some strange rules about how they get their dollar amounts. Mostly they just round up to the nearest dollar, which is no problem. But they also want a minimum charge of $2.00. So my problem is if the calculation works out to be 0.01 to 1.00, it will say 1.00 and it is going to be wrong because they will want it to be 2.00. So is there a way to set a minimum value for this field, or where should I go to try this?
View 4 Replies View RelatedHi. I have a calculated field in a form. I wonder if the result could be shown in a report?
The form field determines an age category based on date of birth entered. The expression in the form field is
=IIf([child age fall]<=1.49,"Infant",IIf([child age fall] Between 1.5 And 2.49,"Toddler",IIf([child age fall] Between 2.5 And 4.99,"Preschool","")))
Is there a way to have this result show in a report? Thanks.
How do I set a field to NOT display in a report if the field is empty? Thanks!
View 4 Replies View RelatedI am using this code on a button, to print a report:
Private Sub buttonPrint_Click()
Dim P1 As Integer
Dim R1 As Integer
Dim stDocName as String
R1 = MsgBox("Print;", vbYesNo)
If R1 = vbYes Then
If stDocName = "FIRST REPORT" Then
P1 = MsgBox("Printing options;" & vbCrLf & vbCrLf & _
" YES: Option 1" & vbCrLf & vbCrLf & _
" ΝΟ: Option 2", vbYesNo "Printing Options")
If P1 = vbYes Then
DoCmd.OpenReport stDocName, acNormal
End If
Exit Sub
Here is the difficulty I need help to overcome:
In report "FIRST REPORT" there is one field called txtSet1, Boolean.
Can I set the value of this field to either True or False from this point in my code ?
If P1 = vbYes Then
set Reports![FIRST REPORT]!txtSet1.value = True
DoCmd.OpenReport stDocName, acNormal
End If
Exit Sub
I know that the answer is NO because the above does not work. I think the problem is that because the "FIRST REPORT" is not opened until line
DoCmd.OpenReport stDocName, acNormal
is executed, the line
set Reports![FIRST REPORT]!txtSet1.value = True
can not find "FIRST REPORT".
Can I have some guidance please ?
Rgds
Hello!
I have a report with a field that returns data according to a date that the user enters when he opens the report for viewing (this is based on a parameter query). So for date 1 you have let's say 10 names and for date 2 you have 5 names. Now here is my question:
How do I create a box on the report wich returns a count of the names field? So for date 1 it should return the number 10 and for date 2 return 5. I don't particularly want to have this in the query but would prefer to have this just on the report...
Can anyone suggest a solution?
Thanx
I need to count a yes/no field. If the check box is checked I need it to count the checkmark. If it is blank I don't want it counted.
I am trying to put a calc in the Group Footer because I want it based on the group of checks for a certian person.
I know there has to be a way to do this and I am just not figuring it out.
Can someone lend me a hand is getting this going.
Thanks
I need to have a field show up in my report that is unrelated to all the other information in the report. It is a one-time entry that the person enters upon opening the database. It's basically the expected amount of work we'll be doing for the year. I need to display that at the top of my report and then utilize that number for calculations with other fields in the report to produce a couple of extra calculated fields in the report. I've tried it a few ways and I've either gotten #name? or #error.
Any ideas?
I have a lookup field in my table - when I try to create my report, it lists all of the data in the lookup list - I just want to display the one that is stored in the table.
How do I do this?
I have a listbox on a form that fills. It shows the field Keyword.
I use the rowsource to drive a report.
Me.LP1.RowSource = "SELECT TXMASTERS.Barcode, TXCLIPS.NNAME AS Name, TXCLIPS.Comments, " _
& "TXCLIPS.Start AS TimecodeIn, TXCLIPS.Duration, TXMASTERS.SportorSports AS Sport, " _
& "TXCLIPS.StarRating, TXCLIPS.Shot, KEYWORDS.Keyword, TXMASTERS.SeriesName AS Programme, " _
& "TXMASTERS.EpisodeTitle AS Episode, TXMASTERS.Competition" _
& " FROM (TXMASTERS INNER JOIN TXCLIPS ON TXMASTERS.ID1=TXCLIPS.ID1)" _
& " INNER JOIN KEYWORDS ON TXCLIPS.Comments Like '*' & KEYWORDS.Keyword & ' *' " _
& "WHERE TXCLIPS.NName Like '*" & Replace(Me.LNAME11.Caption, "'", "''") & "*' " _
& "ORDER BY 1, TXMASTERS.BARCODE, TXCLIPS.Start"
On the report I have a textbox, with its source set as Keyword. However the box does not get filled.
I call the report from the form with:
DoCmd.OpenReport "COMPETITION", acViewPreview
In the report I have:
Private Sub Report_Open(Cancel As Integer)
DoCmd.Maximize
Me.RecordSource = Forms!Newqueryform3!LP1.RowSource
End Sub
Any help greatly appreciated, thanks
[URL] making text boxes visible or invisible on a report depending upon criteria selected on a criteria form.
* I have a form [Frm_REPORT_Parameter_01] which has is a criteria selection menu related to a report. Among other criteria, is a combo box [CboGrade] which has the following options to select from "All", Excellent", "Good", "Fair", and "Poor"
* I have a report [FacilityIdentityReportDR]
* On this report, I have a trext field [TxtConditionHdr] that I want to make visible or invisible depending on what is selected in the form as criteria.
* I have a query [QryRPTFacilityIdentityRating01d]
The form criteria feeds the query that is the source for the report and the VBA coding behind the command button of the form is below. I have bolded my vba coding attempt to make the text field visible or invisible.:
Private Sub Command22_Click()
Dim strCrit1 As String
Dim strCrit2 As String
Dim strCrit3 As String
Dim strCrit4 As String
[code]....
I am creating a student database for our instructors to track attendance and grades. The grades will be printed out as a progress report / student transcript. In order to comply with our accrediting agencies, I must calculate the units of study credits (two separate columns) and have the total Credits round down to the .5
So for example: column 1 = .40 , column 2 = .30, Total = .70 but the rounded down total would be .50
This is the Excel formula used to get that calculation =FLOOR((E11+G11),0.5) How do I create the expression to do the same in my report in that field?
I'd like to add a customer type field from my 'Customer:Table' to my 'Customer Balance Report' Also, I need to create a validation rule in my table specific the legal values of SAL, SPG and WMN in my customer type field. with validation text, which I'm not sure how to do.
View 2 Replies View RelatedHi All,
I've attached a picture which shows the problem.
I need to know the expression required to transfer the name of a football team (selected on a form with a combo box) onto a report.
The teams all have ID numbers, and so far its the ID thats getting transferred, not the team name.
Any help is appreciated
Thanks
Colin
I have a database that I converted to an .mde and I then distributed it using the 2003 Developers Extension Tools Packaging Wizard. So it is being accessed using a runtime version of Access 2003. On one of the reports, I am concatenating two fields, [LastName] and [FirstName], from the underlying query. When the end user tries to preview the report, #error# shows up where the concatenated field is. When I view it using a full version of Access, the field shows as it should. Can anyone give me some direction as to how to fix this problem? Thanks.
View 2 Replies View RelatedHi,
I am new here, so any help would be greatly appreciated.
I am running MS Access 2000 with MS Office update pack 3
I have written a custom application that uses time fields in Medium Time Format to do some time calculation.
In every other part of this application, the Medium Time format shows correctly as Medium Time Format. In the Report, the field shows as 12:00:00 PM. Is there any way to remove the seconds?
Please note that this data is being used in a string that contains other data fields and quoted text as well.
Any help would be greatly appreciated.
Thank you,
Brian
Hello I am trying to design a CD label 'report', it's going well except that the title field of our productions has to print with quotation marks around it'. The name of the field is, yes you guessed it, TITLE. I know it must be a simple solution but I'm at a loss to find it or understand it. I'm just a dumbo. Thanks for your time and expertise.
View 2 Replies View RelatedI know its probably a simple one but I am new to access, so...
I have a simple membership database and in it I keep a record of who I am expecting to attend on a particular date. This is achieved through having a seperate field for each meeting on a simple yes/no type.
I would like to be able to print a report from a form for a particular date showing everyone that would be attending. I have a list box that shows all the fields. What I cant do is set the date I want in the query from the report, can anyone help?
thanks
I have a form that runs a report with two text boxes, one combo box, and a button.
The text boxes hold dates and SQL feeds them the oldest and newest dates from their fields (Date Received and Date Taken). They work fine, when the form is opened, the fields are filled and if I change the dates, the report pulls back data from the correct range.
The combo box is called Analyst Name and this is the row source within the parenthesis (SELECT [PickList-AnalystName].ID, [PickList-AnalystName].[Analyst Name], [PickList-AnalystName].[Analyst Manager] FROM [PickList-AnalystName];). The bound column is 2. The correct names are displayed, it looks like it works fine but then there's the button.
The button is named cboAnalyst. Enabled - yes. On Click - Event Procedure. This is the code with the backslashes added:
option compare database
//Private Sub cboAnalyst_Click()
Dim strCriteria As String
If IsNull(Me.[Analyst Name]) Then
strCriteria = ""
Else
strCriteria = "[Analyst Name] = "" & Me.[Analyst Name] & """
End If
DoCmd.OpenReport "Ad Hoc Reporting", acPreview, , strCriteria
End Sub
If I run this without a name, I get back all of the data within the right time frame. Once I put a name in, the report comes back empty, showing 0 for the count. I don't even get an error, I just get that empty report.