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