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

    Form Resize problem

    Thanks for the suggestions, however there are some hooks to consider. There is a linked form which appears on the screen, at the same time as the mainform/subform, so I cannot make it a popup as it restricts access to the linked form. Also setting Auto Resize On makes no difference to the...
  2. RealKiwi

    Make a text field = to 2nd column of combo box

    Me!textCompanyName.Value = Me!cboCompany.Column(1) Sheesh, that's more or less identical to the code I'm using, but I keep getting the "Can't assign a value to this object" error. Any ideas on this one? Also Form.AllowEdits & .AllowAdditions are set to True. help! RK
  3. RealKiwi

    Form Resize problem

    I do not want the form to maximize -- I want it to stop resizing from the size I set up in Design mode; about 6.5in wide by 7in deep. RK
  4. RealKiwi

    Form Resize problem

    I have a mainform/subform which automatically resizes itself "sometimes" at the mainform level. Its quite random and I cannot determine what the problem is. I've read extensively in these threads but cannot find any clear direction. Im using A2K in WIN2K environment. Here are the Format...
  5. RealKiwi

    Dsum on table records

    Solved my own problem -- just forced a form recalc before doing the Dsum: Me.Recalc It would be nice to know why it wasn't working, but my guess is it's something to do with "dirty" records?? RK
  6. RealKiwi

    Dsum on table records

    Im trying to the Dsum value from a table, immediately following the addition of data to the new record's last field: Amount. For reasons unknown to me, the Dsum only sums across other table records, and does not include the newly added record. What is the accepted workaround for this problem...
  7. RealKiwi

    Trap no record in recordset

    I've restructured the code, given the prior outcome. My filters were part of the MovePrev, MoveNext buttons code. I'm now applying the Filters in the On Current event, immediately before the subform recordcount, with success.[medal] I'll now go back to AddFirstDrop procedure and see if I can...
  8. RealKiwi

    Trap no record in recordset

    I've just retraced the steps of On Current and it is still doing some rather archaic counts. Here's what happened: ER: Order 1 -- M Items 1 -- M Drops The Order record (#130) is set as follows: ItemID# DropID# 10 1 11 1 When i open the OrderItem mainform Item# 10 has 1...
  9. RealKiwi

    Trap no record in recordset

    Thanks Roy, Ive implemented your suggestions and came to this roadblock: The mainform is debugging at statement: Me!subformItemDrops.Form.AddFirstDrop with the error 2105: You can't go to the specified record. This all seems rather odd as I've already trapped the empty recordset with...
  10. RealKiwi

    Trap no record in recordset

    Seems I inadvertently put the code in the subform On Current event - douh! moved it to the mainform and voila. My sub to add the new record (when recordsetclone.recordcount = 0) is located in the subform: Sub AddFirstDrop dim dtInitialDropDate dtInitialDropDate = fnSetDefaultDropDate...
  11. RealKiwi

    Trap no record in recordset

    Oops I spoke too soon. Seems neither recordset.recordcount, nor recordsetclone.recordcount can count a filtered group. If I filter on the OrderItem before any record is in ItemDrop, I can't explain why, but both types of Recordcount omit the empty ItemDrop record and see the recordcount for...
  12. RealKiwi

    Trap no record in recordset

    You're a scholar and a gentleman. That did the job perfectly! 'Recordsetclone' must know how to count.. hehe thanks RK
  13. RealKiwi

    Trap no record in recordset

    I'm trying to fire a procedure from VBA without much success... I have OrderItems (mainform), each OrderItem can have several Drops to customer (subform). When I navigate the OrderItems I want to add one default Drop per OrderItem. My problem is I can't trap an empty recordset in the subform...
  14. RealKiwi

    Calling all Access Experts....Need Help with Startup Form....Please!!!

    Hi Try putting the same code: DoCmd.Maximize into the On Open event for your form. RK
  15. RealKiwi

    Reference a function result in a query

    Thanks Bob, but Ive wasted too much time on this one already. Pressure from the client has forced me to move on to other more important things. I'll just implement something less elegant than what I was aiming for. cheers RK "The customer is always right, when they're paying for it.
  16. RealKiwi

    Reference a function result in a query

    All appears to be well at the function end. I wrote a query just to call the function and that worked returning the expected result onscreen. I used the original query without the WHERE clause and that worked. I called both queries from the form and got the same "Too few parameters" error...
  17. RealKiwi

    Reference a function result in a query

    Unfortunately single quotes dont work. The version with single quotes returned an empty set when I knew the answer was at least one record. Before heading to the form I ran the query in Query Builder with this syntax - it works: SELECT tblCOMPANY.co_ID, tblCOMPANY.co_NAME...
  18. RealKiwi

    Reference a function result in a query

    This SQL (without quotes)works in the Query Builder window, but I get a "too few parameters: expected 1" error when driven from the form. When I added single quotes, the Query Builder doesnt return a result, but has the same error in the form. SELECT tblCOMPANY.co_ID, tblCOMPANY.co_NAME...
  19. RealKiwi

    Reference a function result in a query

    Oops I spoke too soon. Seems Access SQL doesnt like that version of the WHERE statement. I get a syntax error in the Query Builder.
  20. RealKiwi

    Reference a function result in a query

    Thanks Bob & Ken for your feedback. It was the SQL alias reference in the WHERE statement that was incorrect. My SQL is *indeed* very rusty :) cheers RK

Part and Inventory Search

Back
Top