@zmbd
As you can see is not a breeze.
Never mind that, in this case, is necessary to convert date to double.
And still I don't understand why/how Microsoft don't implemented a simple way.
Mihail
Last Activity: Jan 12 '15, 10:41 AM
Joined: Apr 10 '11
Location: Romania
-
Hi, zmbd.
I ask here because, at that time I have had no answer in AWF.
Now the thread in AWF is SOLVED.
I have the solution, thanks to namliam.
The solution is:
...Code:'In the form module Private Sub DataComanda_AfterUpdate() Me.DataComanda.DefaultValue = EnglishDate2(Me.DataComanda) End Sub 'and in a regular module: Public Function EnglishDate2(UzualData)Leave a comment:
-
Default property for a control bounded to a Date/Time field
The original question is located here (AWF)
I'll repeat here if needed.
Have you a solution for this ?
Thank you ! -
This forums should be (in my opinion) a school for every one.
Bytes policy don't allow me to post a link to other forums. OK. I am a guest here and I must respect their rules. No problem. But I like to inform you (all) that I post my question ONLY here. In the Bytes. The reason was that I have not can access the "other" forum, at that time. Then, in that "other forum" I post a link and an ask. And they have helped me with...Leave a comment:
-
Founded the answer (with the help from other forum):
Works also with double quotes:Code:Me.Tip.DefaultValue = "'" & Me.OpenArgs & "'"
Thank you for your time and patience !Code:Me.Tip.DefaultValue = """" & Me.OpenArgs & """"
Cheers !Leave a comment:
-
As you can see I have tried this. No change.
...Code:Private Sub Form_Load() If Not IsNull(Me.OpenArgs) Then Me.Tip.DefaultValue = Me.OpenArgs End If DoCmd.GoToRecord , , acNewRec End Sub Private Sub Form_Open(Cancel As Integer) Call FormMoveResize(Me) ' If Not IsNull(Me.OpenArgs) Then ' Me.Tip.DefaultValue = Me.OpenArgs ' EndLeave a comment:
-
Code:Private Sub Form_Open(Cancel As Integer) Call FormMoveResize(Me) DoCmd.GoToRecord , , acNewRec If Not IsNull(Me.OpenArgs) Then Tip.DefaultValue = Me.OpenArgs End If End Sub
Unfortunately :) the problem disappear when I do this. All is OK if I comment this line.
I've tried this:
...Code:Private Sub Form_Open(Cancel As Integer)
Leave a comment:
-
I open this form from two different places.
From other place I open this form without OpenArgs (it is why I have the IF statement in Form_Load) and all is OK.
So I'm very sure that this code bring me in trouble.
Just, like you, I don't understand why.
Maybe you should know that I have also this code in frmContoare_tip uri.
...Code:Private Sub Form_Open(Cancel As Integer) Call FormMoveResize(Me)Leave a comment:
-
My code doesn't wants to set the control default value
Hello !
I try to open a form from the NotInList event (check box) and to pass the NewData as OpenArgs.
Here is the Load event in the form I wish to open (frmContoare_tip uri)Code:DoCmd.OpenForm "frmContoare_tipuri", , , , , acDialog, NewData
...Code:Private Sub Form_Load() If Not IsNull(Me.OpenArgs) Then Tip.DefaultValue = Me.OpenArgs End If End Sub -
Thank you, dsatino. Really good information to make an idea about this subject. Thank you, again.Leave a comment:
-
Thank you Frinavale.
I don't know that I can find samples for other databases in my own Access. I'll do a search.Leave a comment:
-
Thank you. I'll take a look.Leave a comment:
-
How to start learning Access?
Maybe the title should be HELP ME or GIVE ME A FAVOR but I don't see before titles like this :)
I like to start to learn how to use Access in order to open other databases files (Fox, DBase, Oracle etc), to create queries or even to write in this files.
But I have nothing to start.
So, please, give me, if you have, some simple in other databases.
I don't know even to ask for something. I don't know from where to... -
Congratulation and thank you, zmbd.
.
Thank you for the info. Seems that I'm a lot outdated.
.Last edited by zmbd; Apr 15 '14, 12:08 PM. Reason: [z{redacted two lines that were in reply to my post that nolonger apply (^_^)}]Leave a comment:
-
In short, No.
In long... NO. Maybe, yes, if you have strong friends in Police Department or in National Security. But as far as I know, that implied to destroy the device (the hard disk).
It is why you need to backup the database as frequently as you can.Leave a comment:
-
Thank you, guys !
Seems that are not other solutions.
I have implemented ADezii's solution (in fact, idea) because I understand better [even if he has multiple houses for one bulb :) . Energy economy.].
My skill in SQL is almost null. So I must say thank you to Rabbit, but I'm afraid that I'll not be able to manage the SQL if I'll have some changes in code in the future.
I have select the best answer only...Leave a comment:
-
I understand that.
But the radio button also has an event you can use: OnClick, OnChange, MouseDown, MouseUp etc.
I give you an idea about how DoEvents work.
If you don't wish even to try or you think that is a better way... Good luck !Leave a comment:
-
And this is fairly easy to obtain using DoEvents.
Note that (see my previous post) you must allow events in the most interior cycle to ensure that DoEvents is executed with the maximum frequency.
Put in a form 5 command buttons:
cmdStart
cmdPause
cmdContinue
cmdRestart
cmdStop
and in the Form module copy this code:
...Code:Option Compare Database
Leave a comment:
-
Yep.
Seems that I have had a good feeling.
I'm pretty sure that the DoEvents statement is the answer to your issue
Say you have a long cycle:
...Code:For i = 1 to 1000000000000000000000000000000000 For j = 1 to 1000000000000000000000000000000000 For k = 1 to 1000000000000000000000000000000000 DoEvents 'Other code Next k Next j Next iLeave a comment:
-
What you are trying to do ?
Why you need to stop the BackGroundorker for miliseconds.
Do you know the DoEvents statement ?
If you explain WHY you wish to pause that BackGroundorker , maybe we can find a solution.Leave a comment:
No activity results to display
Leave a comment: