Recent content by BillP

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

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

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

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

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

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

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

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

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

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.

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

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

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