Recent content by PETE314

One other option you might want to consider is an mdb that links to the SQL Desktop Engine. If temptables on the client side will be very useful you could link your SQL tables to the mdb and the Jet Engine might be an easier interface for them to create their different queries. you still have...

Access 2000 Project SQL 2000 Backend OK this is an mdb conversion to an adp. Basically I am building a form where a user can select records click a button and then code will mark those invoces paid within the Invoices table and then add data into a Payments table. My problem is that I cannot...

Access 2000 .adp front end SQL2000 backend I have 2 parameter queries written as stored procedures. I need to have a view or another stored procedure use the records generated by the 2 stored procedures in order to make a new recordset(or actually to create a new table, but that part isn't the...

Is the name of the filed you ar summing txtCalculated? If so it should read Sum([txtCalculated]) I would probably add a an Nz function for null sets Nz(Sum([txtCalculated]),0) I would also make sure that the format property for txtCalculated was set to the correct number type...such as...

Well I think my research is telling me that it is not working because in Access 2000, the recordset needs to have an Active connection. And since I am not pulling any data, my connection is null or disconnected. 2002 and up can handle it, I guess. So when I do my conversion later it could be...

Right...IIRC Access2K does not "expose" it but it is still there and can be called in VBA....

Well AddCostSQL is just a string expression of what is already there...with one exception. The Where Clause uses a ? and I use input parameters in the properties of the subform. So my guess is that would work...except that AddCostSQL ends up being a null recordset which is what I am trying to...

Could this also be a problem with references????I am pretty sure I have everything I needed clicked... I have in this order VBA Access 9.0 Object Library OLE Automation Active X Data Objects 2.1 Library Microsoft Forms 2.0 Object Library

Just tried it..... It said that the object I entered was not a valid recordset property..... Runtime error 7965..... so is it talking about ZeroRs.....or is it talking about the property "Forms![frmInvoiceInformation]![subfrmAdditionalCosts].Form.Recordset"??????

Office 200 ADP SQL2000 Backend My solution to this is a little brutish but I think it will work. I can determine in what mode I am opening the form in by evaluating option buttons on the form before it. So If I am opening in Read Only Mode....I can take the SQL statement for the...

Thank You PHV.... You know I thought that would work when I first saw it....and how I missed that I cannot fathom...LOL...but unfortunately it doesn't seem to be working :( I even added another NZ around that....no luck.....hmmmmm...strange....everything is telling me that it should work...but...

It doesn't make sense to me either....LOL And I tried to recreate without any real success. So I did an exhuastive investigation on the data......I have JUST concluded that I have been given bad test data. There are holes in the data. Hence the null recordset, which just sets the entire...

Everyone else stumped too??????

Access 2000 Project SQL2000 Backend I have a Search Engine that opens a form(B) based on the selected record from the Search Results. Form B has a recordset based off of a SQL Statement with Input Parameters. Form B has 2 subforms one that is just informatory and is always Read Only (Edits...

Access 2000 .adp SQL 2000 backend I have an order tracker. I am keeping track of the status of each order. So I have an OrderStatus table with fields such as PK -> OrderStatusID, DateTime, OrderID, StatusID, Notes. The StatusID field on the form is a combo box that pulls from another table...