Search results

oh... that's a novel way to approach it, I like it....except... this line is producing a syntax error. If Lcase(Left(tb.Name),7)) = "textbox" Then

Darrell, That's fantastic! Thank you so much for taking the time to do that..... so, if I want to clear the back ground color - or reset... would it be something like this? Sub TextBoxReset() Dim wks As Worksheet, tb As Shape For Each wks In ActiveWorkbook.Worksheets For Each tb...

Thank you for responding, Gasman... If what you meant by this statement: "So type that statement in afresh and see what intellisense allows you.?" is this: it will not prompt for "TextFrame"... only Text..... As for the link you sent, that applies to a textbox in Access. I am...

Hi Gasman, The code is something I found here: https://excel.tips.net/T011281_Finding_Text_in_Text_Boxes.html The code actually gets hung up in this line when I run it: sTemp = LCase(tb.TextFrame.Characters.Text) With an: Object doesn't support this property or method error

I am hoping someone can get me over a hurdle. I have a workbook with a dozen worksheets and each worksheet contains an image and several textboxes. I need to be able to loop through each worksheet in the workbook to find specific text in a textbox and once found, change the background color to...

Just getting back to this after a week... Thank you, Arnel, but that function is giving me the same results as the function I posted at the beginning of this thread... in that it is resetting the week number with each new month.

hmm... getting decimals with that one, Mark....since some months start mid-week...?

Scrap that... that IIF statement won't work.... sigh :banghead: I am trying to build a schedule... I have calculated the working days for each month and I need to determine the week number corresponding to the date, BUT the week number for the first week of the schedule needs to be 1 and not...

I created a field on a form called "WeekCount" that counts the number of weeks in my date range using DateDiff and then added this field to my query.... WKNo...

Thank you, plog, I have looked at those posts. I don't want to count the number of weeks as the DateDiff function will do... =Int(DateDiff("d", #8/1/2018#, #3/4/2019#) / 7) will give me 30 weeks ...and the start date will always be the first of the month. So regardless if the first if the...

Not sure how I would adjust when the calendar year changes?

Good afternoon, I am working in Access 2016 and I am trying to build a query which will return a week number, starting at 1 between two dates. So I do not want the standard or ISO Week number. If I choose a date range between 08/01/2018 and 02/28/2019, I want it to number from week 1 to week...

Actually what I did was with this first recordset that determines the email to send to: Set rs = db.OpenRecordset("SELECT DISTINCT AreaName, Email, AreaID" & _ " FROM qrySTWFollowUp") I added the following to the second recordset that provides the data to the body of the email I send...

So I am already looping through the recordset that has the group IDs and email addresses for the supervisors. Set rs = db.OpenRecordset("SELECT DISTINCT AreaName, Email" & _ " FROM qrySTWFollowUpEmail WHERE qrySTWFollowUpEmail.FUDate <=#" &...

Would a For Each Loop work to go through each group ?? I've never done that and not sure where to place it in the code... researching now, but any advice would be appreciated...

Thank you, Uncle Gizmo. I have just solved the multiple email issue... but I still am seeing all of the audit follow-ups going to each supervisor. What I need is for the follow-ups for just Group 1 to go to the Supervisor for Group one and for the ones for Group 2 to go to the Supervisor...

Hello All! I am hoping you can help me with a looping / querydef problem. I am trying to send an email to each supervisor who has an outstanding follow-up on an audit based on the results from this query. I am using Access and Outlook 2016. SELECT Audit.GroupID, Audit.TMName, Audit.Process...

I have been searching for an answer and have had no luck. I am using Access 2016 and I am trying to build an aggregate query that will pull results based on two scenarios. I can get one to work, but not the other and I don't know where else to look or try. I have a table that stores audit...

Hello, I tried to put the code to close all forms into the database where the database prompts the user to close, but the same error message came up as well.

Oh, thank you Arnel... I didn't think of the timer...! But the problem is, I have a separate timer interval on the security form to determine the shift date. Our afternoon shift continues to run after midnight so I have a timer on the security form so that if the time is after midnight, to...