-
New Feature: You can now see the most frequent posters by month. Check out this link for details.
June7's latest activity
-
June7 replied to the thread Data Entry Form W/Subform Creates extra records?.Option 4: Certainly primary and foreign keys. Each of the 3 operative tables would link to Visit with vid. -
June7 replied to the thread Data Entry Form W/Subform Creates extra records?.So PQ1 and PQ8 and PQ15 each document a different question? Not the same question asked 3 times? If you don't want to fully normalize...
-
June7 replied to the thread Data Entry Form W/Subform Creates extra records?.Fields with a number suffix usually indicate repetitive type of data. Example: University1, University2, University3. Are you saying...
-
June7 replied to the thread Order by Error but no Order By Clause.May or may not be contributing to issue but do all the queries use a field named Time? Time is a reserved word and advise not to use...
-
June7 replied to the thread Change the background color of a text box.Conditional Formatting is far from a temporary solution. With VBA, all records on form will show the same settings so is not practical...
-
June7 replied to the thread Change the background color of a text box.It is but should use Conditional Formatting instead of VBA. Yes, form Current sounds reasonable. Also, each textbox AfterUpdate or...
-
June7 replied to the thread Data Entry Form W/Subform Creates extra records?.I am saying that if you follow my design suggestion, renaming the table might make more sense but you decide. I also said you would...
-
June7 replied to the thread Data Entry Form W/Subform Creates extra records?.This is not what I was suggesting. My suggestion did not involve adding any tables (exactly what were the new tables). I suggested a...
-
June7 replied to the thread Data Entry Form W/Subform Creates extra records?.Not sure what I said led you to think that but sorry if I was not clear. You had 3 separate tabs to begin with - that's what...
-
June7 replied to the thread Data Entry Form W/Subform Creates extra records?.What do you mean by 'split into three sections'? I am not suggesting table be split. I am suggesting each form will have filter to only...
-
June7 replied to the thread Edit displayed data items.I think datagrid and gridview are associated with other programs such as C#, VB6, VB.net. In Access, use a form in Continuous view. Or a...
-
June7 replied to the thread Tables in the front end.I handle versioning a little differently. Version table is in backend and has one record with version number. Form in frontend has a...
-
June7 replied to the thread Data Entry Form W/Subform Creates extra records?.Attach file to post in thread.
-
June7 replied to the thread Data Entry Form W/Subform Creates extra records?.Will still use pk/fk link for each form/subform and each subform will create a separate record. Therefore there will still be 3 child...
-
June7 reacted to The_Doc_Man's post in the thread How to sequence duplicate values in a table? with
Like.
If you have no other way of separating one record from another, make one. I'm adding my voice to those who suggest "Autonumber." The...