mcupito
Last Activity: Aug 27 '14, 07:15 PM
Joined: Aug 20 '13
Location: Cincinnati, OH
-
Thanks for the reply, Stewart. I will take a look at your first example. I think that is closer to what I may need. -
Unfortunately not, because of user specifications. The Pivot returns data exactly as I need it to. It's just accommodating the differences in dates to be dynamic that is going to be the issue.
I would almost rather see if the user would accept an Excel output over something like this, unfortunately.Leave a comment:
-
Jim, thanks for your answer.
I had pondered some of the things you mentioned from doing research before asking.
Is there a way to create and run the report at run-time? That way it has only what it needs, without additional formatting/hiding columns? Similar to what the Report wizard does?Leave a comment:
-
Crosstab Report with Dynamic Columns
Suppose I am trying to show data for years something occurred.
Data, in the table, might look like:
When I go to create the report using a query that pulls this data (using wizard), it asks me if I want to add all of the fields, which I do.Code:Event Year 1 2007 1 2008 1 2009 2 2009 2 2010
However, If I were to close the report, and additional... -
So if I am just trying to run a query (not on a particular form or anything), but I am trying to reference controls on a subform, do I use [Forms]![ParentForm]![Subform].[Form]![TextBoxControl] ?
And then if I were going to run this same query on a button click on that same subform, then it would be Me![TextBoxControl] ?
Let me clarify a little bit: I have a main form that has a subform area on it. Based on a combobo selection...Leave a comment:
-
Value from textbox control in subform
I have a textbox control on a subform and I am trying to get it's text or value into a query. The users are entering a date into this textbox.
This is how I am referencing the textbox:
When I reference the textbox in an IIf, it works. If I just try toCode:[Forms]![AstProfileFrm]![AstProfileWhatIfSbfrm].[Form]![SepDateInputTxt]
...Code:SELECT [Forms]![AstProfileFrm]![AstProfileWhatIfSbfrm].[Form]![SepDateInputTxt] AS Da
-
I took off RecordLocks and now it works. Very interesting.
Thanks for your assistance, zmbd, as always!Leave a comment:
-
Sure.
...Code:UPDATE AwardTbl INNER JOIN AssociateTbl ON AwardTbl.EmployeeID = AssociateTbl.EmployeeID SET AwardTbl.ForfeitedUnits = [AwardTbl]![AwardUnits], AwardTbl.SpecialVestedUnits = 0, AwardTbl.ForfeitDate = Date(), AwardTbl.ForfeitNAV = Format(DateAdd("s",-1,DateAdd("q",DateDiff("q","1/1/1900",Date()),"1/1/1900")),"Short Date"), AwardTbl.RepayUnitsLeave a comment:
-
DoCmd.OpenQuery not working
I am trying to run this code/query:
The query updates some fields in a table based on a date comparison. (whether or not the date the user entered is > than a date in the table.)Code:DoCmd.OpenQuery "ForfeitVestingDateUpdateQry"
When I run the query from design mode (the red "!"), it works. When I try to run it via this method, it does not work.
The ONLY thing I can think of... -
I'm sorry you interpreted my last sentence as another question - I was stating that the code segment, had it been related to my problem, is necessary.Code:Cancel = True
As far as the meat of your response - The two subreports are set up the exact same way. The field I am summing (PytGross) is a field in the detail section of each subreport. I'm not sure what you mean by InsideLeft InsideRight. PytGross is not a field on a form, but rather...Leave a comment:
-
Retrieve fields on report from two subreports
I am trying to pull the SUM() from 2 subreports. It works for one subreport, however not for the other.
What I tried: I Sum() the field in the subreports, so I can refer to that field on the main report. However, for the test case I am trying, there are no records for one of the subreports, so I tried:
Code:=IIf([PayoutByYrLTTSbRpt].[Report].[NoRecords],0,[PayoutByYrLTTSbRpt].[Report].[LTtotal])
...Code:=IIf([Pay
-
To be honest, I'm not sure. I haven't programmed XML so I stay away from WPF because I'm focusing elsewhere.
Also DevExpress is a third party tool that I've never used. I would do a quick Google on other WPF GridControls. I didn't see any others aside from DevExpress..unf ortunately.Leave a comment:
-
Are we talking about WinForms, WPF, Web app, MVC....? If it's web, check out jqGrid.Leave a comment:
-
Oh that actually works! Haha thanks, Seth. I appreciate your help!Leave a comment:
-
Just display the value the user entered into the text boxes on the form.Leave a comment:
-
Well, to be honest I haven't done much SQL Development, so it is hard sometimes to put into words what I am trying to do.
I thought I needed to create a join (somehow, now I realize it's poorly worded) to the table with the Date and Value using the StartDateTxt and EndDateTxt.
The question should have said how to get the values from text boxes on a form into a query.
As in..
...Code:Select Forms!PlanFrm!ReportSelectSbfrm.Form!StartDateTxt
Leave a comment:
-
Yes, sorry. I always leave out an important detail - it never ceases to fail.
The date fields are on a form. Here's how I am using it for other things in my query.
I would prefer a SQL answer because that's what I am trying to throw it into. If I posted my SQL it would probably only lead to more confusion...Code:BETWEEN Forms!PlanFrm!ReportSelectSbfrm.Form!StartDateTxt AND Forms!PlanFrm!ReportSelectSbfrm.Form!EndDateTxt
Leave a comment:
-
Get date from textbox into query and use it as join
The user is entering a start date and end date to filter records.
In the table, the data is set up like so:
If the user types in the begin date -> 3/31/2013 and 12/31/2013 for the end date, I am wondering how to get the values of $1,975.00 and $2,000.00 into a query. I am also trying to get the dates...Code:Date (PK) Value 3/31/2013 $1,975.00 12/31/2013 $2,000.00
-
Which fields in the database are numerics? Let's start there.Leave a comment:
-
How are you getting "sr no" to the text box?Leave a comment:
No activity results to display
Leave a comment: