Page 3 of 6 FirstFirst 123456 LastLast
Results 31 to 45 of 78
  1. #31
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    You should not display PK fields on forms.


    You should NOT have an asterisk in the field name.

    Between tables "CallLogtblNEW" abd "Comments", you STILL have a 1-to-1 relationship!! Look at the relationship image in my last post.


    Why do you have table "ProductTypes" with a PK field names "RoleID-PK"??? (and shouldn't have a hyphen in the name. Instead, use the underscore)

  2. #32
    Tradesman is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    May 2019
    Posts
    52
    HI - yep sorry i think i have resolved all you emntione d- i cant get the relationship images to match up - as you can see it is a one to many relationship???

    what am i doing wrong ive been all over google and ive set the correct parameters

    Click image for larger version. 

Name:	design 4.jpg 
Views:	18 
Size:	93.1 KB 
ID:	38959

  3. #33
    Tradesman is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    May 2019
    Posts
    52
    Click image for larger version. 

Name:	design5.jpg 
Views:	19 
Size:	68.2 KB 
ID:	38960
    so i didnt enforce integrity now i have!

  4. #34
    orange's Avatar
    orange is online now Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    What is latest status?
    See "stump the model" for making good use of your model on paper.
    There are many articles in the Database Planning and Design link in my signature.
    Good luck with your project.

  5. #35
    Tradesman is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    May 2019
    Posts
    52
    Now I get this.......

    Click image for larger version. 

Name:	Capture.PNG 
Views:	16 
Size:	7.2 KB 
ID:	38962
    how do i resolve this its something todo with the changes i made to get one to many to work

  6. #36
    Minty is online now VIP
    Windows 10 Access 2016
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,001
    Somewhere you have named a field or are trying to make a calculation in query with *callID_PK

    Or have set a child / master pointer incorrectly on a form?
    DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

  7. #37
    orange's Avatar
    orange is online now Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Or, you may have a typo/spelling mistake.

  8. #38
    Tradesman is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    May 2019
    Posts
    52
    sorry being thick again - ill restart this development as phase 2 i think!

  9. #39
    Tradesman is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    May 2019
    Posts
    52
    yes yuour all right the table had been renamed removing the * but the table was still pointing to it.

    Now my next stages

    1) call log form - to add comments when I've made a call/email - especially reminder date ( which i set at date()+14 and also an action required date ( if i get a quote to do or samples to send for example).
    2) QUESTION _ how do i set up a button to add comment when working in the calllogtable form? current form below

    3) the query report seems easy enough - where i query who need a a follow up by date - any fancy ways of doing it?

    so my flow is
    1) make calls/emails - track any feedback or add dates to follow up
    2) be able to add a comment - eg on holiday,spoke to dave-theyve asked me to call back etc ( I would like to see scroll through these on the calllogtble screen ( I think this is called a subform but i couldnt format it very well )
    3) run a query by date follow up required so i can priorities who needs a call.email follow up

    any ideas that you can point me towards would eb great

    Click image for larger version. 

Name:	cal log form.PNG 
Views:	16 
Size:	42.2 KB 
ID:	38964

  10. #40
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Maybe you would post your dB so we can see what you see??

    See "How to attach files" in the top header.

  11. #41
    Tradesman is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    May 2019
    Posts
    52
    Hi Guys- heres the DB - please explain what you've done to do the enhancements - its so close
    Attached Files Attached Files

  12. #42
    Minty is online now VIP
    Windows 10 Access 2016
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,001
    I think you'll need to save this in an earlier format, I'm using 2016 and can't open it!
    Is that an option?
    DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

  13. #43
    orange's Avatar
    orange is online now Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    I can open with O365. I don't use macros so did not investigate events.

  14. #44
    Tradesman is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    May 2019
    Posts
    52
    Hi - I loaded it as a zip file ( download 7-zip freebie to unextract)

  15. #45
    Minty is online now VIP
    Windows 10 Access 2016
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,001
    Quote Originally Posted by Tradesman View Post
    Hi - I loaded it as a zip file ( download 7-zip freebie to unextract)
    I know, but I can't open the Access file with Access 2016. Is there an option to save it in an earlier format within O365 ?
    DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

Page 3 of 6 FirstFirst 123456 LastLast
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 09-19-2017, 11:07 PM
  2. Need help not sure what to call it :-(
    By jscalem in forum Database Design
    Replies: 8
    Last Post: 08-30-2017, 12:45 PM
  3. What do you call this?
    By mrmims in forum Access
    Replies: 4
    Last Post: 11-11-2015, 12:43 PM
  4. Call and phone
    By drunkenneo in forum Programming
    Replies: 0
    Last Post: 08-28-2013, 12:49 AM
  5. Not even sure what to call this one
    By eizquierdo in forum Queries
    Replies: 2
    Last Post: 03-14-2013, 12:08 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums