Search results for query: *

Hi, How do I use the Round function explicitely? vast

I have one form in my project to calculate the Change from what a customer paid. There are fields of Subtotal, Tax, Total, Paid and Change. All the fields are set in Currency format. My users complain there is 1 cent difference in the Change field from the computer calculation occasionally. Here...

Hi, PHV: Both computer A and computer B have same version of Access (Office 2002). Vast02

I created an Access mdb (db1.mdb) file (under Access 2000 format), copied it to another computer (Computer B). THe db1.mdb runs Ok in that computer. Howerver, when I copy the db1.mdb from computer B back to my computer (computer A), use Access to open it. I am not able to open the db1.mdb in...

Thank you, Eddy. Can you explain the line of code for me? Set dbImp = DBEngine.Workspaces(0).OpenDatabase strDBName, False, True, "'") Vast02

For some reason, my program can not do this by linking it to db2.mdb. I need to retrieve the rs directly from the db2. How do I change the CurrentDB() code? Thanks.

I like to refer to a table ("Customers") in another database (db2.mdb) in my C drive using DAO code, how do I do it? I know if I want to refer to the "Customers" table in current database (db1.mdb), I will use the following code: Dim rs as Recordset Dim db as Database set db = Currentdb()...