Search results

  1. A

    Form wont close after using a macro

    Greetings! I am having a slight issue with one of my forms that cant be closed. Please download the attached database in order to see what i mean :) I have tried to make macros that will open the form called frmLogHours. Both the cmd button "New Work Item" and when i press the ID in a source...
  2. A

    Change list in Lookup Field in Form without changing previous inputs

    Greetings people of Access World Forums! I have a small issue with a time sheet database. I started making a database some time ago, but then i came over this awesome premade database which you can download directly from access. So i made some tweaks to make it fit for my purposes and stuff...
  3. A

    Sum of values in linked tables

    Greetings! I have uploaded the database I am speaking of. Access it through the link below. Please look at this file for details in the structure of my database to get the necessary info if you are able to help me. I am having an issue with a query im trying to set up in a hose tracking...
  4. A

    Change ID to something users can consume

    Greetings! I am trying to create forms to interact with a database i made to track usage of assets. In my tables i have linked many of my assets to each other by using their unique ID numbers. For instance the ID number of my assets are linked to a foreign key in a locations table. This way i...
  5. A

    Sum of selected rows of a columns data

    I have an issue i cant seem to resolve where I am trying to sum some datacells in a column based on a foreign key. I have 3 tables. One table is for my assets, one table is for different projects my assets can be assigned to, and a third table linking each project and asset and lists material...
  6. A

    Linking two primary keys to the same foreign key

    Hey everyone! I have an issue with building an asset tracking database. I will try to describe my situation as detailed as possible in hopes that someone can help me figure out how to solve my problems. I have two asset types, Asset1 and Asset2, which each have their own serial number mask...
Back
Top Bottom