Search results

Forgive my ignorance, but what would that look like, and where in the code should it take place? I appreciate your time :)

Experts, I have a report that I open in acViewReport, acDialog mode. I am attempting to resize the report dialog so that the user press a button that takes a screen shot of the report and pastes it in an email. For reasons more complicated than I have time to explain here, SendObject isn't an...

That is exactly what I'm doing. It takes approximately 30 to 45 seconds to open. Any thoughts on how I can accomplish emailing this report?

To further clarify, I am using VBA to populate unbound fields on my report. The sql language creates a value which is populated into a variable, and this variable fills the fields on my report. Therefore, there is no single query bound to the report, and the SendObject function does not work...

Hello experts, I have a report in my Access 2010 DB that that my users have requested the ability to email. The SendObject function sends a blank copy as there is no bound query behind this report (the fields are populated by sql statements), so I'm hoping to be able to program a button to...

This worked elegantly and perfectly. Classic case of knowing what I wanted to do but not having the experience to know WHAT to do. Thank you so very kindly!

As an edit, to add: I see what you're saying about the "sql" domain being too large. It is indeed the "DAvg" line that is throwing the error. That being said, do you have any thoughts about how I can accomplish what I'm trying to do?

I'll do my best to explain. My query is counting up the total number of records in each year and this value is in the "CountOfID" field of my query result. For example, there might be three records in the recordset, one for each year. The total number of records might be 32, 26 and 14. I am...

Hello Experts, I'm attempting to get the average of a field in a recordset that groups results by year. Code is below. I am getting a "the field is not large enough for the data you attempted to paste" error and can't figure out why. Any ideas on what I'm doing wrong? Public Function...

Experts, Below is an XML ribbon I'm attempting to use for reports in my database. I have already selected this ribbon in the settings for each report. The reports are opening in an On_Click event in acViewReport, acDialog mode. For some reason, this ribbon is not appearing when I open...

I believe I figured this out. My query had other criteria that was preventing the new records from appearing in my subform when it was re-queried. Looks like I am in business now - the >=date() and < date() +1 in the CREATED field worked. Thank you :)

Thank you for these suggestions, the only one that worked is the >=date() and < date() +1 but this only works once. This query is behind a subform that re-queries when the user clicks a button to submit a record. It works fine the first time, then won't work again. I can't figure out why :(...

Hello experts, I have a query I'm building that searches for records created today. I have the below in my query that extracts the date portion of the date/time field called "CREATED" that shows when the record was entered in the DB: TheDate: DateValue([Created]) I'm trying to search on this...

This was perfectly helpful. Wound up going with the below, works like a charm. Thank you :) Private Function GetLabel() Dim varLabel As String If Report_rptNational.chkID = True Then varLabel = "Application Details Report - Identity Cases for the year " & Form_frmMain.cmboYear GetLabel =...

Thanks, but I have about 40 different conditions that require a different label for each. I don't think the IIF will work :(

I also tried the below, but it did not work either :( Private Sub GetLabel() Dim varLabel As String If Report_rptNational.chkID = True Then varLabel = "Application Details Report - Identity Cases for the year " & Form_frmMain.cmboYear End If End Sub Private Sub ReportHeader_Format(Cancel As...

Can you expand on what this IIF statement might look like? Thank you :)

Hello experts, I'm trying to set an unbound text box to display certain text based on whether a checkbox on another open report is true or false. Below is what I'm trying but I get a "you cannot assign a value to this object" error. Any idea what I'm doing wrong? Thanks in advance :)...

Now THAT is using the K.I.S.S method! Worked like a charm. Many thanks!:D

Hello experts, I have a report I'm designing that is grouped by month. The field from the DB that contains the month is a number field, 1 for January, 2 for February and so on. I'm grouping my report by this field, called [ExecMonth]. I'd like to display the month name based on the value of...