Page 6 of 16 FirstFirst 123456789101112131415 ... LastLast
Results 76 to 90 of 232
  1. #76
    JFo is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2011
    Posts
    393

    So now adding and editing inspections and equipment is working however still can't requery frmEquipment after new equipment is added

  2. #77
    JFo is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2011
    Posts
    393
    I know this is not what you wanted however this main form is used as a menu albeit with code it now adds the inspections in new (add) or edit mode and then you can open equipment in add or edit mode

    I will start working on your form now

    Thanks
    Attachment 4836

  3. #78
    Rainlover's Avatar
    Rainlover is offline Expert
    Windows 7 64bit Access 2003
    Join Date
    Nov 2009
    Location
    Queensland Australia
    Posts
    691
    How do you Edit Cities from this Menu.

    Or equipment or Clients etc. How do you change a Clien't Contact's Phone Number?

    My suugestions need a proper Menu. If you need to use the Current form then my suggestion is wrong.

    PS With my Menu, the other forms will be created eventually. I am not suggesting that ALL of what you have done is wrong. You just have a difficult way of getting there.

  4. #79
    JFo is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2011
    Posts
    393
    Yes you are correct there is not a way to edit everything from main form however everything can be edited somewhere in database. I have not produced a comprehensive menu yet as I was trying to get the difficult stuff done

    I am working on it now

    Thanks

  5. #80
    JFo is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2011
    Posts
    393
    Attachment 4838

    OK I have done exactly as instructed new form frmMenu has the menu command options that open the forms with the combos and only code is not in list (only for cmbStates in frmCities2 at this stage)

    Thanks

  6. #81
    Rainlover's Avatar
    Rainlover is offline Expert
    Windows 7 64bit Access 2003
    Join Date
    Nov 2009
    Location
    Queensland Australia
    Posts
    691
    Whan I said..........

    Create the Following Forms. Sities, Cities, States, Clients and Contacts.

    I was thinking that you would include all the Fields from the Table.

  7. #82
    JFo is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2011
    Posts
    393
    Hi Rain sorry for delay hope you had a good weekend

    Apologies if I do not entirely understand what you are asking for, is the attached what you were inferring?

    I have made the forms and the menu and queried tables for input, I have also now included all the fields for each table to the forms (clients is notable difference as not sure what you want with this one)

    Not sure if I understand however either way I do agree I need a better menu for adding/ editing

    Thanks

    Attachment 4861

  8. #83
    Rainlover's Avatar
    Rainlover is offline Expert
    Windows 7 64bit Access 2003
    Join Date
    Nov 2009
    Location
    Queensland Australia
    Posts
    691
    Think of it this way.

    Just for now forget about the equipment.

    Simply create a Form/Forms for the purpose of recording all the information about your Clients. (You will also need a Form for Contacts, Cities and States.)

    This includes, all the Site and Contact information.

    From the Contact Form use Combo boxes to select the Client, Site and City.

    From the Site Form use Combo boxes to select the Client, Site and City.

    You will need to use "Not on List"

    Is this a problem?

    The next problem will be to handle Multiple Sites and Contacts. But do the other first.

  9. #84
    JFo is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2011
    Posts
    393
    OK not doing anything with Equipment I created the four forms and think I have included all relevant info.

    Simply create a Form/Forms for the purpose of recording all the information about your Clients. (You will also need a Form for Contacts, Cities and States.) This has been done, but confused

    From the Contact Form use Combo boxes to select the Client, Site and City. Again this has been done however have not used cascading combos

    You will need to use "Not on List" Trying to work out what you mean by this I have Not In list code in states combo in frmCities2, is this what you mean or maybe if notinlist then it opens another form to enter new rather than just doing it for the combo?

    Attachment 4863

  10. #85
    Rainlover's Avatar
    Rainlover is offline Expert
    Windows 7 64bit Access 2003
    Join Date
    Nov 2009
    Location
    Queensland Australia
    Posts
    691
    Which Form is the new one for Clients?

  11. #86
    JFo is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2011
    Posts
    393
    frmClients2

    This is where I am most confused I just have 3 combos one for clients, one for sites and one for contacts

    Only thing I can assume is that you select client, combo and sites, If either is not in list than you add another, either like in cmbStates as discussed or by opening the relevant form ie frmContact2 or frmSites2

    Is this correct or am I not understanding where you are going with this?

    Thanks

  12. #87
    Rainlover's Avatar
    Rainlover is offline Expert
    Windows 7 64bit Access 2003
    Join Date
    Nov 2009
    Location
    Queensland Australia
    Posts
    691
    Your Client Form does not have ALL the information, (as per the Table)

    Have a look at the Sites form that I fixed.

  13. #88
    JFo is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2011
    Posts
    393
    so I should have all site and contact fields on the client form?

    I can see that you changed the query to take the primary key from the relationship above and therefore used CityID foreign key from tblSites and not from tblCity and the same you used StateID foreign key from tblCities and not from tblStates and then you just selected all other fields from tables

    How do I deal with junction tables with a query like this? I have changed the compound key to a junction key, and added everything to the query like you did however as CityID is in tblContact and tblSites I added it twice

    Not sure what other fields you want on form

    Thanks

    Attachment 4865

  14. #89
    Rainlover's Avatar
    Rainlover is offline Expert
    Windows 7 64bit Access 2003
    Join Date
    Nov 2009
    Location
    Queensland Australia
    Posts
    691
    I can count 2 Fields in tblClients.

    You have 5 in your Form.

    How can I explain this better.

  15. #90
    JFo is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2011
    Posts
    393
    OK I am a little confused I have included ClientID if that is all it was missing

    Clients (Clients will have a Dropdown box for Contacts) Contacts

    Yes there is a drop down for contact

    This includes, all the Site and Contact information.

    All site and contact info was included as well as Cities/ States as this is part of Contacts... Do you want 1 combo as first statement implies or every field as 2nd statement implies?

    Thanks

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Coding question
    By kzoli62 in forum Access
    Replies: 1
    Last Post: 07-04-2011, 05:09 PM
  2. Combo Box Coding
    By Hale in forum Forms
    Replies: 2
    Last Post: 05-04-2010, 10:56 AM
  3. Coding for Empty Combo Box
    By gazzieh in forum Programming
    Replies: 1
    Last Post: 03-26-2010, 05:22 PM
  4. Button Coding
    By yamie in forum Programming
    Replies: 3
    Last Post: 02-22-2010, 10:45 AM
  5. Bar-Coding
    By texasprincess7 in forum Access
    Replies: 1
    Last Post: 02-12-2009, 10:29 AM

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