Search results

Hi, I have a database for my nonprofit zoo. In it, we track program attendance for free programs, events, and programs requiring registration. I have a Table (TblPrograms) where we'll collect things like program name, date, times, fees (if any) and attendance. Attendance can be recorded right in...

Hi, I have two command buttons in a subform "sbfScoutRegDetails", one that launches a report and the other attaches the report pdf to an email, associated with the record ID when clicked. Both of these buttons work fine when just the subform itself is open, but when viewing it in its main...

I have a form based on one table which has two cbo boxes, [ProgramFeeIDFK] & [TravelFeeIDFK], that will select from the same fee list for the same record. The user can select the fee from a drop down with 4 columns, the bound column being the id for the fee. I'm having the user enter data in a...

Hi, I'm trying to sum a couple of columns from a subform datasheet and carry them onto the main form. My main form, [frm_tours_details], holds subform [sbfTours] which is a datasheet. On [sbfTours], I've got a couple calculated fields within the datasheet, one, called "txtStudentSum", which...

Hi, I'm trying to filter an append query by a year selected in a combo box [cboYear] for a field [ProgramDate]. The AfterUpdate on the cbo filters the append query based off of the selection (or selections-I'm using multiple combo boxes on the form). I then run a report based off of the appended...

Hi, I'm trying to generate a report off of a form with combo/list boxes that will filter the report parameters. I'm doing this for several forms/reports, but generally need the same thing for all. For example, I have a form for my programs which has a combo box "cboYear" to select a year...

Hi, I'm trying to create a form which filters a report based off of combo boxes selected by the user. The code I'm using currently is: DoCmd.OpenReport "rptProgramAttendees", acViewReport, , "ProgramIDFK = " & cboProgramTitle This works great to return a report if the user selects something...

Hello, I'm having trouble with the Access 2010 navigation forms. Basically, I'm having issues running reports with parameter queries from subforms within a navigation form, that's within a larger navigation form. I have my 'base' navigation form, 'frmMain', and one of the tabs in that form is...

Hi, Thanks in advance for advice/help! I have two tables with phone numbers ("tblContacts" and "tblAltContacts"-which is family of the primary contact & associated with the "ContactID"), both of which have three fields of phone numbers ([Home], [Mobile], & [Business]). I have a third table...

I'm trying to build a query that will return or exclude data based on a combo box. Basically, have two values I want to sort by: [TargetPlantingDate] and [OwnerResponse]. These two values will pull contact records to generate a mailing list. I have been trying to model off another form/query...

Needed two subforms synchronized, one in datasheet view and the other as a detail subform of the focused record on the datasheet. So, I followed the directions at this site: http://www.fmsinc.com/MicrosoftAccess/Forms/Synchronize/LinkedSubforms.asp They synchro works great in existing...

Hi, I need some suggestions on design/setup for tracking mailings. My DB has 'tblContacts,' 'tblLocation,' and 'tblTreeWork' tables. We are creating a letter to tell the Contact/homeowner (mailed to the 'ContactAddress') that LocationXYZ ('LocationAddress') is having TreeWorkXYZ done to it...

I have been trying to set up two cascading combo boxes. cboDate feeds---> cboZip My last step is to put an option in the cboZip (the child cbo) an '(All)' option so users can select all zip codes for that date if they want. My VBA in the After Update event for cboDate is: Private Sub...

I have made a form for my DB which I've built two combo boxes, one dependent upon the other. the first combo box's row source draws a select query: SELECT tlkpFunding.TargetPlantingDate FROM tlkpFunding GROUP BY tlkpFunding.TargetPlantingDate; it has a macro in the ON CHANGE event: Set...

Hi, I have a datasheet which features a few text boxes displaying additional column info from a combo box's select query; i.e. the control source is "=[FundingIDFK].[column](2)", etc. Since this column is not an editable field, I'd like to make the text grey instead of black (as in the rest of...

I have a form in which I'd like 3 combo boxes to be based of one-another. My 3 combo boxes are: cboFunding--> primary combo box cboDate-->based off of cboFunding, this box may contain "dates" or "seasons"; i.e. it's not strictly a 'date' box with a date picker, it's a text box. cboZip-->based...

I have 2 combo boxes on a form: [cboARRAdate] & [cboARRAzip] I want to base [cboARRAzip] off of [cboARRAdate] (user selects a date, and only records with that date's zip codes are available from the cbo) It seems to be working fine, I can select a date, and I can see that the zip codes change...

Hello, I'm trying to get a report to give me a total count of volunteers for the year. I have an overall count, because for each event I enter the total bodies that were there. My problem starts when I try to count individuals. My DB is designed so that I can look at a contact and see all...

Hello, I have a report, run off of a wildcard parameter query for dates, which lists all upcoming work (trees to be planted) needed for a contractor; based off of the date scheduled (planting date/time of year). So, the user can type the date into the prompt and pull all trees for that planting...

Hi, I would like to set up something so that the user can hover their mouse over a column heading in a datasheet and a little text box or bubble can appear to describe what the contents of that text/combo box should contain. I have many similar-sounding columns, such as "Owner Response" "Owner...