Search results

  1. M

    Use fields in query based subform to populate a table

    Thank you JLCantera, I will definitely consider this when I re-visit.
  2. M

    Use fields in query based subform to populate a table

    I am going to step back and re-evaluate. I think this is probably the strategy that I needed to use but, I also needed it to create new field entries for the second sub-form. Thank you for all of the help.
  3. M

    Use fields in query based subform to populate a table

    Thank you again for the help. Using vbaInet's advice and putting the sub-forms side by side, when I click on the "..." next to link master fields, it only gives the option of a master field coming from the main form field list. Is there a way I can override that and type in, in its...
  4. M

    Use fields in query based subform to populate a table

    Thank you MarkK, when I try to add a subform to the form, I get the error that "a form with a subform object can't have its defaultview property set to continuous form", is the only way to do this to have the main subform as a datasheet view?
  5. M

    Use fields in query based subform to populate a table

    Apologies for not explaining this in a good enough detail to make it understandable. I have several analysts that perform the same functions but for different project sets. Each analyst has multiple projects that they manage. Each of those projects will end up with multiple orders, and each...
  6. M

    Use fields in query based subform to populate a table

    Maybe there is a possibility to skip using a sub form on it at all and instead add an unbound control to the order information sub-form that would use an after update event to populate the information from the order information sub-form to the new table, "order scope", with the three columns...
  7. M

    Use fields in query based subform to populate a table

    I have a main large form that is based on an identifier of a project number. One of the tabs holds a sub-form that shows the order information, based on a query, associated with each project (this order information is from a company table and cannot be modified by me.) I need the user to be...
  8. M

    Use fields in query based subform to populate a table

    The problem with doing it this way is that there could be five lines in the primary sub-form and as such there should be five lines in the secondary sub-form.
  9. M

    Use fields in query based subform to populate a table

    I tried to add a sub-form to the existing sub-form but it would not allow me to do this on a continuous form. Is there a workaround?
  10. M

    Use fields in query based subform to populate a table

    I have a main screen that has a tabbed form in it. Each of those tabs has a sub-form in it that displays information and allows some information to be updated. In one tab I have a query based sub-form that returns information related to the project. This information cannot be manipulated...
  11. M

    Calculated Status Field

    Thanks Smig, I think this will work for me.
  12. M

    Calculated Status Field

    The status field where each one of them is showing as dead is the desired outcome and it is dead because one of the actions was deob. Basically, if an asset get a deob action then it needs to show as dead.
  13. M

    Calculated Status Field

    ProjectNumber Status Action 100002.0004.AC.ABCEFGHIJKLMN Dead NEW 100002.0004.AC.ABCEFGHIJKLMN Dead INCREASE 100002.0004.AC.ABCEFGHIJKLMN Dead DEOB
  14. M

    Calculated Status Field

    Table: [Details] - Field Name [ProjectNumber] - Field Name [Action] ProjectNumber Status Action 100002.0004.AC.ABCEFGHIJKLMN Dead NEW 100002.0004.AC.ABCEFGHIJKLMN Dead INCREASE 100002.0004.AC.ABCEFGHIJKLMN Dead DEOB In cases where the project number is the same, if there is...
  15. M

    Calculated Status Field

    Can anyone tell me how to create a calculated field that does the following: I have a table that has about 4000 records in it. An asset can be listed in the table multiple times but I need to change the a status to "Dead" if any record with the same asset id has an action of "Kill". Any...
  16. M

    Populate a field with a sequence number based on two criteria

    This is the code that worked for me. It had to do with Project Number being a string instead of a date or number. "[ProjectNumber] = '" & Me.[ProjectNumber] & "'")
  17. M

    Populate a field with a sequence number based on two criteria

    Scratch the idea of using multiple criteria, I cant get the code line that I posted to work. I am getting an operator error. I added brackets before and after ProjectNumber but it is still erroring out.
  18. M

    Populate a field with a sequence number based on two criteria

    I think I am really close with the code that I posted but I keep getting a missing operator error.
  19. M

    Populate a field with a sequence number based on two criteria

    I am trying to get the max of an integer field if the ProjectNumber field is equal to the ProjectNumber field in the current record. I have used code similar to the one below before but it was on a date field, then add one. Me.RevisionNumber = Nz(DMax("[RevisionNumber]", "dbo_ProposalLog"...
  20. M

    Code to Open a Form to a specific record

    Aha. Thank you so much. Below is what worked. Private Sub Project_Number_DblClick(Cancel As Integer) Dim rs As Object Dim lngBookmark As String 'set variable to the current record lngBookmark = Me.Project_Number 'open new form DoCmd.OpenForm "Asset Status" 'take it to selected record...
Back
Top Bottom