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!

Register Log in
  • Congratulations derfloh 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. suesloan

    Importing from Excel

    You may have a column in the Excel spreadsheet that has a blank value in the first row. Or you may have changed the column headers (field names). You will need to go into the macro Import command and reset it if the second suggestion is what is wrong. Sue Sloan
  2. suesloan

    Form Resets fields to top of page!

    The problem is the printer driver, which is telling Approach that your default page is very small. Approach is trying to fit all the fields into that small page. You need to do design work with a printer that has regular letter or A4 page size as the default. Then when not doing design, use Team...
  3. suesloan

    Calculate age in Approach

    This is correct most of the time: age = Trunc((Today() - DOB)/365.25) When you subtract one date from another, the result is the number of days between the two. You can then divide by the number of days in an average year (leap years are 1 day longer). Sue Sloan
  4. suesloan

    Help Merging two Lotus Approach DB's w/o losing Data

    Unless there are duplicate "key" fields in the two, the simplest way is to open one of them and use File, Import Data to bring the other file's data into the current one. Sue Sloan
  5. suesloan

    Email from Approach possible?

    You can use the OPEN command in a macro to do this. Instead of putting a file name in the command, you can put "mailto: etc... " in the space. You can insert an email address from a field by putting the field name into the command like this: <<mydbf.email>> Sue Sloan
  6. suesloan

    LOTUS APPROACH

    Condition your modification formula on a non-empty value in the other date field and in the "end date" field. Something like this: If(IsBlank("other field name",'',If(IsBlank("end date",Today(),"end date")) This will fill in today's date if the other field is filled in and the "end date" is...
  7. suesloan

    Appplication error caused by apprchtx.dll

    Sometimes when you want to delete a corrupt view, it helps to go into design on a different view. Then under the View menu, uncheck "Show data". Then try switching to the bad view to delete it. Sue Sloan
  8. suesloan

    apprchtx.dll error only on 1 computer using Approach

    Some things to check: 1) Printer driver. You must have a default printer set up on a system for Approach to work properly. If you have one, reinstall or update the driver for it. 2) You can copy the file apprchtx.dll from a computer that works correctly to the one where it fails. It is...
  9. suesloan

    Latest Version of Approach???

    The latest version is 9.8.5 and I expect 9.8.6 to be announced in the next 60 days or so. The only source for this release is IBM since they do not make CDs for this release any more. But you may be satisfied with 9.8.1 which can be found at various discount software web sites on CD. Sue Sloan
  10. suesloan

    Create unique identifier automatically with VBA

    This is not an "Access" discussion, but rather one for "Lotus Approach". Posting in the proper discussion will likely get you an answer. Sue Sloan
  11. suesloan

    How can I use a different Form to email from the current document

    This is a "Lotus Approach" section, not "Notes". Sue Sloan
  12. suesloan

    Appplication error caused by apprchtx.dll

    What version of Approach are you using? There was a fix for Approach 97, I think. If that is your version I can provide a link to the patch file. Sue Sloan
  13. suesloan

    Help with Time Formulas

    I would need to know the value of "On Scene" and "Received" and whether they are text or time values??? Sue Sloan
  14. suesloan

    Automatic screen refresh/live data within Lotus Approach 9.8

    You can use a script to refresh the screen in that applicaton. The Sleep function lets you tell the script to pause a number of seconds. Then you can use SendKeys to send Ctrl+R to the screen. Loop the script. The only problem is that you will need to cancel the script using the Windows task...
  15. suesloan

    Scroll wheel

    The Microsoft mouse wheel has never worked in Approach as far as I know. But you can install a program named Flywheel and that will let you scroll vertically in Approach. www.freedownloadscenter.com/Best/flywheel-scroll.html Sue Sloan
  16. suesloan

    applying a script in approach

    There is a full explanation in the discussion area on XpertSS.com. It is much too much to retype here! Here is a link: http://www.xpertss.com/cgi-bin/WebX?50@@.ee8a45d/5 You will need to log in or register to get to this information on that site. I do hope the owners of this site do not get...
  17. suesloan

    Merging cells

    Use the Combine() function either as a modification formula on the third field, or define the combination field as a calculated-type field with formula. Something like: newfield = Combine(Cell1fieldname,' ',Cell2fieldname) Sue Sloan
  18. suesloan

    Image bloated database is to large.

    There is a method demonstrated in a Free Downloads over on XpertSS.com -- Do a search for "picture" in the downloads database or for "apr-pic". Basically a script is used to display the content of an image file on a form view ( not in another program and not in a pictureplus field) and update...
  19. suesloan

    Printing problems with Approach

    You can look at some possibilities: 1) See if there is an update for your printer driver and install it. This has resolved spooling errors for some of my clients. 2) Try deleting the Print command from the macro and add it back. This will pull in the current default printer's properties, which...
  20. suesloan

    lotus Approach 9.7 always opens in read-only

    One possibility is that you have your database on a CD, which by definition is "read only". Or that the folder the database files are in is marked "read only". Another possibility is that your database index is corrupt and "thinks" a password is required. You can test this option by opening the...

Part and Inventory Search

Back
Top