I have a single user database with a very basic shipping process:
tblPart has a ysn field for "selected" and another ysn field for "shipped".
User select parts to ship.
Then creates the shipment.
A command button executes an append query adds the parts and shipment to tblShipPart and an update query that marks the part as shipped.
I need to adapt my process to a multiuser environment. I could use some points on the adaptations I need to make.
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
Windows Explorer lets you open cabinet (cab) files like any other folder.
In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data.
A Microsoft Access subform is used to show relevant calcul…
With just a little bit of SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form. If you have never written code or looked at an SQL statement before, no problem! ... give i…