Recent content by genericjanedoe

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

Thanks for this, it works! The only problem is that if I create the find in View, I have to use the formula in a particular field. Afterwards I don't seem to be able to use this same field to do a different search. So for instance, I can type in the find conditions for records modified in the...

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

Many thanks, I've found a work around; by designing a "found data" box separate to the drop down lists. Once I've asked it to search, it brings up the required description there.

I thought that if you checked the "show description field" box, the description field showed in the box, not the ID number? It certainly works if I am an in "browse" mode. The problem seems to occur if I use the "find" button. I've tried putting both ID and...

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

Doesn't work unfortunately - I'd already done that. I also tried to join sublists to programmes, and programmes to the data table, but that had no effect either. And of course I cannot join all of them together because that creates a circular join. Ironically, I think I found the answer whilst...

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

OK, I discovered that the problem with the unfiltered lists was because the field boxes on the form were pointing to the main database instead of the one in which I created the original lists. Now however, although I can click on one category and get a corresponding list appear in the sub...

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 think this fixes it. You've come to the rescue once again - what a STAR! A simple fix, but one I'd been tearing my hair out over. Thanks loads...:-D

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