Search results

This is the code. TxtRecDate is formatted as short date Private Sub btxopen_Click() Dim RecDates As TempVars TempVars!RecDates = Me.txtRecDate.Value Me.Text3.Requery MsgBox ("<<<" & TempVars!RecDates) End Sub

I have the TempVars under a textbox from a from. I am entering the date on the form and I want to pull this date in a query so I can process some calculation. I follow your instructions and I create a new query to I can see the value by itself and I does not return anything

Thanks Steve for the information I have a date value in the tempvars that I want to place in a column for a calculation and I try this and it does not work. I just create a new query with your information and the column does not return any value

Hi All Can I use the value of a Tempvars as a column value in a query

it does not work with my numbers

Thanks for all your help I was testing this code and it failed on June. It should be 5 and I get 4

I am confused. It looks that the function does not works when the start date falls after Thursday. My concern is how can I tell the function that I am counting Thursday. I tested September 2017 and I am getting 5 instead of 4 Private Function CountThrs() As Integer Dim STDate As Date Dim...

I was using part of your idea but I got in trouble when the date falls after Thursday

Hi all I am new to Access/VBA and I have this issue which I have not been able to figure out. I am building this function to count the number of Thursday between two days base on the pay frequency(1 Weekly, 2 Biweekly, 3 Monthly). The start date and ending date is not fix. Each employee...

Thanks for the guide. I was able to fix my issue with your comments

Hi I have this issue and I could not find any better solution to this than have the ID included in the column count. So when you open the form, you will see the ID

Hola Chequea el DatePedido format: it should be datepedido = Format(Me.txtFecha, "dd/mm/yyyy")

Hi all I need some guidance regarding this VBA Function. I created the following function to add deduction based on these parameters. I create some variable with value to test to make sure it works, and it does. The issue is when I tested with real date in a query I was getting an error...

Hi As we know, aggregate functions take a long time to return results when you can lots of data. What are the alternatives of using DSum ?

Thanks for your precise response.

Hello: I new to the database and I am trying to build a query and I can not get this function to work. I will appreciate any help on this function. DSumAmt: DSum("[deductionamount]","tbpayrolldeduction","[employeeID]=" & [tbpayrolldeduction]![EmployeeID] And "[BenefitsID] =" &...

I am a new member