I would like to trap editing a record with previously entered data and ask if they want to edit the data, but allow data entry of a null field without this step. This is an attempt to prevent erronious data entry by borded keypunch operators whom are entering data without looking at the screen...
Thank you all for your prompt and knowledgable responses. I used skipvought's Lookup, but seeing all you responses I can see many different solutions to the same problem.
Thank you all
BigandFat
I am trying to automate an avalability report for uptime and need to calculate the recorded downtime as a percent of avalable time over the last month. I created a nested IF function where IF Jan,744,(IF FEB,672,(IF MAR,744,(IF APR,720,0))) etc., however excel ( MS OFFICE 2000 ) only alows for 7...
Here is some code I came up with that I attached to a pushbutton to run a query of last months data.
Note a little funny business to get the start of a day at 7:00 am instead of 12:01 am with the time however you should get the idea from the date handling. The basic idea came from The DB...
I have a form on which I open a table frame ( timestamp )at the end().Attached to the table frame are several fields. I have been able to tab from the first record of the table thru the attached fields and back to the table. I would like to tab from the last record in the table thru the fields...
When I tried to publish a report to HTML I get the following error: " is considered an illegal character. Only letters numbers, underscores and periods are valid. I have no " in my report. Has anyone come across this error before?
Thanks in advance
I have been asked to set up a table of monthly averages such as generated by a report. I am unsure of the syntax to use to generate this in object pal so it can be done automatically. Does anyone have any recomendations?
Thanks in advance
A user has asked my why repeditive data has to be re-entered or copy and pasted into a field. She suggested something like pressing the spacebar ( as when entering the current timestamp ) to copy the previous record's data into the current record's same field would be fo great benifit when...
With help from Lance, I was able to set up a common idapi32.CFG on our server, and this has worked well for the paradox alias's however I have a few ODBC connections and when I set up these on a new PC I end up with multiple ODBC database entries in the BDE which causes problems. Does anyone...
Thanks Lance, I am able to change the windows size by modifying the Paradox runtime properties in the start menu ( W2000 ) and it will open full screen ( 1024 X 768 Res ) however from the desktop the window is still less than full screen. It seems that Windows? has saved the screen size in...
I have been unable to get Paradox Runtime 10 to open up full screen since playing with screen size resolution. I am running Windows 2000. Does Paradox save a resolution size at install?
Thanks in advance
I recall reading that you could put idapi32.CFG on a network server so all the workstations would draw their alias paths from the same file, however I have been unable to locate where I can change the path to idapi32.CFG in the BDE. Does anyone recall how this can be done? Paradox 10, windows...
I have a request to document the updates to a database. Perhaps a dialog box asking for user name and reason for changing the data, saving this to a text file along with previous field value and current field value?
Has anyone programed anything like this?
Thanks in advance.
In the change value event of data field
D=Today()
#editField=D ; of last update field
postRecord()
seems to work for me
just in case someone else was interested in recording the date of the last entry
Thanks
Dennis
I am trying to automate a field to record the last time a record was updated. I have a form with 5 data fields, followed by a lastupdate field. I would like the last update field to record the date of the last change of any of the 5 data fields.
If anyone has the time to point me in the right...
An Update for anyone else who has this problem:
Novell Client 4.83 has a bug which miss reports the PDOXUSRS.NET file as being locked and causes the initialization error. It is frustrating because you can see and modify this file from explorer but the BDE initialization fails. ( And I had...
cannot access network lock file
WinNT sp6
PDOX10 runtime
Novell Server
PDOX will start up with PDOXUSRS.NET on local drive.
I am able to read / write / create / delete / files on network mapped drive however PDOX will not initialize with BDE set to PDOXUSRS.NET on any network drive.
I have 4...
I have a PC in an industrial setting. It only runs one data aquisition program and saves data to a server. I run the program directly from the registry ( Winlogon shell ).
However a hacker who likes to play games is accessing the file manager via the file menu on the task Manager. Does anyone...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.