Search results

Thank you for your help and suggestions. The data is coming to me in a single table so I have no control over that. Since the table is already populated with data when I get it, I need to manipulate it afterwards. Currently, I am running some ugly programming that throws the data into Excel...

I have a table with the following fields: Date Commodity Price Buyer Seller In the first record, the data looks like this: Date: 8/20/2003 Commodity: Banana Price: 1.1500 Buyer: Fred Seller In the second record, the data looks like this: Date: 8/20/2003 Commodity: Banana Price: 1.1500...

I think you may misunderstand what I am trying to do. I just need to know the verbiage I would use to reference a form in a different Access database from the one I am currently in. For example, to reference a form called EricsForm that is within the same database I would use something like...

Yes, it is always the same database. You lost me with the (Tools, References). I don’t see References under Tools. I’m using Access 2002 When you have a moment, can I trouble you to elaborate? Thanks.

Thanks. I currently am able to open database Two from database One using the code below: Dim accPath As String Dim mdbPath As String accPath = "C:\Program Files\Microsoft Office\Office10\Msaccess.exe" mdbPath = "G:\Files\Databases\TestDatabase\database_Two.mdb" Call Shell(accPath & " " &...

I am trying to open a form (and a specific record) in one database from another. Example: In database One, I want to click on a button on a form and open a specific form in database Two and filter for a record that corresponds to a field in the form in database One. That is to say, if I...