Search results

First of all, I'm completely sorry. "pr2-eugin", I ask your forgiveness, and I hope to watch more my words in the future. I see that MY words, sounded way more as a slap in the face, than YOUR words which I interpreted as a slap, in my eyes. But let me explain: It was very obvious that...

He actually wanted to open in Access (inside a form) an actual Windows Explorer window where he can just double click any type of file and Windows Explorer will open it with the relevant program. (Of course he will try it not before 6 months. Because he saw that you don't understand his needs...

I can't follow up now, hope somebody else will take over..

This code assumes that the form "ZooMobile Booking Form" is already open. Was it already open, at least in the background?

So change back Call DelClientCmd_Click to Call Forms("ZooMobile Booking Form").DelClientCmd_Click The main idea is that you SetFocus to that form beforehand.

Did it help?

Try changing Call Forms("ZooMobile Booking Form").DelClientCmd_Click DoCmd.OpenForm "ZooMobile Booking Form", , , "[Client_ID] = " & Me.ClientIDTxt DoCmd.Close acForm, "Booking Forms Client Search" to something like Forms("ZooMobile Booking Form").SetFocus Call DelClientCmd_Click DoCmd.OpenForm...

I didn't play for a long time in Access (will be back soon though), but I think it should be something like this: DoCmd.SetWarnings False DoCmd.RunCommand acCmdDeleteRecord DoCmd.SetWarnings True Good luck.

Thanks all for the lesson! :)

Inet, can you please educate me.. Why: Abs(5463513391) - (181440 * Int(Abs(5463513391)/181440)) Rather then: 5463513391 - (181440 * Int(5463513391/181440)) ? Why is it better to use here the ABS function?

Thank you Inet for the replacement function. Thank you Galax for detailing the source of the problem. Interesting, Microsoft documented in the MSDN library that the MOD operator can handle "any numeric expression". http://msdn.microsoft.com/en-us/library/gg264708.aspx

These are returning an "Overflow" error. Num1 = 54635133914# MOD 181440 Num1 = CDbl(54635133914) MOD CDbl(181440) Is there a certain limit for the MOD operator?

It looks to me that the Windows system is always using the Gregorian Calendar. And if you changed the Calendar type in Regional Settings; Windows will just CONVERT the Gregorian date to your specified date - wherever windows shows you the date. But in the back of it will always stay the...

How can I detect through VBA which calender the operating system is currently using? e.g. Julian/Gregorian.

Max thanks, So I can use MySQL only on a hosting database server? I can't find a way to host it myself on my windows 7 ultimate dell workstation?

Right, thank you. I didn't think enough (of the 'interpreting to Access' part) before asking.

I'm planning to do it in access, I just do now the testings in Excel.

A quick question. Which of these 2 functions should I use - which one will use less CPU etc? I want to return "1" for every 3,6,8,11,14,17 or 19th of every 19 numbers, and a "0" for the others. IF(MOD(MOD(MOD(MOD(MOD(MOD(MOD(<Number>,19),17),14),11),8),6),3)=0,1,0)...

Thanks Guys. (sip)

Oh! I thought YOU were gone to the pub.. ;) Thank you Paul. I am actually ready to learn any new language if that is better for my situation. I don't think it will be a big hassle for me. My main goal is: AN ONLINE DATABASE. which is accessible by... A DESKTOP 'PROGRAM'. 'not' by web...