Recent content by AccessMSSQL

  1. A

    Whats Worng with my Dsum Function?

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

    Query with DateDiff Function

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

    Is there a way to open second report if field is null or...

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

    Flags for dates reminder

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

    Create Print Button To Print Only One Record

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

    Flags for dates reminder

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

    Flags for dates reminder

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

    Flags for dates reminder

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

    Email Current Record as PDF

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

    Populating listbox on a form using multiple fields.

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

    Flags for dates reminder

    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 *...
  12. A

    Using IIf in a query in Access Database

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

    Using IIf in a query in Access Database

    also are you doing a word mail merge from Access?
  14. A

    Using IIf in a query in Access Database

    When you say next field do you mean the next Record?
  15. A

    Create Print Button To Print Only One 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
See more
Top Bottom