Search results

  1. A

    Subform fields locked

    What does the status bar tell you when you try to update the yes/no field on a subform?
  2. A

    Anyone try tracking org charts in Access???

    This can be done with Tree view control
  3. A

    Autofill Columns of Table with Values from Another Table

    How do you know that tblcode has respective value if you loading smth from another source ? Is there any field in outer source which can be used as a ref a value in tblClist?
  4. A

    LMS design

    What would be the best way of creating the LMS for periodical certifications, training and retraining of the staff. I mean the dbase design. Trying to create a pool of ideas on this. Thank you very much Alexei
  5. A

    Updating a text box to scroll

    The answer seems suspeciously easy In the properties of your txtEadd box change "scroll bars" from "none" to "vertical"
  6. A

    Invoicing Problems

    Well I think that ReclusiveMonkey hit the bull eye. Your invoice doesnt bear any invoice number ... I am confused how do you identify one invoice from the other ? Next ( I will assume that you group your details by Student ID ) in design of you report go to the sorting and grouping, group on...
  7. A

    Invoicing Problems

    In the design mode of your report look at the "details" section, make sure that fields for details of the invoice are placed in this section. Also check if you accidently didn't put the page break after the detail field. Also if you can make a print screen of your report in design mode it would...
  8. A

    Organizational Hierarchy

    Do you have a fixed number of levels of subordination?
  9. A

    how can i create a consolidation script

    The courtesy of Terry Kreft and Dev Ashish
  10. A

    Disable Button

    check this out
  11. A

    Assign Default Value

    What do you mean a default pin# for the other insurances? I looked in your tables there was nothing like "default" If you just need to show on the report a word "default" whenever there is nothing in the Pin# field then go to design of your report Change the properties of pin# field Name -...
  12. A

    DataChange Event

    I think it is ... at least this is what the status bar says when you put the cursor on the datachange event.
  13. A

    DataChange Event

    Macro or function that runs when PivotTable triggers its DataChange event
  14. A

    how can i create a consolidation script

    Why don't you just remove the standard menues and let the user get into the free design of a query ( letting him use the query design tools )
  15. A

    OnOpen form event Filter a Combo Box in Subform

    In the properties of your combo box select the row source type - Table/Query In the row source paste the following SELECT Tbl_InvoiceCostCodes.CostCodeID, Tbl_InvoiceCostCodes.CosCodeType FROM Tbl_InvoiceCostCodes WHERE (((Tbl_InvoiceCostCodes.CostcodeType)="repairs")); Column count = 1 This...
  16. A

    Adding records in subform

    To normalize the timesheets. SELECT Timesheets.Timeid, Timesheets.TimeContid, Timesheets.TimePosid, Timesheets.FCCtimeid, Timesheets.Timeshift, Timesheets.Timedate AS Work_date, Timesheets.WOnumber, Timesheets.Timeuserid, Timesheets.[1] AS Work_Hours FROM Timesheets WHERE...
  17. A

    Implement an undo for a subform

    How about the referential integrity .... Run the delete query if you have committed the values in table A and also committed the values in table B ( subform )
  18. A

    Returning All Values in a Query

    Change in SQL of your query the word INNER to Left. You want to see every record from the table tblJobDetails and also records from tblMaterials if they present ( if I am not mistaken )
  19. A

    Displaying linked updatable and non updatable records in form

    Just like Pat Hartman said : all you need is to create the additional subform which will have only calculated fields while your other subform will be updateable.
  20. A

    E-mail form

    Check this out
Back
Top Bottom