Search results

I have never attached anything to one of these posts so I hope I am doing this right. Let me know if you don't see it.

Hi Everyone - I have a problem when I try to use a sequence field in another query. I have a query called qryIncidentDropOffDates. In this query I have created a field called "Sequence" with the following: (SELECT Count(*) FROM qryIncidents AS T WHERE T.SVNumber =...

That's perfect! Thank you so much! :D

Hello everyone - I was wondering if there is a way to automatically set a multi-page report to print double-sided through Access or VBA. Thank you in advance. ;)

Hi Pat - I have done a little research this morning on the runtime version and it does sound like that is what they are pushing out in the update. I am going to read up on it more today so I can hopefully answer any questions they have. Thank you for pointing me in the right direction! :)

Hello everyone - We have begun migrating to Office 2010 where I work. All of our databases were created in Access 2003 and have remained in this format since the majority of them use user-level security. When we switched to 2007, there were some minor issues with macros that were easily...

Thank you so much! That is perfect. I wasn't using the "with" statement and also was using the wrong syntax with the &","&. Thanks again!! :):):)

Hi everyone - I have an option group (grpSortBy) on a form (frmMenuHR) where the end user will select the field they want a report to be sorted by. The OnLoad event of the report has the following code: Me.OrderBy = Forms!frmMenuHR!grpSortBy This works perfect for one field sorting but...

Sorry for the delay but I am just getting back to this project today. That code worked exactly like I needed it to!! Thank you so much!:):)

Hi everyone - This seems like it shouldn't be so difficult but I am just not able to get it right. I have four text boxes on a form. BeginningDate, BeginningTime, EndingDate and EndingTime. I want to pull all the records that fall between the beginning date and time and the ending date and...

Hello everyone - I created a report (srptLeanIdeaSpecificName) to be used as a subreport. There is a text box with the following on the control line: =IIf([LeanIdeaNumber] Is Null,"This associate has not been assigned to or a team member of any other lean idea projects."," ") Using this...

I put that expression in the query and it was perfect! Thank you again for your help!

Thank you for the quick response! I moved it to the format event and it worked perfectly. :) However, it raised another question... The field is no longer visible but the value is still included in a text box I have to total the numbers in the footer. Is there a way of removing it...

Hello everyone - I have the following code in the OnOpen event of a subreport: Private Sub Report_Open(Cancel As Integer) If Me.[Period] < Me.[CurrentPeriod] Then Me.[CurrentFiscalActualSales].Visible = True Else Me.[CurrentFiscalActualSales].Visible = False End If End Sub When I open the...

Hi everyone! I hope I explain this clearly enough. I have two queries created from a separate query. One (qryLoadDiagramLeft) pulls all the entries with "L" in the position field and the other (qryLoadDiagramRight) pulls all the entries with "R" in the position field. I am using these...

Oh yes!! That works exactly how I want it to! Thank you so much! Trying to learn to write code on my own as I go is very frustrating because I don't know all the little details and those little details make or break it. This forum has been a great tool for me and I appreciate you and...

Hi everyone - I am having problems with using a concatenate function in my database. I am using Allen Browne's sample: Public Function ConcatRelated(strField As String, _ strTable As String, _ Optional strWhere As String, _ Optional strOrderBy As String, _ Optional strSeparator = ", ") As...

Can someone help me create a hyperlink to a secured database? I would like to add a button to a form that, when clicked, will open to a secured database. At this time, what I have works....sort of. I have a button with this text in the "Hyperlink Address" property...

Yes that is the name of the text box. I originally had "CompletionNeededBy" as the name. In my research of this problem, I saw someone write that if the name of the text box is the same as the control source "Access may become confused" so I changed the name adding "TextBox" to the end but it...

CompletionNeededByTextBox is enabled and it is not on a subform.