Search results

So nice of you.

Thanks a lot @MajP, can you please tell me which even will run first, forms module or class module?

Thanks @Ranman256 for reply. So I get that two classes can be initiated and run in a single form without issue. What about two same events i.e. one in form while other in a class module for same control?

Hello, I've two questions/confusions regarding class modules which I want to clear before I start working class modules for my forms. My form already have a class modules initialized. Now I want to add a code event on appx 80% of my textboxes on the forms plus same code will be applied to other...

Thanks a lot @arnelgp.

Thanks a lot. That will work for me.

Thanks @Galaxiom and @isladogs for reply. I've seen the demo in your website before posting here. But I don't have a second table. I just use this code to update one record at a time by inputting the value in code. PS. I'm using this code save some settings in a table. Mostly it only require...

Hello, I'm trying to use the following SQL to update a record in a table: SQL = "UPDATE " & TblName & " SET " & TblName & ".SValue = '" & SValue & "' WHERE (((" & TblName & ".SKeyword)= '" & SKeyword & "'));" ' Debug.Print SQL CurrentDb.Execute SQL Where SQL, TblName, SValue and...

Thanks @arnelgp for reply. The issue is resolved and that was not a issue but a mistake at that specific end. Older backed file was being used at that pc and that backend file didn't have required record in the table required for the function to run. I reported this post for deletion as it was...

Hi, What are reasons of #Size! error on report text fields. A report in accde is running fine on one PC with access 16 office 2019 while same file is giving #Size! in the text field on other pc on runtime 2016. Text field hold string value. Moreover, control source of the text box is a function...

Thanks a lot @gemma-the-husky, that is also doable. Thanks. I've two options now, side end db and your suggestion. I'll check both and will decide which way to go. Thanks again everybody. Stay healthy.

Thanks a lot again. I misunderstood, initially I was thinking that it will be on network that is why I thought it would be slower but now I get it. It could be on user's PC.

Thanks for the db @moke123.

I've read the mythbuster thread shared by @NauticalGent and also read the comments by @isladogs in the post. Thanks a lot @NauticalGent and @isladogs for the link and explaining.

Thanks a lot for the link. I'll check and get back here. Would side end db method not slower?

Hello, I need to create a temp table for my one subroutine to work. I have a sub on form load even which checks if temp table exists or not. If it doesn't, then it creates it. Should I delete the temp table while closing the form or let it remain for next time usage? Will creating and then...

Thanks everybody for reply. I got my answer.

Thanks for reply @gemma-the-husky I get following error message that says: The database is in an unrecognized format. The database may have been created with later version of Microsoft Access then the one your are using. I check and found that it can't be saved in .mdb format. Best Regards

Hello, I've developed my database in office 2019 created accde on the same computer system. When someone try to open it in office 2010, it gives error message: The database is in an unrecognized format. The database may have been created with later version of Microsoft Access then the one your...

Thanks a lot for this detailed information.