Recent content by bigandfat

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

That did the trick. Thanks once again.

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

Thank You Lance Again your solution was prompt and effective.

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.