Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: mvrijnsoever
  • Order by date
  1. mvrijnsoever

    Importing data into MySQL tables

    Looks like it can not find either your mysql server or your insert.sql file. "bad command or file name" does not sound like a mysql error, but a windows one. Try logging on the your SQL sever by just a plain command: mysql Then check the location of your SQL file. Cheers, marius
  2. mvrijnsoever

    Database Formula

    Hi Jedel Try using a compliant memory value first. Define this variable on the top of your subroutine: Dim stCompliant As Integer Dim stRefuseText As Text stCompliant = 1 'If value is not modified, all tests were succesfull Rather than modifying your checkbox value directly, set the...
  3. mvrijnsoever

    delete problem

    Altough this solution is not ideal, it is a quick fix. Try a "Select INTO TempTable" followed by the "Delete From Where" statement. By first copying your data into a temp table and then performing the delete action, only data from one of your tables is deleted. Probably not...
  4. mvrijnsoever

    protecting access database

    Hi SQLNerd One way to do this, is making a separate workgroup file (MDW). You can do this using the Security wizard that is included in Microsoft Access 2000 (don't know for sure for pervious versions). Make sure that you do not give guest users any permissions otherwise anybody can log in...
  5. mvrijnsoever

    on entery of study number find patients last date of followup

    Hi Charlotte If you want to look up that last date a patient was seen use: DMax("[followup_date]", "TableOutcome", "TableOutcome.PatientID = '" & Me.PatientID & "'") You can use the function DCount to find out how often something was registered for a...
  6. mvrijnsoever

    delete problem

    Hi The follow section from the MySQL manual describes multi table deleting: The first multi-table delete format is supported starting from MySQL 4.0.0. The second multi-table delete format is supported starting from MySQL 4.0.2. The idea is that only matching rows from the tables listed...

Part and Inventory Search

Back
Top