Page 2 of 2 FirstFirst 12
Results 16 to 22 of 22
  1. #16
    Gicu's Avatar
    Gicu is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101

    Hi Cassandra, first of all please call me Vlad, I'm not that old .... it would really help if you could upload a copy of your db, especially if you don"t yet have any confidential info in it. To do that you can first go to the Database Tools tab of the ribbon and select Compact and Repair, then close it , zip it and upload it by clicking the Go Advanced button in the forum and Manage Attachments.
    Cheers,

  2. #17
    Join Date
    Feb 2020
    Posts
    18
    Oh I guess I should try scrolling down one in a while to see that. Super easy. Thank you. It says that my file is too big to attach? Any other ideas? I'll see what I can do to cut some of the memory.

  3. #18
    Join Date
    Feb 2020
    Posts
    18
    I backed up the original and only included what was necessary. Let me know if it doesn't work. Upon clicking on the file the login will pop up but you can click the x to get out of it. I will change that later. Thank you so much!

  4. #19
    Gicu's Avatar
    Gicu is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    Hi Cassandra,
    Could you please have a look at the attached, it should do what you originally asked (sorry for the delay in getting it), but I still recommend changing the design so you are not dependent on how many/ who the engineers are. So many people (mainly engineers,, ) think in spreadsheet "format", it takes a bit of time/ research to get the database concepts. But once you do it will (almost) always make things much easier.
    Cheers,
    Attached Files Attached Files
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

  5. #20
    Join Date
    Feb 2020
    Posts
    18
    THANK YOU SO MUCH!!!! It works like a charm. I will give this version to them so they can get started on it and in the mean time I will take a look at that other bit of code that you suggested. Would you mind explaining the "AssignedTo" portion that I saw?

  6. #21
    Gicu's Avatar
    Gicu is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    Glad to hear it works. What I was suggesting was to replace all the current Yes/No fields (one for each project/engineer) with one short text field names AssignedTo. Then to filter on that you would use the expression I wrote in that previous post. The AssignedTo field could be bound to a combo box on the form having its row source the tblUsers table. This assumes that one item can only be assigned to one project at the time. If it can be assigned to multiple you would need to use a join table (AssignID,ItemID,ProjectID,FromDate.ToDate).

    Cheers,
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

  7. #22
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    My comments.....
    I know you are very new, so my comments are meant to help you learn.


    About naming convention -
    Use only letters and numbers (exception is the underscore) for object names.
    Do not use spaces, punctuation or special characters in object names.
    Do not begin an object name with a number.
    Do not use Look up FIELDS, multi-Value fields or Calculated fields in tab

    "Name" is a reserved word in Access and shouldn't be used as object names.
    Problem names and reserved words in Access
    You have spaces and special characters in field names

    With regards to my Post #13
    Quote Originally Posted by cassandragubler@gmail.com View Post
    I didn't not sketch anything out before creating this database.<snip>
    So from the dB and your responses, initially it seems the tables you need are

    tblUsers,
    tblProjects,
    tblInventory,
    tblInventoryCADPAD (why two inventory tables?)

    If more than 1 person is assigned to a project, then you need a junction table
    jnctUsersProjects


    If more than 1 user/engineer will be using the dB at the same time, you will need to split the dB into a BE (back end) that has only tables and a FE (front end) that has all of the other objects.
    The BE should be on a computer/server that everyone has rights to and everyone should have a COPY of the FE on their local computer.
    If everyone uses the same FE, you will have a corrupted dB. Not a matter of IF, just a matter on WHEN.

    Click image for larger version. 

Name:	Tables1.png 
Views:	7 
Size:	71.2 KB 
ID:	41040

    Info on normalization Roger's Access Blog


    Forum Home > Roger's Access Library > Tutorials

    For practical experience / learning spend 45-60 minutes and work through one or two of these tutorials from RogersAccessLibrary.
    ZYX Laboratories ***recently added
    Class info system
    Catering Business
    Widgets



    Good luck with your project....

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Loading A Form
    By Robert2150 in forum Access
    Replies: 5
    Last Post: 06-24-2015, 01:38 PM
  2. Replies: 3
    Last Post: 07-11-2014, 08:13 AM
  3. loading empty form
    By Suzie2012 in forum Forms
    Replies: 5
    Last Post: 10-10-2012, 07:03 PM
  4. Possible If statement for loading of a form
    By computer_man20037 in forum Programming
    Replies: 2
    Last Post: 05-16-2012, 09:53 AM
  5. Form title dlookup problem
    By zoinnk in forum Forms
    Replies: 3
    Last Post: 10-03-2011, 08:40 AM

Tags for this Thread

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