Search results

  1. bastanu

    Data from Access to Excel then a Pivot

    Have a look at my free utility that allows you to design the pivot table in Access using a custom form then export to either a new Excel file or an existing Excel template (overwriting the old data using named ranges references)...
  2. bastanu

    Exit Do loop

    I use the msgbox replacement included in the attached compressed archive file.
  3. bastanu

    Finding Data From String

    Have a look at my free utility that uses keywords or placeholders (i.e. First Name:) to parse webforms: http://forestbyte.com/ms-access-utilities/fba-outlook-email-parser-importer/ Cheers,
  4. bastanu

    Form Search

    I think the OP wants a version of cascading combos but with the first one replaced by a textbox. Should be a very easy setup, add the new filtering textbox (txtFilterByWord) to your existing form where you already have the working combo, add a Me.cboSearchCourse.Requery line in the Enter or...
  5. bastanu

    Solved Filtering Forms Based on a Calculated Field

    You need to reference the bound field name, not the control name in the Where clause of your OpenForm method call. Cheers,
  6. bastanu

    Open record from data sheet view ?????

    Usually to navigate to a certain record from a datasheet it is customary to use the double-click event of a id or (customer, product, etc.) name field. Cheers,
  7. bastanu

    Trying to figure out how to make a public sub work going from Me. to Forms! (etc.)

    I believe in your first iteration you should replace ".Report." with ".Form." for the last two lines. Cheers,
  8. bastanu

    Anyone know how to use DoCmd.RunCommand acCmdAppSize?

    I'm afraid you need to find another way to do that, looks like your current option is not what you want: http://access.mvps.org/access/RunCommand/codeex/13.htm Here is a link that might help: https://www.access-programmers.co.uk/forums/threads/hiding-access-window-faster.81228/ Cheers,
  9. bastanu

    Solved Copying data from a form

    Maybe try something like this in the click event of your button: CurrentDb.Execute "Update tblSKUCount Set YesterdayCount = " & Me.TodayCount,dbFailOnError Me.Requery Cheers,
  10. bastanu

    Solved Object required

    And as explained by theDBGuy in post #5 you are still getting the error because you use db.Execute instead of dbs.Execute, you do not have a db variable declared and\or set... But you should use a simple update query instead if the number of days you are adding is the same for all records. Cheers,
  11. bastanu

    Solved OpenArge error "You can't assign a value to this object"

    Glad to hear you solved your issue with BeforeInsert. I don't know how relevant the comment in your edit line in post #1 is now that you have it working, but if you want to give a visual clue to the user about the value about to get inserted (might be better to actually have a combo just like on...
  12. bastanu

    Solved OpenArge error "You can't assign a value to this object"

    Try to use the DefaultValue property instead: Me.PositionID.DefaultValue = Me.OpenArgs That should also work for subsequent new records in the same session. Cheers,
  13. bastanu

    Solved Text box not updating as form record source changes

    Have you checked the Access client settings, specifically try to tweak the ODBC Refresh Interval. Cheers,
  14. bastanu

    How to gracefully handle errors generated when opening a form with linked data?

    Try to open the Settings form as a modal instead so it will wait until the user relinks the BE before passing control back to the calling sub. Cheers,
  15. bastanu

    Recordset updating automatically

    @nirmal: I agree with Pat that using unbound forms is usually unnecessary. And I believe yours is not unbound otherwise your Docmd.OpenForm statement in your very first post would not work (you cannot open a form filtered using the Where clause of the OpenForm method unless the form is bound)...
  16. bastanu

    recordset movenext does not work.

    Cross-posted with solution here: https://www.accessforums.net/showthread.php?t=88151 Cheers,
  17. bastanu

    Solved Open Outlook Maximized

    I do 😁!
  18. bastanu

    Solved Open Outlook Maximized

    Maybe try ActiveExplorer (I tried it just before .Display): OutApp.ActiveExplorer.WindowState = 0 'olMaximized OutMail.Display 'Send | Display The original function uses late binding so no reference to Outlook is necessary, but you need to use the actual value (0) of the olMaximized...
  19. bastanu

    Check for Duplicates

    Missing AND in the criteria clause of the dCount between the two fields).
Top Bottom