Search results for query: *

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

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

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

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.

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

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

You have attempted to open a database that is in use by someone else, but the database cannot be shared. You must set the location of the .NET control file. I have checked all the computers that should have access to the Paradox tables, however one folder of tables still comes up with this...

Does anyone have code to calculate month to date? TODAY is fine but a MONTH & YEAR function would have been nice. Thanks in advance.

I am setting up a multi-user paradox database in a 24-7 enviroment. I am linking several tables stored on a novell server. I have experienced several problems when server backup fails, general power fail etc. with PDOX.NET & LCK files when trying to get back online. I am considering coding user...

I have a table Keyed on Date with 50 data fields. I need to average the 50 data fields. When I try to create a calculated field on a form it will only allow me to add 15 fields together, then I get a syntax error. I guess the calculated field can only contain 15 variables? How would an...

Does anyone have experience with ODBC link to ACCESS table from Paradox? I have linked to an ACCESS table however as the form opens a dialog box comes up asking for Database Name, User Name and Password. If I just click OK the table comes up fine but I would prefer to not have this dialog box...

I have a form with several calculated fields based on user entered fields. Is there a simple way to force the calculations to update after a user has entered data? Thanks in advance.

I have writen forms and queries and saved them on a server. The user PC's access the forms, queries and tables from the server. I am finding that either windows ( 2000 Pro ) or paradox ( 10 Runtime ) is saving old versions of my forms and queries on the user pc's even though I have updated the...