Search results

I have a form in continuous view. In the detail section I have records where amount filed is need to be enter in the text box TXTAMT. I have a text box TXTTOTAL in the header section where it should shows the sum total as i enter the amount in each records. code i used TXTTOTAL=sum([TXTAMT]) but...

Thnaks a lot sir..... its perfectly working.. this forum is relay wonderful I am learning alot.

I HAVE A TABLE WHERE SERIAL NO IS AUTO GENERATED AND THE CORRESPONDING YEAR. i WAND TO HAVE TWO COMBO BOX SHEWING THE SERIAL NO AND THE YEAR. i WANT TO FIND THE RECORDS BASED ON THE SERIAL NO SELECTED FROM COMBO SERIAL NO BASE ON THE YEAR IN COMYEAR I HAVE TRIED WITH THE CODE BUT NOT WORKING...

I have a form in which five text boxes (unbound) are there. Records are added through a Sub form in data sheet view. Is it possible to add records in two different tables simultaneously. First table should fetch all the data and the second one only two fields.

thanks dear....

I have a query based on relation ship of two tables having common field (primary key) Called DV contain value like 11 of 04/2020, means sl no 11 of April 2020, I wanted to get the month name from DV by using formula MN: MonthName(Left(Right([DV],7),2)), but it gives error showing this DV could...

tHHNS

Thanks

Thanks for the help. I made an update Querrey as per your guidance and it is working fine... Thanks

I have a Sub form (datasheet View) I have a Check box to selct the items selected for payment, is there any process to select all at a time (if required) without selecting each at a time

I got your point. Thanks ,cheekybuddha Any way It helped me to get the solution... Have great and safe stay....

Hi I have created a login form with user ID and the Password Text Box The problem is that while putting the password it accepts the password o any available password and loin into the system . I am not getting how the vba code is below: Public Sub Login() 'Option Compare Binary Dim...

Thank you sir.... Its working fine.... Have a safe stay...

My Append Query SQL is INSERT INTO tblLoginTime ( UserName, LoginTime, LogOutTime ) SELECT GetLoginUser() AS Expr1, Now() AS LogIn, Null AS LogOut FROM tblLoginTime; and I am calling a Temp variable from login Form, syntex is TempVars!TempUserLogin = Me.Txtuser.value

Its working... But every time i runs the query it doubling the records. That means running first time id append one record, on second time it append same record twice and on third time it append four times and so on.. I am confused.

I have not done the coding... but thinking of using the variable to make a Login Tracking table through append querry,.. I am not sure Please suggest

I have a Global Variable StrUser (Name of the User Login) Cam I use this Global Variable to append a Table though Append querry

Yes... Dear thanks.. Can you give some suggestion on the issue.