Search results

  1. A

    code does not fall through IF statment for Yes/No fields

    This is part of a multi_user database where records are searched using recordsets. The database is on the front end. It works for other similar instances for the same IF statments but does not work for this one. Well I am still hammering away at it. Surely, there is something to the logic of...
  2. A

    code does not fall through IF statment for Yes/No fields

    This also does not work: If rec("Completed") = -1 Or rec("Debit Balance Cleared") = -1 Then... The strange part is that if I use If rec("Completed") = Yes Or rec("Debit Balance Cleared") = Yes Then... it always falls through the loop without checking the conditions.
  3. A

    code does not fall through IF statment for Yes/No fields

    Could anyone tell me waht is wrong with this code? It is not going through the IF statement even when the IF conditions are met. For a brief explanation, the procedure is invoked when a button on a form "Comman26" is clicked. After the button is clicked, the record set is opened and...
  4. A

    sendkey through VBA to field in a form

    Thanks for your input Emma. From my experience (and again I may not be absolutely accurate here), a record gets locked only by a manual input (like by typing something on the keyboard). The only commnad which represents something exactly as that is the "sendkey" command. My program actually...
  5. A

    sendkey through VBA to field in a form

    Hello all! I have designed this multi-user application in which two users are not supposed to ever view the same client record. It works pretty efficiently except in the mornings when all users log on almost at the same time and this challenges the logic with the result that two users...
  6. A

    Strange "Record Delete: message

    This has sensitive financial info in it. Will repairing affect any records?
  7. A

    Strange "Record Delete: message

    I have this table which was being used by multiple users through the FE/BE arrangemnt. I dont know what has happened to it but whenever I try to retrieve a report based on the table it gives me a message saying Record Deleted. It does not even allow me to copy the table to...
  8. A

    Urgent help required for automatic deletion problem in multi user project

    Hello all! I have implemented this multi user ACCESS project where users access different records on the click of a button on a form. To prevent one users going on to the same client record there is a field called "Dummy1" in the backend table which keeps on getting updated to 1 as soon as any...
  9. A

    preventing scrolling on forms for split databases

    I would like to know if there is any way of preventing people from scrolling on the forms. I had diabled all navigation buttons on the forms but when users use the rollers on their mouses it scrolls through the records. It created an absolute mess of the project since it was financially...
  10. A

    Require code for Random Number generator

    I would like to know how you could generate a random number say between 1 to 1000. I have this multi user data base which has been split and it is financially dangerous that two user can view the same client records. I have other checks in place through VBA but when a user activates the...
  11. A

    Code required for searching unlocked records in multi user situations.

    Well, nobody replied to this so I will tell you of my own experience with it. The purpose was to have a multi user ACCESS database which would have a table with information about clients. When multiple users were logged on , it was important that if one representative was viewing a client...
  12. A

    Copying data of certain fields, to the same fields of another table

    Thanks for the help.:)
  13. A

    Copying data of certain fields, to the same fields of another table

    I have a basic question for copying particular fields in a table to another table. Say I have a table called "Table1" with fields aaa, bbb, ccc, ddd, eee, fff Now if I have another table, say "Table2", which has fields aaa, bbb, ccc and I want to copy all data from Table2 to Table 1, how...
  14. A

    FindNext does not go to the correct bookmark

    That worked perfectly. Thanks a million!!:D
  15. A

    FindNext does not go to the correct bookmark

    It is doing the exactly same thing when I run the code on the "On Load" event.
  16. A

    FindNext does not go to the correct bookmark

    I am trying to use the InputBox method to retreive a particular record. The code activates on the event when the form opens. The problem is that the form does not display the correct record. Can any one figure out the problem with the code? Thanks. Private Sub Form_Open(Cancel As Integer)...
  17. A

    Using Windows 2000 login User ID for users name

    Thanks! That helped tremendously!
  18. A

    Using Windows 2000 login User ID for users name

    I am working on a multiuser Access project which will be used by about 30 to 40 people in the centre. I am trying to avoid user permissions because users can change every day on an ad hoc basis, which will complicate the purpose for which this project is being designed. However the managament...
  19. A

    Loop does not stop at recordset condition

    Would like to apologize for all who tried to hel! Actually IsNull(rec("ccc")) does work. I was experimenting on a new db file and did not know that the table was empty. thanks again for all your help guys and/or gals!:o
  20. A

    Loop does not stop at recordset condition

    Hi! I am not trying to find the end points. I am just trying to movenext till I get to the record where field "ccc" is null. The problem is that the loop Do until isEmpty(rec("ccc")) does not stop at the recordset where the field "ccc" is null or empty.
Back
Top Bottom