User Profile

Collapse

Profile Sidebar

Collapse
jpatchak
jpatchak
Last Activity: Oct 27 '11, 03:24 PM
Joined: Oct 30 '06
Location: Green Bay, WI
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • You can just throw this code into your sub form's "On Current" event:
    Code:
    Forms!mainFormName.Form.mainTextBox.Value = Me.TextBoxNameFromSubform.Value
    See more | Go to post

    Leave a comment:


  • 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.
    See more | Go to post

    Leave a comment:


  • I would try changing your filter property to:
    Code:
    Me.Filter = "Format([PrepareDate],"yyyy-mm") = """ & Me.listDateSelect & """"
    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 & "#"
    ...
    See more | Go to post

    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:...
    See more | Go to post

    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 ")...
    See more | Go to post

    Leave a comment:


  • You should really use an auxillary calendar table:

    http://sqlserver2000.databases.aspfa...dar-table.html...
    See more | Go to post

    Leave a comment:


  • Anyone? Looks like a lot of people reading this and no one answering :-(
    See more | Go to post

    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...
    See more | Go to post

  • jpatchak
    replied to Output Parameter returning empty string
    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):
    Code:
    @name = 'The title of a graph'
    exec(@sql)
    The purpose of the vb code is to take the dataset returned by the proc and dump it into an excel sheet (nicely...
    See more | Go to post

    Leave a comment:


  • jpatchak
    replied to Output Parameter returning empty string
    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.
    See more | Go to post

    Leave a comment:


  • jpatchak
    replied to Access Html editor for email form?
    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 works
    See more | Go to post

    Leave a comment:


  • jpatchak
    replied to Access Html editor for email form?
    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.
    See more | Go to post

    Leave a comment:


  • jpatchak
    started a topic Output Parameter returning empty string

    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):
    Code:
    Declare @name varchar(50)
    exec pra_StoredProc
    	@id=12,
    	@name=@name OUTPUT
    select @name
    So, I need to access this data from Microsoft Access. I need the proc to return...
    See more | Go to post

  • jpatchak
    replied to Problem with Polygon intersects
    in Java
    Never mind - I was updating the bounds incorrectly. Once I updated bounds correctly it worked! Thank you for your patience and your expertise!
    See more | Go to post

    Leave a comment:


  • jpatchak
    replied to Problem with Polygon intersects
    in Java
    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.
    See more | Go to post

    Leave a comment:


  • jpatchak
    replied to Problem with Polygon intersects
    in Java
    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)
                {
    ...
    See more | Go to post

    Leave a comment:


  • jpatchak
    replied to Problem with Polygon intersects
    in Java
    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) .
    See more | Go to post

    Leave a comment:


  • jpatchak
    started a topic Problem with Polygon intersects
    in Java

    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...
    See more | Go to post

  • jpatchak
    replied to Treeview 6 MouseDown Event
    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!
    See more | Go to post

    Leave a comment:


  • jpatchak
    replied to Passing a value to a report via VBA
    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
    ...
    See more | Go to post

    Leave a comment:

No activity results to display
Show More
Working...