It worked!! Thank you so much for all of your help, you did so much. I didn't realize that was wrong, so thank you for teaching me too.
For others looking at this it was all helpful, not just the one I marked as the best answer.
AnnMV8
Last Activity: Aug 7 '12, 03:00 PM
Joined: Feb 17 '10
Location:
-
I made the change to the header and it worked great. It was the time instead of the date but I'm so glad it showed something. Thank you!!Leave a comment:
-
Database
I have attached the database in a zip file. There are many objects but the ones I am using are:
frmCallDetailsF orAllAgentsBySu pervisor - this is where the parameters are entered and passed to the query when the Apply Filter button is clicked. Where I also am adding the code to pass to the report. I choice I use from the two dropdowns are Toledo and Andrea Lipinski. The Start and End dates are 01/01/2012...Leave a comment:
-
It still didn't work. I'm not receiving an error but the text box is empty. The text box is an Unbound text box named txtDatePeriod and there isn't a Control Source. Did I do that wrong? Is there a way I can attache my database?
This makes sense I just don't know what I've done wrong.
Sorry about the tags.Leave a comment:
-
Thank you for helping me. I did what you said but am receiving a compile error on txtDatePeriod. Method or data member not found.
Here is the changed code.
...Code:'If the report is closed, open the report If SysCmd(acSysCmdGetObjectState, acReport, "rptCallDetailsForAllAgentsBySupervisor") <> acObjStateOpen Then DoCmd.OpenReport "rptCallDetailsForAllAgentsBySupervisor",Last edited by Rabbit; Jul 24 '12, 03:38 PM. Reason: Please use code tags when posting code. This is your second warning.Leave a comment:
-
Passing parameters to query and report
I have a button on a form that passes parameters to a query and opens a report. The code is listed below (someone helped me with this a long time ago and I kept it and reuse it). This works without a problem but what I need to do is also pass [dtmStartDate] and [dtmEndDate] which both get passed to [dtmSessionDate] in the query to the report that is opened.
Since both fields are being passed to the field [dtmSessionDate] in the query... -
Outlook Reply/Reply All
I am using Outlook 2010 on Windows XP. My PC was reimaged and now the Reply and Reply All buttons on the ribbon inside of an email will not work. Any ideas? I can open an email and the Ctrl+R works and so does Forward but when I click Reply or Reply All nothings happens. Thanks for the help. -
Counting
I am using Access 2010 and am just learning some of this. I have a report that is grouped by Agent with a header and footer for this group. I then list the calls an agent took. I put the agents name field in the header and am trying to count how many agents I have per report by putting =Count([txtAgentName]) in the Agent footer. When I run the report there is one agent name with 7 calls. The code in the footer shows 7. It should be 1. I only... -
I already had tried all of that plus many other suggestions from this thread and I still have a blank page.Leave a comment:
-
Reports
I am using Access 2010 and created reports that has a section break after my Agent footer. This is the only field I grouped on so besides he report footer there isn't any other footer. This is also the only break I have and I continue to get a blank page after my last section with data. Why does Access keep adding a blank page? -
Thank you so much, that worked.Leave a comment:
-
Syntax, Missing Operator
I have a form where I enter the Agent Name, Session Type, Start and End Dates. I’ve done this in the past but not with a Between statement and have not had a problem. I use the code below to put together a statement with the parameters I enter in the form.
I’m not a programmer so I’m not sure what the syntax problem is. I'm hoping someone can help me with this. Thanks in advance.
This is the error I am receiving... -
Unfortunately, I don't know. I'm not a programmer so that is why I was hoping to get it done with an IF statement and a message box, I can write some of those.Leave a comment:
-
I looked at the Me.Recordset.Ed itMode which referenced the EditModeEnum and it's values. Is it possible to program an IF statement that says if it's any of the Constants with their corresponding Value don't do anything, otherwise, send the message? I'm just guessing here since I'm not a programmer.Leave a comment:
-
Thank you. I appreciate all the help I can get and will look at Me.Recordset.Ed itMode to understand what it is and does.Leave a comment:
-
Identify a Locked Record?
I have set the Record Locked property to Edited Record so only one user can make changes at a time (using Access 2003). The circle with the line through it appears but everyone is freaking out that they can't make changes. The MS message doesn't appear that lists three choices which is fine because I don't want to allow them to do anything but move on to a different record until the person with the record open is done.
So, what I... -
Thank you for your help. I still had problems with this but did manage to get the it to work a different way. I really don't understand IN and it's a hard thing to Google. I went back to the original way. I'm not sure if it's the best way but it does work. The code is below:
Dim frm As Form, ctl As ListBox, var As Variant
Dim strCriteria As String, temp As String
'Dim dtmStartDate As Date
'Dim txtCourseTitle As String...Leave a comment:
-
Multiple Criteria in Code
Hi,
I'm hoping someone can help me. I'm not a programmer but found this really nice piece of code that I have been using but it needs to be altered. I had been getting help from Microsoft's website but then they stopped.
I am using Access 2002. I have the following code on a button which was altered by someone who had been helping me but it still doesn't work. The code allows me to pick multiple Course Titles from... -
I posted a reply to you with the calculation that I couldn't find. It doesn't seem to have shown up. The one that is there is the second time I posted it. Plus, when I was trying to see all the questions and answers I couldn't. My quote mesag in reply button doesn't always work either.Leave a comment:
-
They aren't the field names but I counted the characters in the actual string and 255 comes up at the 11th field and I can still get a good result up to and including the 13th character. Plus if it were the length none of them would work because I would always be missing the ending ). It has something to do with the versions since 2003 doesn't get the error but 2002 does. I would think there would be documentation somewhere on the Internet. Thanks...Leave a comment:
No activity results to display
Leave a comment: