Search results

Hi Smart, good suggestion! However, it is still not working. When i create another column that incorporates the following code: YearDate: Format([SELECT Year FROM QueryTotal];"yyyy") ...and when I run the query Access wants me to enter a paramater-value for the year. It seems that for some...

Hi! I have a table with 2 columns, 'year' and 'month'. I want to create a query which creates a date from these two numbers. In the design view of the query, my current code in the field-cell is: Datum: DateSerial([SELECT Year FROM QueryTotal];[SELECT Month FROM QueryTotal];1) QueryTotal is...

Ah! Even better! :)

use in the VBA-code no spaces but instead '_' So it should be: Me!Funding_Subform_CJ.Form!Detail.BackColor = 8421504

Hi Ashfaque, I don't think I could really be helpfull to you, the button-stuff sounds great, if I where you I should look some more on and around the internet. (via eMule you could download several access-VBA books in pdf-format, works for me). Cheers, Willem!

aah.. after a relaxing weekend i got an apifany, silly me, i knew the answer to my own problem but that i did not know friday... for the ones who are interested in the answer of my previous problem, you should implement an 'On Error' statement also. So the final code would be: Private Sub...

Hi! I want to make a button on my form which opens Outlook and places certain e-mail adresses at the right places. I have a small problem though. My current code is as follows: Private Sub EmailButton_Click() Dim strToWhom As String Dim strToCCWhom As String Dim strMsgBody As String Dim...

Hold on, I think i already found something using the search of this site: http://www.access-programmers.co.uk/forums/showthread.php?t=38389 and more... cheers anyhow, Willem

Hi guys! Got a small problem. I got a big Access-form (big of size) but a small computerscreen before me. I am very much used to scroll up and down with my mousewheel. However, when I open my file and the opening-form pops up I cannot scroll up-and-down the form using my mousewheel. Is there...

I found another way out! put a little (empty) button at the top, make it transparant, and change the tab-order so that the ghost-button is at #1

Yo man, thanks (although i do not exactly know how to realise that). However, it doesn't seem right that the software does not follow my commands.. They should prevent that ;)! So If anyone can beat my computer, I would be glad to hear. Willem

Hi everyone! Got a small but mind-breaking question. I am rather new in Access so perhaps I overlook a small thing or whatsoever. My problem: I have a form built up off tabs. Under a tab there are serval sub-forms. Now, the problem is that when I open the file the tabs are hidden under the...