Recent content by disgracept

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...