Search results

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

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

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

Hi all! I'm having a problem that i really can't figure out why it happens (my bad of course...) I'm making a database to manage properties and there i have a form to search the properties, like this: The list of properties is a continuous subform that has the address, the view button and...

Hi there! I'm getting crazy with a code i wrote to set a formula on a cell through vba. I have a workbook with as many sheets as the days in the month. in each sheet i have a table with 3 columns: client, address and value. When i change a value in the first column (selecting from a validation...

Good morning. I have a problem... I can't figure out how to change the border color of the forms i have... In the screenshot below the border is dark pink... And i don't want that. Does anyone know how to do this since there is no border color property for the form? Thanks

Good morning! I'm having a little problem... I want to send a mail from VBA in access as part of a "forgot password" routine. Basically i want to send a mail with a random 4 digit code to ensure that the person who is asking the pass change is the one who owns the account. The part of the...

Hi there. My name is Carlos and i'm from Portugal, I'm not new to microsoft access (done some databases a long time ago), but now i returned to it so i'm not a very experienced database coder. Thanks for recieving me in this community! And sorry for my english... Not my native language... Be...