Search results for query: *

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")".

...' Open the table of Switchboard Items, and find ' the first item for this Switchboard Page. Set dbs = CurrentDb() strSQL = "SELECT * FROM [Switchboard Items]" 'strSQL = strSQL & " WHERE [ItemNumber] > 0 AND [SwitchboardID]=" & Me![SwitchboardID]...

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.

...inches(found in the properties list of combo field). Then use an Exit Event on the Change field to do the calculation. That would be "Change * Item.column(1)". The Item.column(1) is the percent form Table 2. Item.column(0) is the Item itself. Hope you can understand my jargen...

I'll give it a try. I would make a form with a sub-form. In the main form I would have two combo boxes. The first combo box would query the main table and allow you to pick the main product item you want. The second combo box would query the sub-product table and list all the sub-products...

In your query of table2 show both fields that you want on the form. Then in the attributes of the combo box make sure the you have 2 columns. You can have the second column have a length of 0", this will hide the second column when the combo box has focus. Create an event procedure for...

This might not be what you want, but you can make security groups and sign indivduals to these groups. Then assign the groups the access you want them to have to the tables (ex: read only).

If I was doing the query, all I would do is make a Grouping query of the the table. To do this I would create a query using the Process Type field and one other field. From the VIEW menu opition I would select the TOTALS opition. On the query grid I would leave the Process Type as GROUP BY...

I don't work on HIPAA, but other members of my team do. They work with HIPAA on the mainframe, where it ommunicates with other Health and Provider programs. You were asking for more information on security and other information in general on HIPAA. I asked the lead analyst where they go for...