Search results for query: *

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

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

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

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

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

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