Search results

Dove's Theorem: The remaining work to finish in order to reach your goal increases as the deadline approaches. Brooks Law: Adding manpower to a late software project makes it later. Canada Bill's Moto: It's morally wrong to allow naive end users to keep their money.

Are you settings watches to monitor the value of variables inside the loop. If yes, the locals window will do the same for all variables in scope at the current line during debugging.

If you setup a AD domain account with local administrator access to those computers; you can run-as-admin the event viewer on your computer then select those remote computers. Your users will never no you are viewing their event list.

Yes That's exactly what I am looking for.

Once you switch from coding to testing, you will most likely fall out of the grove. But in any case adding a save step in regular intervals will quickly become automatic. PS: I use source control with Access and make a point to commit changes with each new feature.

I have been adding XML style comments to my procedure headers for a more structured comment system. It would be great if MS could enhance VBA, to use them in intellisence like in .NET. ''' <summary> ''' Check if user is member of an Active Directory group ''' </summary> ''' <param...

The video is an interesting animation but unrealistic. A living being has sensory organs on every part of the body. Move your hand, it can sense the movement of air past your fingers. A robot has non of that. It may have gyros to provide it better balance than a human but it can't match all the...

Murphy's Computer Law 1) Murphy would never have one. 2) Murphy would have loved them. See the poster.

You can add much more power to OpenArgs by passing the address of a object as a string then converting that address to an object reference in the form or report. Using a user defined class and an object instance you can pass just about anything. I use this in my sample database...

Building on Mark's suggestion; instead of opening the form with the recordset filtered to your criteria, use that criteria to fill a temp table with the ID's that match. The recordset now uses those IDs to select the records to be edited. Now when your users edit, save and requery, they see the...

Your (TAGS) list is a bill of material. It makes no sense to have multiple tables for your parts. You should have a "parts" table listing the parts in a "machine". One of the columns of the table will be the TAG for that part. Assuming multiple parts can have the same TAG, you would also have a...

Are you binding events in user defined classes to these controls?

Can't most of the analysis be done at the server using views, stored procedures or possibly a pass though query?

I have seen "Recursive" query done in Access; It's ugly but works. Basically you have a query for each possible level, outputting the quantity to a level column Q1 for level1, Q2 for level 2. So if you allow 10 levels, you need 10 queries. They are then combined in 1 union query. Using a...

I'm just guessing here but as I understand it Azure db is basically web hosted SQL Server. If that's the case you should be able to manage user access at the database level instead of server allowing you to secure your code. Unfortunately Access don't support application security.

If you think in transactions, then partial payment becomes a transaction including the invoice, payment amount, payment date, etc.. The Invoice is paid when the invoice amount and payment amount are equal.

It looks like your trying to replace coding in a language like VBA with coding in the database. IE soft coding like in the Daily WTF article https://thedailywtf.com/articles/Soft_Coding. IMO designing the data model is the more difficult part of programming a database application.

It looks like something you could do in a CAD package like AutoCAD or Draftsight. Both have programming tools that allow you to build in blocks, linking objects together. Access can be used to store history and purchasing data using common object ID. AutoCAD add-on like AutoCAD electrical use...

Save the current ID 1st Private Sub Form_AfterInsert() dim CurrentID as long CurrentID = Nz(Me.AddressID, 0) ' requery parent form to include new record ' and go to subform's current record in parent form With Me.Parent .Requery .RecordsetClone.FindFirst...