GPGeorge's latest activity
-
You meet people in life with a similar agenda, I avoid them like the plague! -
I've noticed this as a flaw, IMO, in the system. Chat GPT always wants to "butter me up", i.e., say nice things about me. No matter...
-
It can be very useful for simple things to avoid creating them in a query. One of the best examples would be concatenating FirstName...
-
If you have occasion to repeat orders by a customer regularly you might find the following function of interest. It firstly inserts a...
-
GPGeorge replied to the thread Update of stock quantity.This is how we display in NW Developer the Qty to Reorder calculation Mark describes.
-
-
Open Windows Explorer, select to show details, and look at the size of the file. A monolithic Access app cannot exceed 2 Gb (though...
-
GPGeorge replied to the thread Update of stock quantity.Exactly. One more time, though, there is an example all ready for you to study and explore. It's in an Access template called...
-
GPGeorge replied to the thread Update of stock quantity.That is the Allen Browne method we keep suggesting as a model to follow. See Northwind Developer for a more recent implementation of it.
-
GPGeorge replied to the thread Update of stock quantity.As you've been advised before in this discussion, is risky to create and store calculated values in tables. Adding another such...
-
GPGeorge replied to the thread msjtes40.dll error.Did the code in your project compile after deselecting this reference? I didn't see where you mention completing that step? I, too, am...
-
GPGeorge reacted to arnelgp's post in the thread How to prevent query opening in maximum. with
Like.
using DoCmd.Maximize, will affect all "windows" you open and will open maximized. it is better to use DoCmd.Move -
GPGeorge replied to the thread I warned You!."Ego wasn't isn't lacking there, either." ;) Fixed it for you.
-
GPGeorge replied to the thread I warned You!.He creeps me out by repeatedly referring to the impressive value of his own work. It reminds me of all the hucksters selling get rich...
-
GPGeorge replied to the thread Access vs Comercially available databases.True, but there are other backup solutions available, both free and paid. For example, here are two selected at random, with no...
-
GPGeorge reacted to Ken Sheridan's post in the thread Update Stocks Public Subroutine not work with Like.
Storing stock in hand values in a table runs the risk of update anomalies, as the values can easily be amended so that they do not...
