Go Back   Access World Forums > Rx_

 
Conversation Between Rx_ and Margarita
Showing Visitor Messages 1 to 5 of 5
  1. Margarita
    11-30-2012 11:28 AM
    Margarita
    That's nothing comapared to the St. Patrick's day parade!
  2. Rx_
    11-26-2012 08:10 AM
    Rx_
    Just got back from an extended trip to NYC. Macy Day Parade was exciting.
    Keep up the asking questions. I have sure asked my share.
    Glad you found a solution. There is always something new to learn.
  3. Margarita
    11-15-2012 09:14 AM
    Margarita
    Hi Rx, thanks for reading through that long, vague question. What I actually wanted was a check on whether the user has updated the unbound controls and is now ready to save the next piece of the invoice to the table. I looked at ways of doing this using Wait, but it was all too complicated. I think I found a simple way to do it with a modeless messagebox that waits to iterate through the loop until the user updates the form and clicks ok on the messagebox. I am still ironing it out, but I think this is the best solution to my problem.
    Thanks!
  4. Rx_
    11-15-2012 08:37 AM
    Rx_
    Your last question:
    I think the crux of your question is - If running some process - how to determine if somone has visited (and maybe more importantly visited and changed data) since the last process was run.

    If that is the case: (if not, maybe a little more details)

    A table design can include a timestamp field. I typically include two. One for the createion data/time and one for the Last updated date/time.
    The default for the created is NOW() (or now)
    The table for the last updated - set the value in a hidden field to Now

    If the question can be a little more focused - I bet you will get a lot of great advice.
    Best Regards
  5. Rx_
    09-10-2012 03:40 PM
    Rx_
    You are doing great! good questions. Sorry I have to catch the train and can't look into it more.



All times are GMT -8. The time now is 05:52 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World