Recent content by bastanu

My sample uses table-based "access rules" at the form and control level so no need to hard-code individual control or form events. Everything happens in the Open form event and it is just one line: Call vcSetAccessLevels("Form", Me.Name) Cheers,

Here is an updated version that should work with both 32 and 64 bit versions of MS Office (it allows to control access to individual control level). Cheers,

Here is a simple one that would relink the front-end to the back-end located in the same folder. So all you need is to have a local settings table (useful for many other things) that stores the name of the back-end (without the path) and has a Yes\No field to force the relinking. Call this...

Yes, the version I have on my site is an older 32 bit one, there are a couple modules that need to be updated to be compatible with 64 bit or have conditional compiling to make them work with both. Cheers, Vlad

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,

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)...

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

Check your spellings, you declare NewDt varaible yet you use undeclared NewID....

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,

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...

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

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,

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

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,

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