Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Pop up a mssg when new records added.
- Thread starter Gazer44
- Start date
Junior1544
Technical User
i'm not sure what it is that you want... you as the admin want to know when any one add's a record to the database?? or you want to tell the user when they add a record...
that would confuse me since don't they know they are adding a record??
more information about what you realy want would help us help you...
--Junior JHauge@jmjpc.net
Life is change. To deny change is to deny life.
that would confuse me since don't they know they are adding a record??
more information about what you realy want would help us help you...
--Junior JHauge@jmjpc.net
Life is change. To deny change is to deny life.
- Thread starter
- #3
The d/base has a 'mssgTable' within it (Not Linked) and many users connect to the d/base via a shortcut.
If one user adds a record then I'd like a mssg to pop up saying 'mssg added' so the other users can open the relevant form (connected to this table) and see the mssg.
cheers
If one user adds a record then I'd like a mssg to pop up saying 'mssg added' so the other users can open the relevant form (connected to this table) and see the mssg.
cheers
Junior1544
Technical User
i see what your getting at... hmm... i would open a form in hidden view, and in the on timer even of this hidden form run code to check to see a new message is there... if you need help with the code, just ask and i'll put some thing together... just one thing, i need to know a little more about the message table to write code for it...
the information i'd need to know is if you have a check box in the table for if the message has been read, or if you have a message box for each user, that way it's individual (though, it would be much harder to program
)...
also, i need to know the name of your starting form...
i think that's all i'd need to know if you want me to put together some code...
hope this helps...
--Junior JHauge@jmjpc.net
Life is change. To deny change is to deny life.
the information i'd need to know is if you have a check box in the table for if the message has been read, or if you have a message box for each user, that way it's individual (though, it would be much harder to program
)... also, i need to know the name of your starting form...
i think that's all i'd need to know if you want me to put together some code...
hope this helps...
--Junior JHauge@jmjpc.net
Life is change. To deny change is to deny life.
- Thread starter
- #5
Cheers, Junior
I don't have a check box for mssgs read or a mssg box for each user.
The form is called 'MssgFm' (it's a continuous form) which users open now & again, but I could do with them being notified to open it when new mssg gets put on.
Thanks again,
Gary
I don't have a check box for mssgs read or a mssg box for each user.
The form is called 'MssgFm' (it's a continuous form) which users open now & again, but I could do with them being notified to open it when new mssg gets put on.
Thanks again,
Gary
Junior1544
Technical User
ook, i have a few things almost built, if you give me a good email address i'd be happy to send them to you this afternoon so you can take a look at it...
--Junior JHauge@jmjpc.net
Life is change. To deny change is to deny life.
--Junior JHauge@jmjpc.net
Life is change. To deny change is to deny life.
- Thread starter
- #7
- Thread starter
- #10
Junior1544
Technical User
I would love to take a look at it too....
Jhauge@jmjpc.net
--Junior JHauge@jmjpc.net
Life is change. To deny change is to deny life.
Jhauge@jmjpc.net
--Junior JHauge@jmjpc.net
Life is change. To deny change is to deny life.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question