I use Access as my frontend and MySQL as back end.
I have a main table called client t1.
Clients have many Accounts t2 (1:M) between t1 and t2.
The accounts have Creditors t3 -technically a (Many Accounts :Many Creditors) relationship between t2 and t3.
Between the accounts and creditors...
It is being used for user authorization at the form level. Users get access to forms based on role ID. I'm looking for a comprehensive list for a documentation table and to determine who gets what across roles and finally, to import into the table - the initial list is pretty hefty.
Hello. Does anyone know of a way to select all the objects in Access and then export the names of the forms to a spreadsheet. One can be selected but if you go to multiples you lose the export capability and copy and paste doesn't seem to work either. Any Ideas? Thanks.
Hey There! I have come across a question I am hoping you can answer. I have the process almost completed for the Tunnel and I am at the clean up stage for the last two functions CloseSSHTunnel and KillProcByPID. I am getting a compile error for the KillProcByPID function when called. Can you...
Hello. I have a main menu that has these three things on it: 1) a tunnel status, 2) an ADO state connection and 3) a set of buttons tied to role with case statement based on temp vars. The code I have is hanging up (not responding) - I believe I am close but it still needs some refining. If...
Hello. I have a database that will have the following scenario: a form will check to see if a record exists in a table as part of a calculation nz(dsum function). When no record exists yet (and this will happen) I was getting an error. I have built a workaround with a trigger. The trigger...
I am connection to remote:22 and port forwarding back to my 3307:localhost:3306. Using Access as frontend/mysql backend; my odbc connector is using port 3306 for traffic while inside the tunnel running in the background thread. Do you see any issues with that?
Hi Cheeky. Thanks again for this - it's working out great. I do have a follow up question I was hoping you or someone could answer with confidence. The question is: does it matter if access is connected to a database before the tunneling or should tunneling be done first always. I know this...
Hello. I am in need of finding a solution to the following problem: I am running a batch file to create a secure tunnel SSH in command line upon login via code. Once the tunnel is established, I want to check that connection. If that connection is "established" or live for that user, I want then...
Here is what I am doing and these are all for one table- tbldocuments:
I am going to a documents table and looking up a match by three variables. 1) The record by client number (foreign key = [tblClients_fldDRCClientID] then 2) [RelatedDebtAcctNo] that matches what's on the screen and I want...
It doesn't like that. It seems to wants to treat the underscores as "invalid characters." It does work on one of the choices but does not work on all of them so, to me, it isn't recognizing the other choices. Any other thoughts?