Recent content by 123dstreet

  1. 1

    Call Button on Another Form Issue

    Hi Pat, Thanks for the input, I appreciate all the help I can get these days. Always learning something new!
  2. 1

    Call Button on Another Form Issue

    Hi Pat, The gotorecord is because there could be several records displayed but the last one is where I want to land first. There's only 1 button, 3 IF's, each IF has its own solution - how would you do that less obfuscated? Please share.
  3. 1

    Call Button on Another Form Issue

    I've got it working with Where now, thanks for your help Pat! BT100: stDocName = "RMA Data" strWhere = "[Serial Number]=" & strSN DoCmd.OpenForm stDocName, , , strWhere DoCmd.GoToRecord , , acLast Exit Sub BT200: stDocName = "RMABT200form" strWhere = "[SN]=" & strSN...
  4. 1

    Call Button on Another Form Issue

    Is this Where argument syntax correct? strWhere = "Forms![RMA Data]![Serial Number] Like" & "'" & Me.wstSN & "*" & "'"
  5. 1

    Call Button on Another Form Issue

    Okay I'll give this a try. I'm still curious though why the identical Call function is working on 2 other forms no problem but returning an error on this form.
  6. 1

    Call Button on Another Form Issue

    Thanks Pat, I'm definitely a hack. Is it possible to use a Where argument to filter a Continuous form? I would definitely prefer to use this method I just didn't know if it would work.
  7. 1

    Call Button on Another Form Issue

    Yes, I changed the Click events on these forms to Public: The code for all 3 forms is basically identical. The below code runs fine when run from the RMA Data form. Public Sub Command40_Click() On Error GoTo ExitError '-- Find Serial Numbers starting with --- Me.Filter = "[Serial...
  8. 1

    Call Button on Another Form Issue

    I have a form (form1) which will open another form (form2) and apply a filter using a filter button already on form 2. I have applied the following code which works properly for 2 of the 3 forms this needs to be done on: The below line 'Call Forms.[RMA Data].Command40_Click' works for both...
  9. 1

    Export to PDF Hanging

    I have solved my problem, just thought I'd share: I downloaded the Windows Process Monitor tool to see what was happening in the 5-10 minute hang time. Turns out one of the text boxes in my report was linked to a mapped network drive that we no longer use and it got turned off over the weekend...
  10. 1

    Export to PDF Hanging

    Hello, I am seeing a very bizarre problem with exporting a report to PDF. When clicking to save the report as PDF, it is hanging up for about 5-10 minutes before completing, it usually only takes 3-5 seconds. This is only happening on one report in my database, other reports export as PDF no...
  11. 1

    Handle Multiple Textboxes with 1 code

    Yes this is multi-user with front and backend split. I'll stick with the global refresh it seems to work well. Thanks for your help!
  12. 1

    Handle Multiple Textboxes with 1 code

    Here is a screenshot of my form in Design View.
  13. 1

    Handle Multiple Textboxes with 1 code

    Yes I meant to say bound. I'm curious why I need to refresh then...
  14. 1

    Handle Multiple Textboxes with 1 code

    Yes I just checked out your video, I am using the identical NZ([Text0],0) equation in an unbound textbox, but my entry textboxes are controlled where yours are unbound, maybe this is the difference?
  15. 1

    Handle Multiple Textboxes with 1 code

    This works perfectly: In design view select all textboxes. In the after update event put in =Refresh Without the refresh, the unbound textboxes with the total don't update at all unless I close and re-open the form, I'm clearly missing something here? D
Top Bottom