Thanks to both of you, but neither resolved the rounding issue.
I used the Nz function did not change my final balance.
I verified that the fields from the tables that were being added were 2 decimal places, all were currency.
Changed the fields on the form to be 2 decimal places where some were...
I have a report which is doing DLookUps to 'Total Charges' for printing orders, postage, copier, etc. The totals are currency with 2 decimals.
I then have an IIF statement totaling the fields from the report:
=IIf([txtAccountBalance] Is Null,0,[txtAccountBalance])+IIf([txtCopier] Is...
We have a Access XP.mde that is loaded on different pcs, different locations. Every once in a while the pc will get this message: "The expression you entered refers to an object that is closed or doesn't exist."
Our solutions is to open the XP.mdb (which is on a server), go to modules...
I opened my database with Access 2007 and can't find how the mdw works with this version.
My mdw is set up so only certain people have access to the database. In addition to that, some people see some forms while others can not.
I have a drop down box on a form.
On click has an Event Procedure:
Private Sub Person_No_Click()
Dim EmailAddr As String
Dim Message As String
Dim Title As String
EmailAddr = DLookup("[EmailAddress]", "tlkpPerson", "[Person_No] = " & [Person_No])
Title = "You...
Hi -
Am trying to send an email using a macro (on a form) and the SendObject action.
In the TO box I want to look up the email address from a table.
I am using this statement:
DLookUp("[EmailAddress]","[tlkpPerson]","[Person_No] = " &...
I have a form with a drop down box where I choose who will be assigned to a project.
When a person is chosen, I would like to send them an email indicating that they are now assigned to this project.
Thanks
PKM
We have an Access XP database that is getting corrupt.
The field that appears to case the problem is a memo field. When the user enters data there is no error, but when the user returns to the record the field is not accessible. If I look at the field it contains "#ERROR".
The only way to fix...
I opened CR v10, open a CR v8.5 report. I then went to: verify database and logged into my Oracle 9 database, saved the report.
We put the report on our intranet. We use an URL to pass the userid, password, and criteria to the report.
I now always asks for the userid and password. It did not...
I have an Oracle back end database. When I write my report, I want the 'contact' field from the Oracle view to populate. I follow the steps for setting up a parameter field. When I select the field from the view only part of the values are in the list box.
I do not know how to 'retrieve' all...
I am trying to upgrade a database from 97 to XP.
The main form comes up fine but when I click on a site in one subform, the second subform is suppose to display information regarding that side.
Instead, I am getting:
Microsoft Visual Basic
Compile error:
Invalid outside procedure
The...
The rest of the message is:
"This file is located outside your intranet or on an untrusted site. Microsoft Access will not open the file due to potential security problems. To ope the file, copy it to your macine or an accessible network location."
The databases are located on our...
Access 97 -
I am exporting tables from one database and importing them into another database.
The export is text, comma delimited, with quotes around the text.
When I import a few of the tables, I want to preserve the autonumber in the autonumber field of the orginal table. But when I import...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.