Search results

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

I don't see were Plog was rude unless a post is missing, but stated that the code was hard to follow and provided a possible solution.

If they are not hybrid joined your local AD and 365 are operating independently. To login into the AD the computer must be joined to that domain. The compute does not need to be joined to 365, though they can be.

According to Microsoft SQL documentation the intermediate results will have the same type as the components. https://learn.microsoft.com/en-us/sql/t-sql/data-types/precision-scale-and-length-transact-sql?view=sql-server-ver17

Save edits before connecting to the telephone system.

500 controls on a single form points to a usability issue not corruption unless it also opens and hold locks on 100s of tables.

Intermediate rounding can case loss of precision. I would think the intermediate calculations like (A*B) would be determined by the types of A and B but even if they are Decimal(38,26) unless one or both had 26 digits to the right of the decimal or one or both are less than 1, rounding to 26...

I don't see using older computers causing a problem, unless they have problem network cards or are crashing while your application is open. I am just now replacing some computers this old but they have been connecting to a BE with 30 other users without issue. You may want to verify that none of...

For your customers with employees, properly securing the computers will help but if you suspect fraud, Access BE and possibly FE is the wrong tool. Let the owner know what's happening and what can be done to detect and possible prevent it. For single user customer, explaining the issue should...