Search results

no... perfect...Thank you very much..much better than my beginner method

no...

it works perfect when difference up to 3 months ..but it less than 30 days when difference between 1 to 3 months

The customer asked me to

This is my attempt at querying

Hi Expert.. Is there a function through which all months can be considered to have 30 days, so that when I subtract a first date from a second date, the months are considered to have 30 days? so i get the Result of days I can do it with a query but can it do it with vba thank you All

i dont kow ... its operating good now

OMG.. when I used my function and function of GustavBrock there are 3 days difference when i enter DOB= 12/3/2000 TO date ()

Hello, my Experts.... I have a function that calculates the number of years, months and days of real service for the employee.. taking into account the leap years in that period.. but I am not sure that it calculates the leap years.. Is there a proven function for this purpose with the long...

Now I read your post...how amazing you are...much better than what I came up with..its perfect

I found the solution... Thank you guys Actually I was searching for records in one form through another form

u can see it when use the form search "form1"

Hi all experts.. I found this file on one of the respected sites..and when I enter a value in the search box, it shows me the records..and it works fine.. I tried to create another form that has a text box to search in that form..I tried a lot, but it shows me an error..any advice, I am...

thank you cheekybuddha.. its simple and good for now..I dont know if I will get more complex at future

Hi experts.. I get some code below from CHAT-GPT to close form after 10 second when mouse not move is there any suggest ..thanks Private Declare PtrSafe Function GetCursorPos Lib "user32" (lpPoint As POINTAPI) As Long Private Type POINTAPI X As Long Y As Long End Type Private m_x As...

Hi ,Expert I have 3 field in query as shown ...I have yearNu and monthNub ... and subtractMomonth ..when I enter 15 in subtractMomonth ..the resault is YearNu=18 and MonthNu=11...is there function to do do this thanks for all

thank you all for reply...i used dlookup before but doing error because small mistak Dim intID As Integer Dim strField As String intID = Me.txtID strField = "Field" & Me.txtField Me.txtResult = DLookup(strField, "MyTable", "ID=" & intID) I used strField between double quotation.. and now its...

Hi, I have table as shown ..and I have form with 3 textbox txtID,txtField,txtResult how can I get txtResult=125 when txtID=2 and txtField=field2 any suggest for that...thank you

t thank you Gasman ..its perfect now .. Although I use (yyyy/mm/dd) in my pc thanks theDBguy for your function thanks CarlettoFed ..but that not i want it

But its still Empty