Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. PETE314

    MDB vs ADP

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

    Reconciliation Engine.........

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

    Using Records from 2 Stored Procedures

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

    Suming a calculated field in subform

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

    Subform Not Showing Data in Read Only Mode

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

    Subform Not Showing Data in Read Only Mode

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

    Subform Not Showing Data in Read Only Mode

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

    Subform Not Showing Data in Read Only Mode

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

    Subform Not Showing Data in Read Only Mode

    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"??????
  10. PETE314

    Subform Not Showing Data in Read Only Mode

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

    Subform Not Showing Data in Read Only Mode

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

    Subform Not Showing Data in Read Only Mode

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

    Subform Not Showing Data in Read Only Mode

    Everyone else stumped too??????
  14. PETE314

    Subform Not Showing Data in Read Only Mode

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

    Custom List in Combobox...

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

    Access(ADP)2000 vs 2002

    So there really is no advantage to converting your program up unless it is finished and/or all of the users are upgraded to the newer Office Package???? As far as distributing run time licenses....What is the procedure for 2003???? I don't recall a Developers Version for 2003 as with the...
  17. PETE314

    Access(ADP)2000 vs 2002

    Another question along this line.....If I am creating a project in 2000 to be a .ade What advantages would there be to continuing development int 2002 or even 2003???? Since their features would probably not be available if saved in a 2000 format. Also couldn't the .ade project converted to...
  18. PETE314

    Combo Boxes and Stored Procedures

    Ooops...copied the syntax incorrectly exec spGetTitles me.object value
  19. PETE314

    Combo Boxes and Stored Procedures

    Well all the objects have a properties window that can be brought up.....I was just trying to confirm that the RowSource for the combobox would have to be handled in code as opposed to the Properties Window. I mean what is to stop me from entering the following into the RowSource property in...
  20. PETE314

    Combo Boxes and Stored Procedures

    So the row source needs to be programmatically set everytime the combo box has focus?....it cannot be done within the combo box's properties????

Part and Inventory Search

Back
Top