Jack F's latest activity

  • J
    Jack F replied to the thread Fairly New and Need Help.
    I agree, take a call and make an appointment if there are no restrictions. The forms and subforms may be beyond my knowledge right now...
  • J
    Jack F reacted to MajP's post in the thread Fairly New and Need Help with Like Like.
    To design this I would have Dashboard with buttons to get to the different forms frmTechnicians to add edit technicians frmCustomers...
  • J
    Jack F replied to the thread Fairly New and Need Help.
    Thanks for the input. I see what you are saying. I like the designation _FK. I used a check box set up for PO_NO_Required. Hopefully it...
  • J
    Jack F reacted to MajP's post in the thread Fairly New and Need Help with Like Like.
    People have different naming conventions the trick is to be consistent and make names that will make building and maintaining the db...
  • J
    Jack F replied to the thread Fairly New and Need Help.
    Thank you for pointing this out. It makes sense in the bigger picture. I will do some adjusting as I continue developing the database.
  • J
    Jack F reacted to MajP's post in the thread Fairly New and Need Help with Like Like.
    You do not have to prefix your objects but Access makes it confusing if you do not. If your make a report or query or form based on a...
  • J
    Jack F replied to the thread Fairly New and Need Help.
    Thank you. I will adjust the names. I agree, in the future as the data grows, it will get confusing.
  • J
    Jack F reacted to MajP's post in the thread Fairly New and Need Help with Like Like.
    To add to larry's design. Do not use special characters except an underscore PO_No not PO# COD_Bankrupt not COD/Bankrupt However that...
  • J
    Jack F reacted to LarryE's post in the thread Fairly New and Need Help with Like Like.
    I would start with a design similar to this and go from there. Of course you may want to add other relevant fields in the tables as...
  • J
    Jack F replied to the thread Fairly New and Need Help.
    Thanks and I see your point. A 1 to many does clean up the model much better than my idea. Yes, a customer can have multiple COD's. They...
  • J
    Jack F reacted to XPS35's post in the thread Fairly New and Need Help with Like Like.
    I'm sorry to say this Jack, but I don't think your model is correct at all. To name just a few key points. You create relationships on...
  • J
    Jack F replied to the thread Fairly New and Need Help.
    Yes
  • J
    Jack F replied to the thread Fairly New and Need Help.
    Thanks, I see a couple things I can incorporate but, I need it more for dispatch purposes.
  • J
    Jack F reacted to arnelgp's post in the thread Fairly New and Need Help with Like Like.
    there is a sample customer service database template from microsoft. the attached is the accdb from that template.
  • J
    Jack F replied to the thread Fairly New and Need Help.
Show older items
Back
Top Bottom