25. januar 2012 - 02:38Der er
32 kommentarer og 1 løsning
Inputmaske til dato og klokkeslet
Hej alle,
Jeg har fået hjælp til det her før men kan simpelthen ikke få det til at virke og er startet forfra.
Jeg har en tekstboks hvori der skal indtastes en dato og et klokkeslet. Det må meget gerne se ens ud hver gang og se således ud:
Dato: 01-01-2012 Kl.: 01:01
I tabellen er følgende lavet:
- Feltnavn: Barring udløber - Datatype: Dato og klokkeslet
Feltegenskaber:
- Format: Standarddatoformat - Obligatorisk: Nej - Indekseret: Nej - IME-Tilstand: Intet kontrolelement - IME-sætningstilstand: Ingen - Tekstjustering: Standard - Vis datovælger: For datoer
Da jeg ikke er den eneste der indtaster data i feltet er det nødvendigt med inputmasken. Alternativer er velkomne, og undskyld udtrykket så længe de er "idiot sikret" !
Jeg er ikke en haj til det her og skal have det skåret ud i pap. Så hvis nogen har tålmodigheden ser jeg frem til hjælpen.
Every day the database is opened and kept open until closing time. Not every form. We have a form called "Kontaktpersoner" for our clients. It is opened by me when different information about our clients are given to me.
I find their "profile" in the form. The text box which you gave me the inpumask for, is a box that are supposed to show a deadline - a date and time.
If there is no deadline = No numbers/date and time in the box - the excell ark I made which my colleagues use will also be blank (in a specific cell).
This will speed up the work process in my department. It would be greatly appreciated if it was somehow possible to make the date and time disappear automaticly in the form (database) that I use so that I dont have to do it manually. We have a lot of clients:-)
I assume that the date/time field has to be visible at least until the data and time is reached. So when exactly would it be appropriate to clear the field?
It would be quite easy to update records (Date/time field) at intervals by having a timer event in the form but if the date/Time field is required for some purpose then that wouldnt be a good idea.
So when in the work process could it be cleared?
I'm off to see some TV will look again sometime tomorrow
Why dont you take another approach? Use conditional formatting to show the date/time field in different colours. For example you could show the field as green if the current date time is more than 24 hours less than the date/time in the field. Then show it as red when the current date time is less than 24 hours less than the date/time in the field.
Then you could also have some code which deletes all date/times < currenty date/time. This could be done in timer event on the form.
I dont think its a good idea to delete it as soon as it is reached, what happens if some one was supposed to take action but becuae its deleted you can see it any more?
Thanks for your patience ! I am close to loosing my mind :-) I will look at it when I am back tuesday I have to leave now. Thanks again.
Synes godt om
Ny brugerNybegynder
Din løsning...
Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.