Search results

  1. J

    Force form field to show specific table value

    I have tried a few options but keep getting this: :banghead: I have a form for entering service information. But there is one service slightly different than the others, so I created a different form. My struggle is getting this second form to automatically show this specific service in the...
  2. J

    Report data in month columns and year rows

    Hey folks; I am trying to make a report that creates a simple chart of my data, which would look something like this: Month1 Month2 Month3 (etc) Total Year1 TotalM1,Y1 TotalM2,Y1 TotalM3,Y1 (etc) TotalY1 Year2 TotalM1,Y2 TotalM2,Y2...
  3. J

    Updating control source for report header textbox

    Howdy - I have several dynamic reports which use a form to filter the results. One such filter is the date range of the report. I set up a nifty way so the top of the report displays the date range entered (or a default date range if dates are not used in the filter). However, once I close that...
  4. J

    Normalizing (and fixing) a large, messy DB

    Howdy, I work at a place that includes a popular rock climbing area. They have used an Access DB for many years to track their stats. After learning a fair amount about Access/DB design for my own purposes, I've taken a look at this climbing database, and it seems a pretty big mess. I would...
  5. J

    Filtering a report - problems with repeat names

    Hey all - long time no posting! I am back improving my database, and have run into a little issue. Last year I stumbled on a great resource that taught me how to build forms which filter reports. I am now working on a new one of these reports and filtering forms; one of the filters is based on...
  6. J

    Using VBA to filter report, need to include null values

    Hopefully my title and question are using "null" correctly. I will also state that I did not develop this code on my own - I do not have the VBA knowledge to do that. I am following this guide from a guy named Martin Green. His tutorial is pretty amazing and I give all credit to him. I have a...
  7. J

    Update FK field based on matching text in two other fields

    The Scenario: My database contains 6 tables; the one that needs updating is [tblProgramsGiven]. In this table is a memo field called [Notes] and in many records I put a note in about the lead person who gave the program. I decided to make a new table - [tblRangers] - that includes all the people...
  8. J

    Using textbox for filename Export

    I have a form where the user enters a StartDate and EndDate to generate a report. If I want to export this report to a PDF, I would like the filename to include the StartDate and EndDate. I have the code below, which does not return any errors, but does not include the info in the file name...
  9. J

    Check for/Create Folder, then export Query

    After some searching I think I've got all the pieces to my necessary answer. But my limited knowledge of VBA makes it hard to put it all together. I have a button on a report, and on click it exports the query (which the report is based on) to an Excel file. However, I realized that if someone...
  10. J

    Using Validation Rules on Forms & Solving Error Message

    Hey folks. Just posted an introduction thread in that forum if anyone is interested. I have a form/subform - frmCreditNewProgram and sfrmTeacherAttendance. These forms are built from a query that includes most of the fields from all of my tables. On the subform, users enter the name of schools...
  11. J

    Introduction for Joe Bruce

    Hello all. My name is Joe and I have been working with Access for the past couple of months; my goal is to build a database for my environmental education program. I have gotten a lot of assistance from the folks at "accessforums.net," but thought I would try a new forum for this question. No...
Top Bottom