Search results

@mike60smart why if it's a unique identifier do you think the PK has to be an autonumber? A number of sources I've read don't support this. In all (almost all?) of the other tables, I have an autonumber PK, but in this one, the master table, it's really important that I keep track of the project...

Hi--here's the cleaned up database. I just noticed as I was scrolling back through records that there is legacy data in the Agreements field within the Grants and Agreements subform. I'm confounded as to why that information is showing up there when it has been deleted (or mostly so) from the...

Oh dear. I do understand what you are saying about not freehanding the SQL code, but trying to work out how to create a query to do this might be beyond my capacity--at least for the moment. I might have to work out a different way to achieve this results, even if it's less elegant than your...

Interesting--that's true, from my perspective, but our supervisor wants to know if a person has stopped work on a project, or just has nothing to say for that month. I think there's qualitative information here that is valuable. If I'm understanding you correctly, as you present it, no update...

Hi, I have a user input form for project records. It contains a few different subforms. Two are working fine, display data and allow data entry. The third, Grants and Agreements, does neither. It will display all fields within the form, as long as there is data entered in at least one of the...

Thank you @ebs17 . I will take note of this. Programmatic evaluation occurs several levels up from me! In this project, I am just a data tracker. The update text is meant for the staff/director. My primary interest here is whether or not a project has gone idle (indicated by 3 continuous months...

Hey there, I'm pretty new to coding (I'm learning!). If, on the data entry form, I click the "view code" button on the top menu, the coding window opens up, containing code I previously entered when I created an edit button for the form/records (That code follows below). Based on the coding...

Hi @plog, yes, you are exactly right. My field names are different but the setup is the same as the one you proposed. See below for the field names/table relationships. I have a Secondary table for comments, TblBMonthlyUpdates. It connects to the Primary Projects table (TblAALWRIProjects_New)...

This thread is related to another I posted earlier. I am trying to query for projects that have gone idle. Users input data into a long text field, "UpdateText" for project reports. This is a method of communicating with the team. They need to be able to enter this information freeform. If there...

@mike60smart, the user can enter any text they like into the update field, but they usually include a phrase like "no further updates", "no new update", or sometimes just "no update".

@ebs17 so, then would I write a new query with the query above (before your code) as a field within the new query?

@ebs17 Hey, I swapped out the old Projects table for a new one, and deleted the MonthlyUpdates table from the query and opened the SQL view, and then added your code in after the code that was already there. When I try to run it, I get an error message indicating there are characters after the...

Thank you so much @mike60smart ! I'll spend some more time walking through the changes you made here and see if I can understand them a bit better/use them for the next subform.

I'm running the analyzer now--it split the first table analyzed into 3 new tables, so I will spend some time now trying to understand the relationships before coming back to the query question, but I will come back to it! Thank you so much for this thoughtful response. O.

Also, how did you get your subform to display as a continuous form with records as rows? When I select continuous form, it displays the authors as individual records. The closest I can come is by selecting datasheet for the default view. Not nearly as slick.

Right you are. Fixed. Thanks again!

Thank you @MajP and @Pat Hartman, working on this now! @MajP apologies for misquoting you. I misread/understood what you wrote. This DB has been keeping me up at night. I really appreciate all the help!

It's a work of art. Thank you so much. I'm going to slowly walk through the design with my up-all-night brain now adn hope to be able to apply what you've taught me to the other input forms. Thank you again, so much!

Thank you--I think my junction table is set up as you explained above, but instead of the two fields being primary keys, there is a separate autonumber ID field. It seems like folks on these forums tend to use one approach or another (I was lightly admonished earlier for having two fields act as...

This post got buried in another very long thread, so I have cleaned it up and am giving it another go. I am trying to populate a junction table, but have run into some trouble. I created a subform with a field of interest (PolicyReviewID) from a junction table and fields of interest (staff...