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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by ApparentlyInept

  1. ApparentlyInept

    Display record count in one subform / combo result in second subform

    Got it to work in a standard text box, although it divided the results where I actually want it to show the two numbers. Is there something in Access07 that doesn't allow you to modify a label on the form? Could have sworn I'd done it on previous versions this is what I have that works in the...
  2. ApparentlyInept

    Display record count in one subform / combo result in second subform

    Ok tried that, didn't work. Here is what I have, it is in the On Update of ClassCmbo StudentRatio = "Form!Class_Query.DCount" / "Form!Class_Subform.ClassCmbo.Column(5)" Class Query is a form built on a query of the same name and Class_Subform is the location I am attempting to put this.
  3. ApparentlyInept

    Display record count in one subform / combo result in second subform

    Need to display the number of records in Query subform over a result based on a combo box in a different subform so that it looks like this "# of records/combo result". Preferably into a label box. Thought it might have looked something like this but I am obviously wrong cause its not...
  4. ApparentlyInept

    Refresh a link to a table in another database

    NM....that was a stupid question got it done. Thx
  5. ApparentlyInept

    Refresh a link to a table in another database

    No password so sorry to not be able to help you out there but would you know what the code to delete the linked table would be? Inept
  6. ApparentlyInept

    Refresh a link to a table in another database

    Ok...here's my problem. I have a series of forms created in a file that all point to a table in another database. As such I linked that table to the current file. Problem is whenever the users go to open the file on a new system it says that the linked table couldn't be found so I have to open...
  7. ApparentlyInept

    Command or action Save Record isn't available now?

    Thx Zameer
  8. ApparentlyInept

    Command or action Save Record isn't available now?

    Runtime Error 2046 The Command or action Save Record isn't available now. Anybody know why this error might be coming up? I have it set as a OnClose event. When I go to debug it highlights the entire DoCmd action. Private Sub Form_Close() DoCmd.DoMenuItem acFormBar, acRecordsMenu...
  9. ApparentlyInept

    Can I have input in a form from one db and output into another?

    Jedel- Got it to work after playing around with the coding a bit. Do you happen to know if there is a way to put what serial number is going to be deleted into the message box that comes up when it comes up? Btw Thx ALOT for all the help. Phil
  10. ApparentlyInept

    Mouse Cursor

    No worries, glad I could help.
  11. ApparentlyInept

    Search Page

    The only thing I can think of...mind you I'm not 100% Access savy, but if memory serves having "Data Entry" set to yes automatically sets the form to add a new record.
  12. ApparentlyInept

    Mouse Cursor

    Have you checked to see if your insert key has been pushed and you are in overtype mode?
  13. ApparentlyInept

    Can I have input in a form from one db and output into another?

    Jedel- I posted it into my OnClick intead of after Update because I wanted to control when the form closed and deleted the record. Thing is it didn't work. I changed what you had as Sign_Out_Date to fld310_Recieved because I want that field to control whether or not the record is deleted from...
  14. ApparentlyInept

    Can I have input in a form from one db and output into another?

    Only check boxes I have are in my "Add Equipment" form, "Update Equipment" form and TableA(ITAMS) and these are to indicate whether the equipment is classified or not. The form we were working on had nothing to do with the check boxes. But I think that what you posted will work, and if not it...
  15. ApparentlyInept

    Can I have input in a form from one db and output into another?

    I'm trying it but not exactly getting it to work. This is what my coding looks like. I have it as an OnClick action. Its not liking the * I am wanting it to delete anything From TableA(ITAMS) that is in TableB(Equipment_Tracking) that has a date in field 310 Recieved. Then save...
See more

Part and Inventory Search

Back
Top