Search results

Ok, someone is having a good laugh at my expense! And probably others. I started a new thread in which it took me a bit of time, around 5 minutes to think about what I wanted to put. The post itself was probably only a few paragraphs long. I go to press on submit and guess what, the site asks...

Thanks, that is probably the right thing to do. I did already do it that way originally but wanted to get the user to correct any errors before they moved to the next control. I just thought it would be cleaner to correct errors as you go along instead of getting a list when you press 'OK' (As...

Hi, I have a form with a control for the user to enter some data and then two command buttons 'OK' and 'Cancel' For the OnExit event in the control I have a procedure that check the user input and if incorrect, opens a message box with an error message asking the user to correct the data. It...

I'm not sure what you mean? The fields I am counting are the number of different Production Orders that apear for the same Material code. So if I have 5 different production orders that are linked to one material number then I'd like to count them 1,2,3,4,5 ... I have found some examples of...

I have a query where I want to add sequential counting to all items that are part of a group. I have grouped the query on MaterialCode and want to add a sequencial counter for all orders that have been assigened to a materialcode For Example: Key MaterialCode Order Counter abc1...

In my report have a control that works out a ratio for each record compared to the sum of all records for a given field name in a table. So for example of the field may be 'output' and the control in form calculates the ratio of each individual 'output' as a ratio of the total for 'output'. I...

Yes, that is pretty much what I need to do. So equivalent to looking through all the records until I find someone who has no children (The last step in the process) and trace back through the records to find all the former parents (or in the real life case to the first process step) make a table...

The real data would say the same. As motioned the first step in the process does not have a previous process step, so the current order is substituted for the previous order. So when you see the same order as both current and previous it's how you know that was the first process step.

@Mihail Thanks for that, but it doesn't work. I probably haven't done a good job of explaining it. I’ve had a play and think I have developed the right structure but the problem is that we don't know the journey and we can't record the data in any other way than it received. That's just...

Thanks for the replies. I will try and get some data shortly but a non manufacturing way to think about it is you are going to get in your car and drive to a number of different addresses. At each address you are going to record at least two things, the address you are at (Current Order) and...

Not sure how to best explain this but here goes: Imagine a production environment where there are various machines. A product can start its journey on a 'production run' from any one of those machines and take a number of different routes (process steps) through the production environment...

Thanks MI man, that works.:)

I have put a command button onto a worksheet. It is just a normal command button not a toggle button. I've written some code and the button executes the code as exepected. The problem is that when the mouse moves focus from the button, the button depresses and stays pressed down. Although it...

I guess you are right. It would be difficult to enforce. Maybe if it was included in the forum rules as 'Good Practice' along with a few gentle reminders, some people would start doing it and then others may eventually pick it up? Or do I live in a dream world!? :D

Is there a way to show that a question you have posted in a forum has been fixed or resolved? Cheers Red

FIXED: auto-hide mouse? I have a form that basically shows live data via a graph. The user can open up other forms to do basic operations but when they are finished, the graph shows again. Is there a way I can automatically hide the mouse when it is not moving and then show it when someone...

If it is just 2 unbound text boxes, you could just put some code in your forms open or load event that would put in last month's dates, or whatever dates you wanted. I'm no expert but you could use something simple like: Me.BeginDate = now() - 31 (or however many days you wanted to go back...

Yeah, you are probably right. Although once one 'pair' of forms was debugged, it's only a case of changing a few lines of code and some variable names to create others. The most important thing for me is that each external device gets scanned every 500ms, the rest isn't too time critical...

I have a form that triggers every 500ms, using the OnTimer event. The code that executes basically communicates with an external device, retrieves some data, which is then written to a table for logging. I am creating a second form that I wish to trigger every 5 minutes to query the data...

I have a database that is currently capturing live data from various processes. I am developing a front end that will display various ‘real time’ information for the relevant users, mostly though graphs (Charts) I am using some VBA / SQL to get information from the tables, do some calcs and...