Search results for query: *

Every time i run a certain query i will get the results - machNo Sum Weight ie m1 wt200 m2 wt400 m3 wt250............etc all i want is that an undefined field box on a form that will automatically show the sum weight value if machno is 1, similarley another undefined field box on the form that...

hi. this is just a data display form, the form is opened automatically after a qbe produces the current amount of production and shows the values for each machine , the program already works and i use an iif statement to get the count of rolls for each machine which i then multiply by the...

HI, I understand what you are doing here but what i cannot seem to work out is how to place the weight total obtained in the resultant answer table into a field box on a form.i.e form has other details about each machine so form has fields for - quality / orderno / total weight. for each...

I run a query which gives daily production this gives every roll produced in 24 hours by 50 machines. The query database gives rollno machineNo and weight. I now want a quick reference calc which will give the total weight per machine, i could do a query by machine with calc sum weight but this...

thank you, you wouldn't by any chance have a solution for another little problem, I log the daily production of a production plant and i get production in items per machine i.e. mach1 20kgs, mach2 20 kgs mach3 20 kgs mach1 20kgs, i am now trying to find a way to calculate in a form field the...

You are right in your assumption it is an undefined field on a form which shows a runtime calc for information, as the user enters values the calc operates to show the current value. If i place your code in arrive will it continually change or would it be better in new value.The calc is...

empty calc field shows <error how do i get it to show o or blank. regards

i NEED TO PRINT OUT A FORM EVERY SUNDAY , THE COMPUTER SYSTEM IS PERMANENTLY ON WITH A MENUE PAGE SHOWING SO I DON'T HAVE A TIMER PROBLEM ETC. ANY HELP GREATLY APPRECIATED.

Thanks I have tried this out and the result is just what i needed. regards paul

Thanks i have not done any programming with scripts, please could you give me a bit more info. I can program into the main &quot;main menu Form &quot; on my paradox application which is open at all times, i was thinking of putting a time field on the form then a timer to trigger at 9am to push...

I need one of my forms to automatically print out at 9 a.m. everyday.The computer and printer are on permanently. help needed for code and where to place code. THANK YOU

i have downloaded replicator but did not undrstand it,(any insight welcome) i have been playing with data transfer useing email, and ftp useing useing one of my web sites (this i find easier and quicker). it works best if you use a master folder for the data and seperate folders within this for...

The inbuilt pdoxusrs table .lck error box offers users a choice , to select another table / help. can this be changed to a box that displays, system busy try later, with an ok button to close it.

I need to filter a table frame on arrive ONLY . the paradox auto filter filters the table as a user imputs new data, and this is giving users problems. I tried if myfield.value<1 then record.hide() endif I get an error and haveing tried various different ways i can't find the solution. thanks...

hi joe and ogriofa thanks for replies, by the way i do not use passwords this is a special case. question jo I am not sure of where i am placing this code. on myform 1 in afield box called password where &quot;password&quot; is entered. or in the button. or have i to place some code in myform2.

Thanks i've sorted it now.

On a form i have a button that opens to another form,is there a way to put a simple password protection routine so that a user has to enter a password and then the button will activate the form opening. can this be programmed into the button. i.e if password = &quot;PASSWORD&quot; then form...

i have a situation where i need to print a form directly from paradox with out going through windows print file. or a way to disable the help button on print file. i am useing a kiosk type program and i want users to be able to print out a form but with PRINT FILE if help is clicked a user can...

I have just discovered i cannot use the auto increment that is in paradox, I need to create my own incrementing number field. I have a form that is put into edit mode with an append button to place entries at the bottom of a table. fields Partno, Weight, Operator. Partno has to increment by one...

I am attatching the tablename.db file and in the insert attatchment it shows All files(*,*). The biggest problem is that because the key field in the table is autoincrimating the new data adds itself to the bottom of the table and duplicates data already in the receiving table.