Search results

  1. D

    Many to Many Question Regarding Normalization

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

    Solved A way to select all form objects and export to a spreadsheet or copy

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

    Solved A way to select all form objects and export to a spreadsheet or copy

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

    Solved check ssh tunnel status for live connection in vba

    When stepping through it I found an extra call in the logoff not needed. Thanks for your help on this one - worked out great!
  5. D

    Solved check ssh tunnel status for live connection in vba

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

    Open menu - looping until closed

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

    No record yet for dsum process

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

    Solved check ssh tunnel status for live connection in vba

    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?
  9. D

    Solved check ssh tunnel status for live connection in vba

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

    Solved check ssh tunnel status for live connection in vba

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

    DLookup help

    I have retested. It is working fine as is. I must have been inputting something wrong originally. Thanks for your inputs. :p
  12. D

    DLookup help

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

    DLookup help

    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?
  14. D

    DLookup help

    Hello. The Dlookup below works but does not seem to distinguish between the (1,4,5) [tblSubject_SubjectCode] criteria. Do I have the syntax right for this? I am looking for any of the three - it could be literally a 1 or 4 or 5 in that field. Any help with this would be appreciated ...
  15. D

    Group by issue with T4 statement

    Here's the catch: Table T3 (NSF) may not have a record for the client (sometimes yes sometimes no). NSF's only happen when they happen. If there IS a record even with a zero value and I use Or Not Exists - it works. When there is NO NSF record for that client and I use Or Not Exists it runs...
  16. D

    Group by issue with T4 statement

    Hello. The included query runs fine up to the Is Null statement. I am adding the T4 statement and getting a group by error. The trouble is with the Last Statement! Any help to straighten it out would be appreciated. Thanks. UPDATE tblDebtAccountNumber SET fldSOI = "0" WHERE...
  17. D

    DLookup criteria help ...

    The combo of both solutions worked. Thanks! Here is the final for those who may want it in the future... =Nz(DLookUp("[DocNumber]","tblDocuments","[tblClients_fldDRCClientID]=" & [Forms]![frmScreen_SubformTestingPB]![MeFKID] & " And [RelatedDebtAcctNo] =...
  18. D

    DLookup criteria help ...

    Hello. I have the following dlookup scenario: =Nz(DLookUp("[DocNumber]","tblDocuments","[tblClients_fldDRCClientID]=" & [Forms]![frmScreen_SubformTestingPB]![MeFKID] & "And [RelatedDebtAcctNo] = [Forms]![frmScreen_SubformTestingPB]![txtAcctNumber]" & "And [tblSubject_SubjectCode] In ('1'...
Top Bottom