Search results

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

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.

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

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?

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

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

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

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.

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?

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

Thanks Smig, I think this will work for me.

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.

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

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

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

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] & "'")

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.

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

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

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