Search results

I think this may be the wrong question to ask. Instead of "after six logins" which could be all six done during an hour or two during a morning shift, why not do the message after a certain time period / amount of activity? If you want a "Daily backup", I'd use a configuration record that holds...

To add "WHY" you do periodic inventory, then add/subtract based on transactions, lets look at the real world. You check you stock and see you have 100 green widgets. You update your records to show "Got 100 green widgets" You enter a transaction that sells 10. While you are entering in your...

@nector, When doing inventory control you should have a set periodic inventory that says "We have N number as of beginning of period". You then query all records that move items in to or out of inventory since "beginning of period" to determine how many you have now. You do not want to try and...

Definitely miss sliders. I'm going to be heading near Detroit in a couple months for my nephews wedding. Will definitely have to stop for some!

Down side to this approach is you would need to make sure the "Driver" is able to take control in a timely manner. As a timing issue, I would guess many drivers would need 3 to 5 seconds to register what action needs to be taken and then do something about it. If your in a position to react more...

Down side is a Tesla will still drive into a wall, but the auto drive turns OFF just before hitting. https://electrek.co/2025/03/17/tesla-fans-exposes-shadiness-defend-autopilot-crash/

OP posted in the REPORT forum, so I'm not looking at subforms or queries. OP hasn't shown where in the report this is being used. OP simply has "Chairman" as a criteria and wants a sum. One call to a query or DSUM() would do this with little effort on OPs part if done only ONCE. Bonus if the...

@Gasman, you've got me jealous now. I haven't been diving in almost 10 years and miss it!

In theory, the entire query returned can reside in memory. Table entries by nature are always stored to disk. Your betting money that a disk some place is faster that the computer's memory...

Were this me, I would probably use a sum query on $Medicare and use a control to hold the title. This lets you use the same structure for any title.

I'll third @theDBguy's comment. Main reason is to avoid having each tester see changes made by another users UNLESS this is what is being tested. Think through how an end output, such as a report, will look when multiple users are using the system at the same time. Can be a pain if others are...

I'd first I'd include NewName in your declarations. Then I'd make sure what is in OldName and NewName are what you expect.

If these are for internal use only, you can write a routine that outputs them to HTML, thus allowing a browser to worry about viewing them and printing them. Issue that will pop up is, even if you can get the image or document to show, your still using the print size (paper, orientation, and...

When you build SqlStr2, your FROM is the same table as you are inserting into. I'd suggest making a query that returns ONLY those fields from tblProducts (qryProducts maybe) and trying with the query as your FROM.

Also makes sense when someone move from one known location to another known location. Update link rather than enter entire new address. Example is when a child moves from mom's place to dad's. OP also has "Activities", so would make sense to have the option if their "Activities" are not always...

Special note on address tables. I've always found it more useful to have a linking or junction table that relates an individual or organization to an address. This allows me to also have a "FromDate" and "ThruDate". This way when James Jones Jr. moves out, you'll track that he USED to live with...

Normally when I see DMax() used for customer facing numbers it is stored as a "PO" or "Receipt" number rather than "RecordNum". Hence the question as I'd hate to think OP is trying to reinvent fire!

Trick I learned from a realtor; Let vanilla extract thicken a bit so it can be placed on an incandescent lightbulb. Place the thickened extract on a low watt lightbulb and let it dry. Turn on the light the bulb is in and your house will smell like a bakery in a few minutes.

Why are you trying to do this instead of having "RecordNum" be autonumbered? I'd also give it a better name than "RecordNum". DemoTrans_ID may be a better name as it makes it very apparent it is the primary key for the DemoTrans table, the main reason you use an autonumbered field.

But the broken digital clock could always be telling you how long until NOW!