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

    Sending Mail in Approach

    I'd like to be able to mail a snapshot of an Approach view (reports or forms etc) whilst in Approach, but when I click on TeamMail, the option to send a snapshot of the current view is greyed out. Also, if I ask Approach to send the Approach file with the current view only, it still ends up...
  2. genericjanedoe

    Running a macro once in a session

    Is there anyway of ensuring that a database carries out a macro only once during a user session? I ask because I have developed an archive database in which to export all the older records from a project database. When the "archive record" field is filled in, a macro exports the record into a...
  3. genericjanedoe

    Running a formula in a macro.

    Hi I need to be able to get Approach to switch to a report from the main form if certain records are holding a particular type of criteria. For example, I need to alert users that certain records have passed deadline dates for publications (where a deadline date exists - it doesn't always) and...
  4. genericjanedoe

    Generating Weekly Reports Using Query By Box

    I am trying to produce a report using a Find query that sorts on the records modified during the last seven days. I know that by using the formula: Database."Record Modification Date"='@Today()' I will get all records modified on that day, but I need a formula that will also allow me...
  5. genericjanedoe

    "Show Description Field" Error

    I have a database search form on my main database that requires a search of records using data from other joined databases. These sub-databases are joined to the main via their ID numbers (the only way I could get them to work together). When I want to enter a new record in a data entry form...
  6. genericjanedoe

    I have created two tables: [b

    I have created two tables: Programme Table Prog ID Prog Name 1 KS3 2 KS4 Sublists Table Prog ID Sublist ID Sublist Name 1 1 General 1 2 A2 1 3 A3 2 1...
  7. genericjanedoe

    I have yet another question about m

    I have yet another question about my database, and it is linked to my previous problem of drop down lists triggering sub-lists. First my thanks once again to Paul Bent for his original solution; but now I need to take this a step further. I created the filtered lists in a separate small...
  8. genericjanedoe

    Drop Down Lists Triggering Sub-Lists

    I have a drop down list of subject matter; each item of which generates a further two levels of sub-categories. I therefore want to create a situation where a user would click on a main subject category within this list box, and have a sub-category drop-down list appear in another box(dependent...
  9. genericjanedoe

    Delete both pages in a record

    I have another challenge for you (Thanks to Paul Bent for helping me out of an earlier hole!). My tracking project database consists of two joined databases each holding different types of information about a record. Each Project is registered on a form that spreads over two pages and...
  10. genericjanedoe

    Creating an "Overdue" formula

    I have created a database (In Approach 97) for capturing and tracking projects and I need to create a formula which will find all records where the project delivery date falls within 30 days of the current date. I'd be grateful for any help on this. Thanks :-)

Part and Inventory Search

Back
Top