Recent content by BillP

  1. B

    Addnew

    This is probably clutching at straws, but if the process is slow over the phone lines, it might be because of the overhead associated with access. Maybe it might be quicker converting to a delimted text file for the transmission and then importing at the other end. It sounds like an awful lot...
  2. B

    Automation - Turn off Excel Links

    A friend of mine found the answer, and it works. I am posting this for the benefit of any other users who might be interested. -------------------------------------------- I found the solution (at least it works for me so far!). I checked in the Excel help files and under the reference for the...
  3. B

    Automation - Turn off Excel Links

    I have an access application that iterates through a bunch of excel files to read data that will be written to some tables. Each of these Excel files is linked to another file. When each workbook is opened, it prompts me with a "Do you want to refresh the links" dialog. I can turn the dialog...
  4. B

    Addnew

    This sounds like it is causing you some grief. I'm not sure if this will help because I don't know enough about your application. Can you buffer the data coming in? Would that help? You could create a user defined type, and create an array of this new type. The array can grow dynamically using...
  5. B

    Class Library

    Thanks for the advice. I did try using a normal module in the library, and it is being referenced by the other databases, so I can use the module to create function wrappers for my objects, but it would be much preferable to create the objects directly. It sounds like the VBA dll may be the...
  6. B

    Class Library

    I am taking a somewhat object oriented approach to an application I am building, and I have been very pleased with the results. However, I am having a problem setting up a class library. The application uses 3 databases and I developed the classes in one of them, but each of the databases will...
  7. B

    Updating Fields in a Recordset

    I'm sorry to hear you're still having problems with it. I would have done it a bit differently. Declare SQL as a string. dim SQL as string I would then use set to create the dataset. SQL = "SELECT * from [Outservice Balances] WHERE ([part#]=" & partnumber & ") AND ([contractor#]=" & contracto r...
  8. B

    Deleting References

    Sorry for any confusion, but there's a typo in my description. It should read that it reverts back to "Rates_Data_Test.mdb".
  9. B

    Deleting References

    I am in the process of splitting up a database. I have one database, Rates_Data_Test.mdb, listed as a reference in my Rates_Interface.mdb database. I now want to change the reference from Rates_Data_Test.mdb to Rates_Data.mdb, and it keeps reverting back to the original Rates_Data.mdb. It seems...
  10. B

    Updating Fields in a Recordset

    I usually use an SQL string in cases like this. For example: SQL = "SELECT * FROM TableName WHERE (FieldName1 = " & intvar1 & ") and (FieldName2 = " & intvar2 & ");" I would then use the SQL as follows set MyRecs = MyDb.OpenRecordset(SQL). I hope this is what you're looking for.
  11. B

    Calling a DMax functions in different databases

    Thanks for the info. I actually did as you suggested the day I posted the question (I had a deadline) and it worked well. It's too bad the DMax can't work across databases because it means I've got more work to do. I'm in the process of segmenting an existing database, and there are a few DMax...
  12. B

    temporary workfiles

    I have done something similar for a financial application I had to build. You have to use the CREATE TABLE SQL command. Below is a copy of the SQL I used. CREATE TABLE TempCashFlows ([Cash_Inflows] DOUBLE, [Cash_Outflows] DOUBLE,[Side_Acct_Balance] DOUBLE); If you take this approach you will...
  13. B

    Calling a DMax functions in different databases

    I am calling a procedure in Database B from a module in Database A. The procedure in Database B uses a DMax function. The procedure runs properly when the procedure is called in Database B, but fails when it is called from Database A. It seems the DMax function is looking for the table in the...
Back
Top Bottom