Search results

Your are including your Forms!FundingPlan control value within the quotes. Change it to this: DSum("[RunningBalance]","StudyYears","[StudyYears] '" & <= Forms![FundingPlan]![StudyYears] & "'") Also, I would check out setting the value of your runningBalance to a numeric value rather than a...

The function is IIF, not Iff. That should solve it!

Not sure about that. How many pages is rptMetricsLong? Are these reports bound to a particular record or are they just blank reports? Not sure. How many records did you have selected? Have you tried putting a breakpoint in your code and stepping through it? To place a breakpoint - in the...

This is the query example that will give you all records that will end within the next 5 days select * from YourTable where DateAdd("ww",24,EntryDate)-Date() <=5 You can put this in the query SQL window after you click on Create Query. You will have to change the object names in the query...

Hi Bill: I looked at your DB and here are some screenshots of how to get to the vba window and put in the code you need. 1. Open your navigation form in design view and go to the Print button properties. 2. Find the OnClick event procedure 3. Delete the embedded macro from the onclick property...

Or do you want a form to pop up when the user opens the database that lists the records that need attention? If you want the form to pop up just use the query I gave you above and create a bound form that is based on that query. You can have it pop up several ways - either using an autoexec...

are you just trying to date stamp the record 24 weeks from entry date?

Okay. sounds like you need a bit more complex solution than a simple query.

You are close. Change your code to this: ReportQueryName = "qryrptFM83" Set qry = CurrentDb.QueryDefs(ReportQueryName) strSQL = "SELECT * FROM tblAgencyRequests WHERE AgencyRequestID = " & Me.AgencyRequestID qry.SQL = strSQL You didn't change my sample query names and fieldIDs. I see your...

Well, first off you don't want to store your data this way. I would recommend changing your table structure. You should not have the years listed as separate fields. You really should have a relational table that has fields to store the country, the year, and production values. You will...

You need to use the DateAdd function to calculate the date. http://www.techonthenet.com/access/functions/date/dateadd.php So you can write a query that will bring up all records within your time period: This would show you all records where the cutoff is within the next 5 days. select *...

Put this in your query for column 1 =iif(column2 <> "",[column2] = [column2] & " add your extra wording here",[column2]) basically the first comma is your THEN and the 2nd comma is your ELSE.

also are you doing a word mail merge from Access?

When you say next field do you mean the next Record?

You need to use the Docmd.OpenReport function and pass a WHERE argument in: Private Sub YourButton_Click() DoCmd.OpenReport "ClientReportPage1", acViewNormal, , "ClientID=" & ClientID end sub Create the same statement for each report. This needs to go behind your button_Click event procedure

Before using the Docmd.SendObject to send a report you will have to modify the reports recordsource dynamically. You can't pass a WHERE statement to the report via SendObject. This simply will send the entire report. So what you need to do is: 1. Make sure the recordsource of your report is...

Well, honestly, I tend to stay away from parameterized queries or prompts. I control any kind of input or search in a separate form. So you could create an interim form to open one or either form by itself. Sorry to send you in a different direction here but I would create a new unbound dialog...

Oops. sorry. No, you just want to clear the funding source selected in your main contact form, right? Thats easy just change my code to if me.optFund=2 then ComboBox = Null end if ComboBox is the name of your funding source drop down that the user selected if they chose yes in the option

Yes. remove that from the filter. This is what is causing your prompt for the parameter value.

This is similar to what I was suggesting. But what's the 1 and 4 after the day name? How are you going to match up the date with the day name in your table. For instance, if your start date is Sunday 2/3/2013 you would have to convert that date to the day name and then match it up with the...