Recent content by TCVance

Is your field linked to a table. If so try makeing the field in the table a "Double" or "Single" instead of a "Long Interger". Hope this helps.

We have a Access 2000 database that just comes up in Read-Only mode. We have full rights to the directory and there is no Access Security restrictions. The database was converted from Access 97 to Access 2000 recently. Thats about all that I know. Any ideas? We are lost as to what could be...

Now I can't subtrack. I meant to say $500 - $1000.

$1000 - $500 does = -$500. But if you want the absolute value of the difference you might use: answer = Abs({equation]).

About the only I can think of is any of your fields NULL?

If joehrne's suggestion doesn't work you might try: Docmd.openreport "HOME Buildings",acprint,,"[HOME Buildings]![BuildingNumber] = [Forms]![MAIN FORM]![HOME Building subform]![BuildingNumber]" Good Luck

I think I got it. Thanks for your help.

That works great, but when I do that I also get a grayed out menu box. Any ideas how to turn the menu box off?

Is there a way to display a help message on a button without it comming in focus or active?

If I understand what you want to do with your report. That is to list both the Active and InActive employees. The way you have the report set up now it will only list the Active or the InActive based on the input you entered in the End-Date. What you need to do is find a way for your report...

The way I would do it (and it maybe off the wall) is to set up main form with the loan number in it with the 7 tabs, then make a subform in each of the tabs. The link between the main form and the subforms would be the loan number. Just another way of looking at it.

You might try "Format(time(),"hhnn")".

I didn't know if you was still needing this code or not. Here it is anyway. You need to make a label in the switchboard where you want the menu title to be and name it "OptionLabel0". Then change the "FillOptions" sub routine in switchboard code. Following is part of the...

You can do it with some minor changes to the code behind the Switchboard form. Let me know if you're interested in the code changes.

The way that I would do this form would to bring down both the Item # and the percent in the combo box. The percent would be the second item and have a lenght of 0 inches(found in the properties list of combo field). Then use an Exit Event on the Change field to do the calculation. That would...