Search results

  1. K

    DLOOKUP in Subforms

    Hi, Have searched in vain for most of the day for a solution. I have created a form which includes an unbound textbox which has a dlookup as the control source. This works fine when viewed "stand alone" however when I use it as a subform the DLOOKUP fields return an error. All of the other...
  2. K

    Last Month

    Users on the DB I've set up input a few different kinds of data. there's a form for items received, one for amendments, one for non conformities etc. A report on each of these is produced for the previous month ie report presented in April is on March's figures. I've set up the queries using...
  3. K

    Multiple Subs

    As a complete novice but eager to learn I hope someone can help. It's a pretty general thing. I want to press a command button and do 3 things. 1 Save the current form record 2 show a message box 3 Print a report based on the current record. As I say I'm kean to learn and have figured out the...
  4. K

    Automatic updates - Query to Excel To Word

    Overview I have constructed a Database for the recording of processing information ie date, received amount, completed amount reasons for non conformity etc. At the end of each month I am required to produce a report to show date, received amount completed amount incorporating totals and...
  5. K

    Upgrades From 2 to 2000

    A few people have told me that upgrading and converting Access 2 dbs to Access 2000 can cause some problems with existing queries and reports. Anyone confirm or refute this? Thanks in advance
  6. K

    Filtering data on one form based on another

    I have one form which contains a seperate record for various cost codes and their meanings. I also have a separate form whose records detail those people allowed to authorise funds to certain cost codes. On inserting a button to link the two fields(to filter and display the records of only...
Back
Top Bottom