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 Mike Lewis 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. Thomasdelta

    Approach 'find' command

    I'm guessing this might be a bit late, and I might have somewhat over-simplified your problem, but still... Have you tried it without the '=' sign? I can't think of why it wouldn't work with it in, as it works just fine for me. (Lotus Smartsuite Millenium Edition). Without the equals sign it...
  2. Thomasdelta

    help with a formula

    How about have column C with a sequential number, and then including that in your formula. I read a book once called '101 Things to do in Binary'. It was the best 5 things I ever read.
  3. Thomasdelta

    Locking Records

    Creating a macro within approach is quite straightforward, and doesn't really need any technical know-how. It's all point-and-click, and selecting commands from lists. Do a search in the Approach Help for 'Creating New Macros' and follow the steps there. Once you see how it's done, you'll be...
  4. Thomasdelta

    File formats, forms being lost

    Are you launching your database from the APR file or the DBF file? You probably already know that the APR file is the view file where all of your designs are stored, and the DBF file is the actual data. I read a book once called '101 Things to do in Binary'. It was the best 5 things I ever read.
  5. Thomasdelta

    Locking Records

    The way I have got around a similar problem in the past is to create an identical view to the data entry one, but make it read only. When users enter their comments, they would be sent to the read-write view, via macros / buttons etc. After they have submitted/entered their comments, the...
  6. Thomasdelta

    Prevent copying

    If it is only the text of the email you wish to copy, have you tried looking at the properties tab, and highlighting the contents of the 'Body' field. You should then be able to copy (CTRL+C) the info and paste at will. I can't try this until I'm next in the office, but I think it might have...
  7. Thomasdelta

    Lotus deleted almost all of my entries

    I would guess that the database could have been joined to others. When you copied the database, the joins remained intact. This could explain why they were all deleted. Depending on how often you need to do this, I would probably export the information into a spreadsheet and then manipulate it...
  8. Thomasdelta

    Properties Box - no macros in drop-down list ?

    Have you tried replacing the field on your form? I used to have a few problem with fields suddenly becoming <unbound>, and found that the quickest way to solve it was to delete the item, and then re-insert it. You should then be able to select your macro. I never found out why it happened...
  9. Thomasdelta

    automatic conditional data entray

    Hi, I would solve this by having a calculated field with the following formula: If(Church = "Church A", If(Choir = Yes, ChurchACharge,0),If(Choir = Yes, ChurchBCharge,0)) Because the charges will increase over time I would suggest that they are kept in fields, and not coded into the formula...
  10. Thomasdelta

    Deleting specific field content

    Not sure if I completely underestimated the problem here, but have you tried creating a macro that finds all records between the specified dates and then runs another macro which starts at the first record, and then sets all the required fields to '' (blank). (you will have to use the Set...

Part and Inventory Search

Back
Top