Search results

@MajP @theDBguy you guys are awesome! I want to thank you for sticking this out with me! I got it working with MajPs function BUT tomorrow im going to try thedbguys function. Im quitting for tonight but thanks again!

@MajP I finally got a good result with your function but the result is like the image without a comma in-between each date. I changed your function around and called it from the reports query using Test: GetDates() and now it opens with no errors but like I said all jumbled together. Here is...

Ok now I'm starting to see what your doing but I'm getting a different error and it highlights Me.txtAbsentDates = GetDates(empID, AbDateMinus6, AbDate) that I put in my reports on open event. Run-time error'-2147352567 (800020009)': You cant assign a value to this object. The Debug.print...

@MajP your function confuses me because my SQL for the dates are Between DateAdd("m",-6,[Forms]![frm_CalendarInputBox]![subFormCalendarInputBox].[Form]![AbsenceDate]) So my start date is "AbsenceDate" and my end date is "DateAdd("m",-6". Would I use it like...

@theDBguy I wouldn't know how to modify that code to work.... Sorry I didn't see your last post before I posted with the error.

@MajP I tried that and I get a error Run-time error '3061': Too few parameters. Expected 2.

@theDBguy I'm lost with this and am not getting it...... I have a query that gives me a result of one row of dates "AbsenceDate". With the code you provided how do I get that querys result to be one row of dates? SQL: SELECT FROM tbluAbsenceCodes INNER JOIN tbl_YearCalendar ON...

Ok thanks.... Im going to check it out now!

Hello, I have a query that gives me a list of dates from (AbsentDate) and I want to get a result as a row each separated by a comma and not a column like in the image. How is this done? Thanks

That works thanks...

Hello, I need to have my forms textbox to have the current weeks Fridays date as a default value. In my formula what am I missing it gives me #Name?. =DateAdd("d", 8 - Weekday(Date(), vbFriday), Date())

@Minty, thank you the days out works and with it being code day Ill get the Report Runtime 🤪 Function fnGetRuntime(sStringIn As String) As String 'Purpose: to get date and time report was ran 'Use: Runtime: fnGetRuntime([TableFieldName]) Dim iStartPos As Integer Dim iEndPos As...

The way its written is always the same except the date and time and the days out number will change.

Hello, I have a long string that I need to retrieve and display 2 parts of the text. Can someone tell me how to go about this? Report Runtime: 07-JUL-2021 06.06.00 AM SCM_Test_Supply_Demand_Analysis - Test Supply Demand Analysis Item Number : '%' , Planner Code : '%' , Days Out : '10' ...

No not missing any headers. I think it has to do with the .xls, Recently we introduced a label you have to set for everything (image below). What's weird is when I open the .xls it makes itself really small (like 1"X3") then expands and adjusts itself. It has no macros that I can see...

I did give what was asked.... The highlighted code, below is the whole code. Private Sub cmdSelectXLSFile_Click() 'Requires reference to Microsoft Office 12.0 Object Library. Dim fDialog As Office.FileDialog 'Declares variable Dim varfile As Variant 'Variant type variable that...

What's weird is if I open the newly downloaded workbook and open it and save it then open access and try importing the file it works just fine BUT if I don't open and save it first then I get this error.

Ok I thought I had it but when I distributed someone said there was an error. Now I looked at the Help and not really sure why I am getting this error?

I missed something sorry thought I was finished.... I also needed to import a single row into a separate table lets call it tbl_TEST with a field called F1. I have imported the row BUT this single line has a bunch of jumbled up text and I need it to say: Report Runtime: 05/11/2021 07.27.02 AM...

Thanks everyone that was the issue....