Search results

  1. J

    Identifying whether Shift is pressed during opening a Runtime

    I am using the /runtime shortcut. Am I correct in assuming that Shift will not work in this case?
  2. J

    Identifying whether Shift is pressed during opening a Runtime

    Thanks Gasman. Can you please clarify: 1) Do I still define the Startup form? 2) What do I take out od DB properties? 3) How do I test if Shift was used?
  3. J

    Identifying whether Shift is pressed during opening a Runtime

    Hi Gasman, I have a .accde which has one form, which is specified as the startup form. I tried to use AutoExec to open another dummy form and theoretically if Shift is pressed this dummy form would not be opened and in this way the user would know if Shift was pressed. The dummy form is opened...
  4. J

    Identifying whether Shift is pressed during opening a Runtime

    Good thoughts. Many thanks.
  5. J

    Identifying whether Shift is pressed during opening a Runtime

    Hi Pam, as I mentioned the functionality which I would like to add in the first .accde is to check whether the BE DB is used by any of the users and if none of the users are using the BE DB I would like to enable the user to C&R the BE DB. If any of the users are using the BE Db then no C&R...
  6. J

    Identifying whether Shift is pressed during opening a Runtime

    Many thanks for all your feedback. Let me explain better. I have two .accde files. The first .accde checks things such as bitness, whether there is a connection to the Internet, whether a BE exists. If everything is OK the first .accde calls the second .accde, which is the main program. It is...
  7. J

    Identifying whether Shift is pressed during opening a Runtime

    I tried it and it works fine. I added a simple msgbox statement. The real reason for the Shift functionality is to be able to select when to Compact and Repair.
  8. J

    Identifying whether Shift is pressed during opening a Runtime

    Maybe I can do an exception and use the AutoExec, since the specific .accde is not the main program, but a ".accde", which calls the main .accde. If I set a global variable to a value in AutoExec then that means that the Shift was NOT pressed, when I called the .accde?
  9. J

    Identifying whether Shift is pressed during opening a Runtime

    With the ByPass the following is set to True or False db.Properties!AllowBypassKey Can't see how this can be used.
  10. J

    Identifying whether Shift is pressed during opening a Runtime

    Thanks. Yes, I use the ByPass. I do not use macros at all. With the ByPass I merely set it to True or False.
  11. J

    Identifying whether Shift is pressed during opening a Runtime

    Thanks for your reply. I do not understand ChatGPT's position.
  12. J

    Identifying whether Shift is pressed during opening a Runtime

    I need to run a specific code on some occasions. I thought if I could identify whether the Shift key is pressed when the .accde is run, that would solve the problem. Can we identify whether Shift is pressed during opening a Runtime
  13. J

    Calculated field in query

    Yes it is a small island in the mediterranean, a stark contrast to Silicon Valley California where I used to live.
  14. J

    Calculated field in query

    Yes, I am very surprised as well. The culprit is the List Separator, which was set to ";". When I set it to ".", the original expression worked.
  15. J

    Calculated field in query

    It appears that the following works. Expr1: DateAdd("m";[lngMHMonth];[tblMedicalHistoryListNew].[dtmCreation]) Where in the documentation does it say to use ";" instead of "," ?
  16. J

    Calculated field in query

    It shows the dtmCreation field on mine
  17. J

    Calculated field in query

    When I run the query without the Calculated field I get what appears in the attachment.
  18. J

    Calculated field in query

    Yes the fields have values. What is CamelCase? Not clear what you mean with [&]
  19. J

    Calculated field in query

    I get the error message which appears in the attachment when I try to create a Calculated field using the DateAdd function. Any ideas?
  20. J

    Unable to create .accde

    Tested it again this morning. I tried it with Bitdefender on. It gave the problem. I disabled Bitdefender for 5 minutes and I was able to create the .accde immediately.
Back
Top Bottom