Search results

I know that I am not using this variable. I was just doing a test. I am clueless

I fixed the issue with the 01/03/1900. It was the variable type. The issue is the SQL on the quarter part that is not pulling the any information Public Sub FRFilter() Dim TodayDate As Date Dim MyDatePart As Integer Dim DBDatePart As Integer TodayDate = Format(Date, "mm,dd,yyyy")...

I am just trying to pull all the value from TaskDueDate base on the current quarter

When I am evaluating that part, it return a false result If STFilter = "" Then Select Case Me!cbodatefilter Case 1 ' This Month STFilter = " month(taskduedate) = " & Month(TodayDate) & "" Debug.Print STFilter Case 2 ' This Quarter...

Re: VBA Incorrect DatePart Result it does not work. I am still getting the same result

I have the following code which I am trying to pull out the quarter for the current date. I have a variable for the current date and it is storing the date correctly, the issue is when I got to the select case for the quarter today's date turns in 01/03/1900. Any guide will be greatly...

This is great information but I could not figure out the problem with my SQL

I will gladly apricate any help from this forum regarding this code. I am passing various value from one from to another. The first part of the SQL works fine by when I adding another value it does not work. I tried the value with a variable and still I get the mismatch. Private Sub...

Thanks It works

I have the following code and it is giving me the missing operator error and I can not figure out how to fix it. Any help will be greatly appreciated. Option Compare Database Option Explicit Private Sub Form_Open(Cancel As Integer) Call taskschedule Me.AllowEdits = False Dim SQLDataSource As...

Thanks; What other way can I look for more than one value

I am looking for a value A on a recordset. If the value is not present, I need to added to the table

I not un expert on VBA and I am looking for some advice regarding this code. I have two recordset and I am trying to find a combine value. I am not sure if this concatenation is a good way to look for this value. I concatenate value from three columns and I am looking to make sure this value...

The issue with this is if the application does not start on the schedule what will happen to the procedure

I would like some guidance on running a procedure or function base on schedule. Something like first day of the month or the 15 of the month

Thanks for this information. It is very helpful

I did not copy the full sub. the recordset is just pulling the information the corresponding table to create a new one as filtered. The information for BEntity this the additional on the combo box that I want to add it to the criteria

I am just trying to add another criteria here. [CODE]StrWhere = " WHERE [tbbilling.benefitsID] in " & _ "(" & Left(StrIn, Len(StrIn) - 1) & ")"

I am not an expert. I just try to get some guidance.

How do I add another where criteria to the code you send on the link.like aso pulling data from a combo box