Recent content by Willem!

...even better...

No, use in the MAIN form: Me.frmmainsub.Requery HTH

...but I'll change the format of the pictures anyway, the smaller the better. They're now bmp's, png's are much smaller, and have the same quality (wel, at least with the pictures I use).

...well, they're really nice :-) ;-)

Incroyable!! That was it! I've changed the pictures from 'Unbound Object Frame' to 'Image' and that did the trick! Now they don't disappeare anymore. Thanx David for your reply, you've made me thinking, and I solved it by myself. THANX :) :D :)

Hi! ...what controls do you mean? The picture itself? BTW(1): does is matter whether I embedded them as 'Image' or 'Unbound Object Frame'? (the latter is currently the situation). BTW(2): FYI, I use the pictures for customized control buttons, inspirated by this

Hi, I have a strange problem. I have some (small) embedded pictures on my form. For some reason after a while (during which I continue to develop my database, swichting to design view and back), suddenly the pictures are gone! Well, not entirely gone, but instead of a picture they are totally...

Thanx Ron for your suggestion and your help :)

Wow! Incredible! Many, MANY thanx! That did the trick! :D :D I never had thought of that, superb! I am really ecstatic, thanx! :)

How do you suggest I should change it? I need to substract 1 month, and the syntaxis is allright (when I try 'mm' or 'month' as suggested on some SQL-websites, I get an error).

I want to create a record which holds a RecordDate and a LaggedEURUSD; the EURUSD from one month earlier. I want to do this to calculate the monthly index change in % (the return) (returnEURUSD = ([LaggedEURUSD]/[EURUSD])-1 ) When I have al the data one 1 row, I can simply do that.

Hi, I have the following problem. I want a query to look up a certain (1 month) lagged valuta-return EURUSD. My SQL-code is as follows: SELECT qryValuta.RecordDate AS RecordDt, DLookUp("[EURUSD]","[qryValuta]","[RecordDate]=#" & DateAdd('m',-1,[RecordDate]) & '#') AS LaggedEURUSD FROM...

Thanx Ron for your reply. I cannot make other queries though, I really need it to work in my VBA-code... ...and I just find out how to do it. The code should be this: Dim intProduct As Integer Dim strType As String Dim dtMin as Date intProduct = Forms!Form_MAIN!ProductNumber strType =...

Hi, I have the following problem. I want to use the DMin-function and I want to fill the domain- and criteria-section with a variable which is declared in the module. So, I want to do something like this: I have three queries qryProductFood, qryProductTools, qryProductElectronics. All...

Me.MaximizingButton.Enabled = true