Recent content by bastanu

  1. bastanu

    Setting up automated Microsoft Access database update using VBA?

    You can use the built in Windows scheduler to add a timed task to open your Access app (or Excel file) at certain times\intervals and in the opening events (or you can use an AutoExec macro for the Access app) you run your succession of imports. Cheers,
  2. 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)...
  3. bastanu

    Exit Do loop

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

    I want to check for duplicate date before upadating the table. In the Update Button Click Event I have used the follwoing code forcchecking duplicate

    Check your spellings, you declare NewDt varaible yet you use undeclared NewID....
  5. 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,
  6. 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...
  7. 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,
  8. 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,
  9. 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,
  10. 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,
  11. 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,
  12. 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,
  13. 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...
  14. 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,
  15. 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,
See more
Top Bottom