Search results

Good morning guys... Solved the problem in a very simple way!!! Thanks @Isaac for the eye opening comment!!! Here is the code i will use: Private Sub test() Dim rsTable As Recordset On Error GoTo errorHandler Set rsTable = CurrentDb.OpenRecordset("SELECT tbl_Utilizadores.*...

Thanks @Isaac You're right! I just need to try to read something from One table with error handling... Then if there's an error it means that i can't connect for some reason... I was definitely going the hard way... Thanks!!

thanks @AHeyne, in fact there was that typo there... When i removed it it gave another error concerning the provider itself. After research foud out that i need to use the Microsoft.ACE.OLEDB.16.0 provider... It worked with this one but now the result is diferent... It gives me always as if...

Hi guys, I'm going to deploy a DB frontend to users that connects to a backend DB where the tables reside. Since the backend will be in a shared file server folder, i need to check if the connection is possible (the server may be down for example) every time the frontend is launched. The path...

It worked. Thanks @Gasman and @Jon Be cool Cheers

It should be... But it's not there...

Hi @AHeyne. Done what you told and it worked like a charm... Thanks a lot for the help. @Josef P. Gave a look at MZ-Tools but it's a paid tool... I'm doing this DB pro-bono so i won't buy it for sure. But thanks for the suggestion! The problem is solved so this thread can be locked as...

Hi @AHeyne, thanks for the answer! No… I saw this implementation in a couple of sites and none mentioned this… If they did be sure i wouldn’t be here asking you guys! Thanks for this explanation! Tomorrow i’ll do this as soon as i get to work! Thanks a lot! Cheers!

Hi @Mike Krailo In the second piece of code i put in my post. In the Sub newImovel()

Hi @theDBguy Do you mean in the Create function? Well in my research the New keyword was in all the examples i found.

Good afternoon all. Since VBA doesn't have parameterized constructors, i've been trying to implement a factory in a class. This is the code í've done so far, after looking up in the net: Option Compare Database Option Explicit Private myImovelID As Integer Public Function Create(ByVal...

Thanks @Gasman

Thanks guys for all your help. Didn't know that SQL always expects USA format, regardless of the machine definitions. I changed the line to textCtrl = "#" & Format(currCtrl, "mm/dd/yyyy") & "#" and it worked. Thanks again. Cheers

Hi @Gasman, thanks for the answer. So when i construct my SQL i need to put the dates in the mm/dd/yyyy format??? But my textbox is in dd/mm/yyyy so i'll need to reconstruct the date to the correct form??

Hi all. I'm having a problem that is getting me nuts... I have a form to make updates to my tables that has a tab control with several pages. Each page is for a specific update. Then i made this sub to update the corresponding fields of the tables: Private Sub updateImovel(myTable As String...

Well, just put a transparent button above the image and it worked beautifully! Thanks again for all your help! I really appreciate it! And sorry if my english isn't the best and make some mistakes... Not my first language! I'll mark this thread as solved! Wish you all a great weekend!

Guys now i feel real bad… I’m on my phone and when i clicked in the mail link it took me to the second page and didn’t noticed that, só just realized that i missed a couple of posts from you guys… 😓 I’m realy sorry! But i did use the debug.print as @Gasman sugested! (It have always 2) But just...

Sorry… My bad! Should have said that it’s an image… 😢

Right! I was just wondering it might be the image! (was typing preciosa post and only saw this one after submiting…) i’ll put a button instead of an image… thanks guys! You were an amazing help!

I did it… always passes 2… but i was thinking… maybe the button (which is a simple image) is “hardlinked” to the first record of the recordset? I had to leave work and can’t work on the DB now… But i’ll get to it soon… thanks you all for the help!