The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
That's not the case. I've been googling it ever since I posted this query. How can I make the text box white and increase the line space in these text box? Whenever I google, I get told about coding. I used to search for it a lot in the design tools of Ribbon but even there I could not find it. I did not know that the problem which I was considering as big as an elephant, would actually turn out to be as small as an ant. Please don't feel bad.
Thank you.
I want to tell you all that I am from India and tomorrow we have the festival of Diwali which is the biggest festival of our country. I want to wish Happy Diwali to all you members of this forum. Best wishes to all of you on Diwali.
Jai Shri Ram.
thank you......
https://www.google.com/search?q=ms+a...hrome&ie=UTF-8That's not the case. I've been googling it ever since I posted this query. How can I make the text box white and increase the line space in these text box? Whenever I google, I get told about coding. I used to search for it a lot in the design tools of Ribbon but even there I could not find it. I did not know that the problem which I was considering as big as an elephant, would actually turn out to be as small as an ant. Please don't feel bad.
Thank you.
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
I'm not talking about general stuff like thisI'm talking about when anyone is told what to do, or given a term or maybe a property name that they don't know about or understand, you and a whole lot of other people write back and ask "how do you do that?" or "I don't know what that is." or whatever. Then research the answer given for Heaven's sake. Key word in the suggestion - "property". You look in the property sheet for properties, not the ribbon and you should know that by now.How can I make the text box white and increase the line space in these text box?
Enjoy your festival!
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
If here you want to set offer date instead of offer ID, then what change has to be made in this code i have made this change but it is not working.
Code:DoCmd.OpenReport "Grey_Offer", acPreview, , "Offerdate BETWEEN " & Me.cbxStart & " AND " & Me.cbxEnd
Need # delimiters for date/time parameters.
"Offerdate BETWEEN #" & Me.cbxStart & "# AND #" & Me.cbxEnd & "#"
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
You need to put date delimiters around your combo box values, and possibly format them to the correct layout, depending on your regional settings.
Code:Dim strWhere as string strWhere = "Offerdate BETWEEN #" & Me.cbxStart & "# AND #" & Me.cbxEnd & "#" Debug.print strWhere DoCmd.OpenReport "Grey_Offer", acPreview, , strWhere
DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
Please use the star below the post to say thanks if we have helped !
↓↓ It's down here ↓↓
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
Thanks it's working...........