Code:
Forms!mainFormName.Form.mainTextBox.Value = Me.TextBoxNameFromSubform.Value
jpatchak
Last Activity: Oct 27 '11, 03:24 PM
Joined: Oct 30 '06
Location: Green Bay, WI
-
You can just throw this code into your sub form's "On Current" event:
-
If you could actually post the error messages, that would be helpful. Are you doing this through a form or a query? Also, I would question why you'd need to do this at all. Seems like you should be writing a query that calculates the summed values and using that rather than writing the values to a table. That's what you should do in most cases, but there may be valid reasons why you'd want to write aggregate data to a table.Leave a comment:
-
I would try changing your filter property to:
so that you'r comparing string to string (according to Help, the Format function returns a string). If that doesn't work, try:Code:Me.Filter = "Format([PrepareDate],"yyyy-mm") = """ & Me.listDateSelect & """"
...Code:Me.Filter = "Format([PrepareDate],"yyyy-mm") = #" & Me.listDateSelect & "#"
Leave a comment:
-
You probably would have more success if you weren't getting the value from the subform, but from the underlying table itself. Assuming that your main form has a primary key (i'll call it MasterID and assume that you've got it in a textbox called txtMasterID) that is stored as a foreign key in the table underlying your sub form and your sub form's table ALSO has a primary key on it, the following code in your text box's control source should do it:...Leave a comment:
-
I'm not sure there is an easy way to exclude weekends and holidays with a function like that. If you had a simple calendar table with the following fields: Date, IsWeekend, IsHoliday your function would look something like this:
DCount("*", "CalendarTable" , "(Date BETWEEN #" & [Open Date] & "# AND #" & NZ([Closed Date], Now()) & "#) AND IsWeekend=False AND IsHoliday=False ")...Leave a comment:
-
You should really use an auxillary calendar table:
http://sqlserver2000.databases.aspfa...dar-table.html...Leave a comment:
-
Anyone? Looks like a lot of people reading this and no one answering :-(Leave a comment:
-
How to add onclick attribute to link in Reorder List Control?
Hello,
I have an AJAX Reorder List control, which is working fine. I want to add an "Edit" hyperlink to the ItemTemplate (which I have done) that opens an AJAX Modal Window when it's clicked. I need to add an OnClick attribute to call a javascript function and pass the value for the ID of the object bound to the list. I have done this before with a gridview with no problem - I just need to add code like this to RowDataBound... -
The proc constructs a select statement and executes it. It returns the results of the select along with the scalar value in the output parameter. The last 2 statements would be something like this (the @sql variable contains the text of the select statement):
The purpose of the vb code is to take the dataset returned by the proc and dump it into an excel sheet (nicely...Code:@name = 'The title of a graph' exec(@sql)
Leave a comment:
-
Hmmm, no takers huh? I am just going to execute the proc twice, but this makes me a little worried, as I am trying to write a procedure that can handle all kinds of these procedures and some of them are going to take 15+ seconds to execute (per execution). Not crazy about that.Leave a comment:
-
In 2003, I think the only way to accomplish what you're looking for is to use something like Mr. Leban's custom control. I have personally never used it, but I have heard second hand that it worksLeave a comment:
-
What version of Access are you using. Supposedly, rich text editing is supported in Access 2007 (I have 2003 at work, so I can't confirm). Also, Google Stephen Leban - he has a rich text editor for Access.Leave a comment:
-
Output Parameter returning empty string
OK, not sure if there is a way around this. I have some relatively complicated SQL code in a stored proc. The proc is working fine. When I execute this code in SSMS, it returns a record set and an output parameter (varchar(50):
So, I need to access this data from Microsoft Access. I need the proc to return...Code:Declare @name varchar(50) exec pra_StoredProc @id=12, @name=@name OUTPUT select @name
-
Never mind - I was updating the bounds incorrectly. Once I updated bounds correctly it worked! Thank you for your patience and your expertise!Leave a comment:
-
I think that the reason that r.intersects(p) won't compile is that the intersects method of Rectangle2D needs type Rectangle2D for the argument - since p is not a Rectangle2D, it won't compile.
Updated bounds in the move method of PenroseShape and no luck.
I'm not getting what I should be doing with the translate method of Polygon here, so if you could give a little bigger clue, that would be helpful.Leave a comment:
-
The class PenroseShape extends Polygon and has 2 subclasses: kites and dart. Here is the PenroseShape class with its subclasses:
...Code:class PenroseShape extends Polygon { public int rotation, x_position, y_position; public Color pColor; public PenroseShape(){} public PenroseShape (int x_pos, int y_pos, int rotation) {Leave a comment:
-
r.intersects(p) will not compile - tells me that the intersects method of a rectangular shape can't take p as an argument. I tried contains - created a Point2D at cursor on mouse press and then tested to see if p contains the point and got the same results as with p.intersects(r) .Leave a comment:
-
Problem with Polygon intersects
Hello,
I am having a problem using intersects method of a class I made that extends Polygon. Basically, I am trying to write code that allows the user to drag these polygons. I create a 1x1 rectangle on a mouse press and look through an array to see if the rectangle intersects the polygon. If it does, then I call the polygon's move class, passing the x and y coordinates while the user is dragging. Problem is that it works the first... -
Thank You. It didn't work at first, but then I rebuilt the form w/ just the MouseDown handler (with ByVal qualifiers) and that worked. Then, I slowly copied code and controls from my old form. It appears to be working. Still very strange. I've got essentially identical forms with identical code modules and controls - one works and one doesn't. Weird. Thanks for your help!Leave a comment:
-
You should set the caption property of the label while form is in design mode, then open in preview. For example:
...Code:Dim strHeader as String strHeader = "2008 Pricings for " & datReportDate DoCmd.OpenReport "DailyPricings", acViewDesign With Reports!DailyPricings .lblHeader.Caption = strHeader End With DoCmd.Save acReport, "DailyPricings" DoCmd.OpenReport
Leave a comment:
No activity results to display
Leave a comment: