Missomissou's latest activity
-
MMissomissou reacted to Pat Hartman's post in the thread Querying for idle projects. Yes/No field to autopopulate a text field with a set string, "no new update". with
Like.
Never use a Y/N field for something like "new updates". You force the user to remember to check this box in addition to writing a... -
MMissomissou replied to the thread Subform won't allow data entry/display form fields when record is empty.@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...
-
MMissomissou reacted to mike60smart's post in the thread Subform won't allow data entry/display form fields when record is empty with Like.
The database I uploaded is corrupt in some way and I do not have the time to fault find. I have attached a New revised version which...
-
MMissomissou reacted to mike60smart's post in the thread Subform won't allow data entry/display form fields when record is empty with Like.
Well it looks like you have not learnt anything from the 2 previous examples I have uploaded. ALL Tables should have an Autonumber PK...
-
MMissomissou reacted to Pat Hartman's post in the thread Subform won't allow data entry/display form fields when record is empty with Like.
Your schema is incorrect. I don't know how to fix it because I don't understand it. I can tell it is incorrect because I can see...
-
MMissomissou replied to the thread Subform won't allow data entry/display form fields when record is empty.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...
-
MMissomissou reacted to June7's post in the thread Subform won't allow data entry/display form fields when record is empty with Like.
Suggest you provide db for analysis. Follow instructions at bottom of my post. Could try rebuilding form from scratch. Sometimes...
-
MMissomissou replied to the thread Querying for idle projects. Yes/No field to autopopulate a text field with a set string, "no new update"..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...
-
MMissomissou replied to the thread Querying for idle projects. Yes/No field to autopopulate a text field with a set string, "no new update"..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...
-
MMissomissou reacted to ebs17's post in the thread Querying for idle projects. Yes/No field to autopopulate a text field with a set string, "no new update". with Like.
The UpdateDate field is sufficient for this. This has clear information.
-
MMissomissou posted the thread Subform won't allow data entry/display form fields when record is empty in Forms.Hi, I have a user input form for project records. It contains a few different subforms. Two are working fine, display data and allow...
-
-
MMissomissou replied to the thread Querying for idle projects. Yes/No field to autopopulate a text field with a set string, "no new update"..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...
-
MMissomissou replied to the thread Querying for idle projects. Yes/No field to autopopulate a text field with a set string, "no new update"..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...
-
MMissomissou reacted to ebs17's post in the thread Querying for idle projects. Yes/No field to autopopulate a text field with a set string, "no new update". with Like.
You can read something like that easily and casually if you want. but do not evaluate programmatically for important things.
-
MMissomissou replied to the thread Querying for idle projects. Yes/No field to autopopulate a text field with a set string, "no new update"..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...
-
