Search results

  1. M

    Making private sub globally visible

    I've created a private procedure on one button on one form in my application. Can I make that procedure globally visible (usable on other buttons in other forms in the application - OO approach), and how? Where do I put it and how should I declare it and call (instantiate) it? Thank You
  2. M

    Creating real-time timer with save and continue

    Hi. I want to create a mechanism that starts a timer the first time You run the application and then each time You reopen the program it continues on the previous time and when it comes to the, lets say, 1 hour of work it blocks itself and stop working. Now, I know how to create a blocking part...
  3. M

    Reading System Date

    So, if that's the case I have another question to ask: If I don't have network and server to read the date from, if I cannot read the date from the internet, if there is no point to read the BIOS date because the same can be changed from windows CP, how do I secure my access application that has...
  4. M

    Reading System Date

    I have successfully implemented the Date reading mechanism put the problem with it is that it cannot work in non network environment (without a server). When there is no server I can read the system date but the same can easily be changed and thus render the date mechanism obsolete. Can I read...
  5. M

    Crystal Reports Error - common error I suppose

    I've contacted web hosting support and apparently Crystal Reports are not installed on their servers. I have a second question: Can I, and how, install Crystal Reports to the web hosting server from my computer, or I need to ask them to do it? Thank You
  6. M

    Crystal Reports Error - common error I suppose

    From reading of several online articles I've figured out this is the common error someone encounters when trying to run Crystal reports app online for the first time. Alas none of that articles made my app work although I've done everything they've asked except installing Crystal Reports run...
  7. M

    Question Optimizing form on load

    I don't intend to use timer forever in my app, I just want to find the way to measure the time in seconds when my form opens because I plan to speed up the opening so I need a valid instrument to see how each change I plan to make reflects on the speed of opening. Thnx for the advice anyway...
  8. M

    Bob Larson has left

    Good luck with Your future projects, I've learned a lot from Your answers to my problems. Thank You in my, and in the name of all forum member who found Your word as a glimpse of hope in this dark and confusing world. Thank You Bob.
  9. M

    Question Optimizing form on load

    I developed a database with a form that filters records from table when it loads. Since then the table has filled with over 5000 records and the form needs more time to open. I use the VBA code to filter records and in the filter I specified that form returns only the records from the current...
  10. M

    Question Connecting it all together (multiple modules)

    [SOLVED] Connecting it all together (multiple modules) Thank You vbInet that article did the trick ;)
  11. M

    'The search key was not found ... '

    Yes I did all that. And You're right it is corruption. When I put three more lines of code on particular spot the corruption occurs, so I drop that plan out and leave everything as is. Why is access so vulnerable, can similar things happen in other programming languages and environments?
  12. M

    'The search key was not found ... '

    I have a piece of code which worked excellent then days ago, now when I try it I'm getting an error message "The search key was not found in any record". I didn't change anything in the code, I just redesigned couple of forms visually? What could cause this error to happen? Thank You
  13. M

    Question Connecting it all together (multiple modules)

    The error message that is triggered by opening accdr with the hyperlink is on picture msg1 in attachment. In this example only the accdb and accde versions open as they should but I want to distribute the accdr version not the other two of course. I have Office 2007 so my app path is little...
  14. M

    Question Connecting it all together (multiple modules)

    I tried this command and it works perfect for accdb version, it opens it fullscreen even, but for the accdr, I get a message with two buttons, and when I click OK, the window opens maximized. Can I open the accdr full screen without the message popping out? Thank You
  15. M

    Question Connecting it all together (multiple modules)

    I've read somewhere that I can use the Shell() command from VBA. I tried and I got err no. 5 I think "invalid procedure ..." or something like that, why? Can I do it with shell, open the accdr in full screen, and how? Thank You
  16. M

    Question Connecting it all together (multiple modules)

    Why do I get an error when I try to open accde version renamed to accdr? What properties, that I can manipulate with, has an opened application? I would like to open application full screen but for now it opens maximized, how can I change this? Thank You
  17. M

    Cannot update UNION query, object read-only

    How, I tried and I couldn't?
  18. M

    Cannot update UNION query, object read-only

    [SOLVED]Cannot update UNION query, object read-only Thnx. Just wanted to check.
  19. M

    Cannot update UNION query, object read-only

    I have a union query as record source of the DAO record set that I try to update but I'm getting this error message. Can I solve this somehow? Thank You
  20. M

    Determining which control triggered forms before update enevt

    Determining which control triggered forms before update event I have this code in the forms before update event: If Not (Me.NewRecord) Then If MsgBox("Do You wanna save changes on this record?", vbQuestion + vbYesNo + vbDefaultButton1, "Saving changes?") = vbNo Then Me.Undo...
Back
Top Bottom