Search results

As you have been dealing with this over a year, what is the time COST for continuing to support it as is VS time COST to rework it to normalize your data? The moment you realize "It could have saved hundreds of hours" should be the point you start working on a better layout. Once you have built...

Pat got me thinking. @ChrisLeicester, where will this be used an by whom? Last time I had to do this was for scanning accountable mail. Had to make sure the user knew to "Wait until it beeps" before they scanned the next item due to lag between "Scan" and "Input to control". If you hit the same...

Missed that. The other line of thinking I'd look at is "How is Machine 1 connected differently than the rest?", and "Where is the application being run (Start in)?"

So each user has a "<UserName>_Application name" front end is in the same folder on a server? I'd suggest having the users in question copy it to their desktop and try running it from there to see if that fixes your issue. SHOULD be a very quick test.

AND I'd suggest talking to them to see exactly what they are using it for. They may think "Hey, this is easy THIS WAY" and the person doing the display may be going "This would be so much easier if they just gave me one line per start/end pair". Would much rather you find this out now before...

For me, the quickest way to find out what fields are used in QUERIES, would be to open each in SQL view, copy it to a document that allows search (such as word) and then start looking at all of the WHERE and ORDER clauses. This is to help implement what Doc posted above. Trying to find this by...

Non sequitur; had OP waited one week to post, he would have responded exactly 500 days later.

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.