Search results

  1. I

    wrapping these code

    strSQL = "UPDATE tbl_student SET " & _ "student_lastname = '" & Me.txtlastname & _ "', student_firstname = '" & Me.txtfirstname _ & "', student_gender = '" & Me.cbogender & _...
  2. I

    wrapping these code

    like so that the sql statement isnt long, normally i would add a & _ at the end then " at the beginning of the new line, but for some reason it's not working :D (or maybe i just don't know how - this back end is mysql, diving into deeper waters here ;P)
  3. I

    wrapping these code

    so yeah, this may sound silly to some but how would you split the lines for this mysql statement? strSQL = "UPDATE tbl_student SET " & _ "student_lastname = '" & Me.txtlastname & "', student_firstname = '" & Me.txtfirstname & "', student_gender = '" &...
  4. I

    populate a field with a vba

    hey, so i have this code: Function startStudentPresAddress() strStartSql2 = "SELECT qry_address_student1.id_student_address, qry_address_student1.studadd_id_student, " _ & "qry_address_student1.studadd_id_address, qry_address_student1.address_street1, " _ &...
  5. I

    inserting ms access date field

    so i'm trying to insert a record using VBA with my mysql back end but am getting an incorrect date value error, anyway to fix this? i am using the ADOBD connection.
  6. I

    opening a mysql recordset

    so i have a 3 tables, table 1 (client info), table 2 (address) and table 3 (FK for table 1 and FK for table 2 - so they would be related), what i want to do is that when i open a record what would happen is the form would be filled with the data pulled by those three tables. how is this done...
  7. I

    need help writing this code

    yeah they do, how do i integrate the scope? this is with a mysql background.
  8. I

    need help writing this code

    I have attached an image better explaining what i want to accomplish.
  9. I

    need help writing this code

    so my goal here is to capture the last_insert_id then set it as a variable. because my tables are set up that the PK for table 1 and table 2 become the FKs for table 3 so that there is a reference for those records. so the idea is, insert record to table 1, capture last_insert_id insert record...
  10. I

    How to use Access with mysql

    this may be a year late but justhost allows remote mysql connections you just need to specify the ip address.
  11. I

    best practices in making the tables

    well that sounds about it, i just needed to confirm cause i never had made an sql back end before only msaccess but yeah, it guess it's a good idea to do what you said. thanks!
  12. I

    best practices in making the tables

    just want to read or hear good practices in terms of developing the table part of the sql server, like when creating a directory, do you store addresses in a different table altogether and just assign an FK to the client/employee table or create a table seperately with both client/employee and...
  13. I

    calling an api

    not exactly, cause their documentation has this guides that i must go through, so i guess i need to speak with them first. just that i am having no direction atm regarding how to approach this.
  14. I

    calling an api

    i already did, i saw the body for calling the api, it's an http post really, cause right now, the database or front end that the people are using is in access and slowly moving to web based php, but the thing is, we still are far away from that and just want integrate it as a temp patch or...
  15. I

    calling an api

    any idea how to call an api as a fax module? basically ringcentral has an api to use their fax api and want to know how to integrate that in ms access? any ideas to point me to the right direction?
  16. I

    equivalent to a continous form

    how or any samples for something like a continuous form in access?
  17. I

    OLE server error when inserting IEPDFPLUS

    am getting an ole error when inserting the IEPDFPLUS activex control, any ideas how to fix this? been searching all morning and couldn't find any sol'n. thanks in advance.
  18. I

    capture autonumber in mysql with .addnew

    so this code works fine, even with a sharepoint list table, yet am having extreme, and no success with mysql, any ideas how to capture the autonumber/primary key when using .addnew? Set rs = CurrentDb.OpenRecordset("qry_employee") rs.AddNew rs.Fields("EMP_LASTNAME").Value =...
  19. I

    i need your thoughts masters :)

    so basically, i have this code and it works fine, it's just that it made me realize something, Set rs = CurrentDb.OpenRecordset("qry_PATIENTDETAILSBILLING1") rs.AddNew rs.Fields("PLASTNAME").Value = Me.txtPLastName rs.Fields("PFIRSTNAME").Value = Me.txtPFirstName...
  20. I

    connecting with a mysql back end in a webserver, is it possible?

    is it a good idea though? cause lately my office has been itching on making an online application while keeping the front end of the system in the office, i mean it is possible since i built my back end using mysql and if the front end where to be translated to web based it would take awhile and...
Back
Top Bottom