Search results

  1. R

    Character Limitations and Do.CMD RunSQL "Insert ... "

    Using ADO appears to work, but still truncates Thank you very much for the recommendation. I have tried (both as a Public sub and as a part of the private sub) without any success. I get no errors when inserting and updating, however, it still truncates the text. It is very possible that...
  2. R

    Character Limitations and Do.CMD RunSQL "Insert ... "

    I have run into a problem with a form I am developing for a simple medical records system. I am attempting to insert a text string into a Memo Data column in a table, however, the INSERT statement I using is truncating the length of the comment to 255 characters only (even the Memo data type is...
  3. R

    How to list a Count which is 0

    Uhm, I know this will sound stupid, but I don't know the answer to that question. Right now, the data is stored in two different tables. I have one table which contains all of my employee information and a second which includes just the evaluation data. The evaluation data is linked to the...
  4. R

    How to list a Count which is 0

    I am trying to write a fairly complicated SQL statement in Microsoft Access and I don’t quite know how to do it. The Basic Challenge: I need to query for individuals who have received 4 or fewer employee evaluations within a given time period. This works just fine as long they have as they...
Back
Top Bottom