Search results for query: *

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

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

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

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

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

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

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

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

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

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 :-)