Search results

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

Thanks for the help!

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

Yes, I meant who has had a letter actually sent to them... I just need to figure out the best way to mark anyone who came up in the parameter query with receiving that mailing. I probably also want to tie this action to the export of the mailing list to excel to save steps and also prevent the...

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

Actually, that was returning all records regardless of whether I selected a zip code. So, now I'm using: Between Nz([Forms]![frmReportGenerator]![cbozip],"") And Nz([Forms]![frmReportGenerator]![cbozip],"ZZZZZZ")

Hi, I ended up using... (>=[Forms]![frmReportGenerator]![cbozip] Or Like "*") And (<=[Forms]![frmReportGenerator]![cbozip] Or Like "*") ...in the query based off the combo box... seems to work okay!

Nope, still no changes in the cboZip after making those changes... Do I need to change something with the row source of the cboZip? I noticed that I couldn't get it to SELECT DISTINCT until I changed it in the vba and the row source...

I'd like for the 'All' selection to be a the top of the list of zip codes, and if the user selects it, then selects the report they want to run, that all zip codes under the cboDate will be included in the report. Tried to put the above code in, but the 'All' selection didn't show up anywhere.

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

Hi, So I followed Example 2: A Single Row Source Table from: http://www.fontstuff.com/access/acctut10.htm It seems to be working now, except it looks like it's returning ALL records in the cbo, not unique records. I changed it to 'select distinct' for cboZip, yet I'm still getting duplicate zip...

Ok, I'll take a look, thanks!

Well, I'd put the make table query there to be able to limit the zip codes for cbozip to pull data from, and I was having major issues getting it to work any other way. Since, I need the data stored or saved somewhere long enough for the user to select the other combo boxes on the page and have...

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

Ah! Got it!!! Thanks a million!

How do I conditional format an entire column that's not necessiarly 'conditioned' to what text is in the column? I don't need it to specify what is 'between,' 'greater than,' 'equal to,' etc. I just need the whole column to color. Is there a way to do this short of making a condition for each...

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