Search results

Does anyone know how to remove or disable the "right-click" ability in Access?

Try this, =Format(YourDate,"mmmm") HTH

Pat - this is the formula: [AmtFinanced]*((1+(([IR]/100)/12))-1)/(1-(1+(([IR]/100)/12)^-([term]))) It seems to work except when trying the ^ or the Exp commands. All I want is to make the [term] a negative exponent. I can't seem to get it straight. Any suggestions? The soulution should...

Thanks Pat, that worked!!!!!

=MonthName(Month([DateField])) this asked me to input the MonthName when the query ran? Is it supposed to? I want the report to recognize what the date is and display the correct month.

Thanks Lyn

Thanks Pat, I'll try it tomorrow.

I'm a average user... In a report an inputed date is grouped on the month and associated records appropriately fall in their place, however I don't want the 03/14/02 displayed. I would prefer the month format, i.e... if date is 03/14/02 display would be March if date is 02/??/02 display would...

I don't know how to programmaticaly code exponents. The formula is this: P = A * (F-1) / (1-F_n) What I mean by _n is "F to the negative n" such as a value with a negative exponent. n is actually a value the user keys in. The rest of the formula is simplistic, but I don't know how to...

Fixed it, thanks!!!!!!!! When I looked in there, I remembered I did install an animated gif reference yesterday. Maybe that kicked out the other one or something. I did have to uncheck the gif animation to get it to work. Thanks so much for the help.

Tried it, and didn't work. Any other suggestions?

Yesterday in various locations I used the =date() and UCase functions. Yesterday those functions worked,,,,all day,,, without a problem. After compacting the database, zipping it, putting it onto another pc, unzipping it and opening it. Now I get error messages saying "Undefined function...

Thanks, I'll try it.

Anyone know how to check and see what form is current in VB? Such as... if object.value = true and "someform" is current then bla bla bla

Thanks, I also read that removing the "Auto-Correct Text" option speeds up loading. I didn't think too much of it, but tried it, and what do ya know it did speed up the loading. But will add the close button that just hides the forms. Thanks for the suggestion.

Thanks fellows, got it to work with your help and looking at it a little closer. I was using the page index number instead of the objects name. Sorry about that. It works now this is what worked. Private Sub MakeAppt_Click() If MakeAppt.Value = True Then Form_Customer.Page28.SetFocus...

naygl, and Rich, Thanks for your help, tried both ways but neither would setfocus/go to the page. when false, it did setfocus to other object, but the main objective was to open the other page. Using page.1.setfocus gave me an unexpected compile error. What am I doing wrong?

I have 3 forms that take forever and a day to load. Is there a way to load the forms but keep them hidden while the splash screen is on? If so how do you do that?

Need a little help here, if someone has the time. I have a form with a tabctl on it with 5 pages. On the first page (page index 0) is a checkbox. when the user clicks the checkbox and value is true I want the focus to be set to a textbox on a different page (page index 1). I tried: chkbox...