Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. bigandfat

    editing data warning

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

    Calculate hours in last month

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

    Calculate hours in last month

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

    dynamic queries

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

    Tab Order

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

    PDox 10 Publish to HTML error

    That did the trick. Thanks once again.
  7. bigandfat

    PDox 10 Publish to HTML error

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

    Monthly averages to a new table

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

    Automated Data Entry

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

    Common idapi32.CFG file

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

    Window sizing

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

    Window sizing

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

    idapi32.CFG

    Thank You Lance Again your solution was prompt and effective.
  14. bigandfat

    idapi32.CFG

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

    audit trail

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

    last update field

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

    last update field

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

    network initialization failed

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

    network initialization failed

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

    File Menu in Task Manager

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

Part and Inventory Search

Back
Top