Search results

To add to MarkK's post, I also add an "orderby" numeric. Often you'll have values that are intuitively together, but may not if in alpha order. Think "Front Center" "Drivers side Front" "Passengers side Front" "Drivers Center" "Passengers Center" "Drivers Rear" "Passengers Rear" "Rear Center"...

Two questions; 1) HOW do you plan to use this data? 2) HOW will you limit the number of columns? Please look to boundary issues, such as "Most of our subsystems will only have two or three pairs, but THAT one has about 400... I've been bit by more than one "Good Idea", and I'm hoping to avoid...

A little research shows this is done by the print driver generating the PDF. It is intended to let a user know the PDF is actually being printed and how far along in printing it is. For a single page, you would expect it to pop up and go away almost immediately. For a 100 page document with lots...

I have been working on a process to generate single page reports to be emailed. Does the exact same thing. I've been able to see enough to know it is showing what is being printed. Try putting a few big graphics on for testing. You should see the message longer.

If you have six of the same item, I agree, unless you "need to place the item in the bagging area" before going to the next. 😁

If this was me, I'd have the parent form take the input. As each scan is accepted, do a lookup based on parent ID and the looked up product ID in your child record. If the lookup succeeds, it increments the qty by one and updates the record. If it fails it creates the record with a qty of 1...

Having worked retail, this can be really really slow. For some reason people don't like putting all of the same item together. Just scanning them can be far faster than trying to group and count all of the same time.

I learned, many many years ago, that having one spot on the screen where an end user can ALWAYS look for help generally works best. I'd suggest having a fairly large text control that you can load with help text when a control gains focus will work far better than tool tips or audio tips. When...

Desired result is to look at the GM% (Quote) column on the record, and then put in >30 , >20 or Other in the Stratification column If you are calculating a value, you normally don't save the calculated value. Is there an expectation that this calculation could be changed? If yes, do you need...

In addition to what other's have said, some nice advantages of forms is you can lay out data in a manner that follows HOW the end user will use that form. Yes, in some cases you will have two forms to update the same table, just with very different layouts to support two different business...

Do you want to print the report OR save it as a PDF?

strSQL = "DELETE * FROM detinquilino WHERE ArtigoMatricial = " & Me.txtArtigoMatricial As Me.TxtArtigoMartirial looks to be text from the error code, this should be strSQL = "DELETE * FROM detinquilino WHERE ArtigoMatricial = '" & Me.txtArtigoMatricial &"'" Please take a look at the example...

I do hope you mean the Primary key of the parent. Linking by a field that could, potentially, be user changed is not a good idea. Keep the links hidden so users don't try have "Bright ideas" and do things to break your database.

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