Search results

  1. C

    Tabs with in a Form

    Hi, I am trying to create a form where there will be information entered. The information being entered needs to be on two different pages, as they belong to two different tables. I would like to use the tab control. The problem I am having is that I want to be able to lock the second tab...
  2. C

    AutoNumber

    where would that code be?
  3. C

    AutoNumber

    Hi, I am creating a database for creating quotations. The quotation number is generated using the date, for example the first quote today would be quote number "05202015-1" because it is the first one today. The next quote today would be quote number "05202015-2" and so on. Is there a way...
  4. C

    importing metal prices

    So that Website will only do precious metals, not base metals. Do you have any other recommendations?
  5. C

    LogOut

    If I do have a logout button and they click on it what do I need to have it do in order to have it log the time and reopen the database with the login screen as a popup?
  6. C

    LogOut

    Hi, I have a fully functioning login screen with a combo box for name and a password box. It also has an option to create a new user or exit the database. On my main form I want the employees to have to log out of the database as opposed to close it out. How would I go about this? Also I...
  7. C

    importing metal prices

    I will look into that. Thank you so much. Also, once I do find a place to get this service from, how will I incorporate it into the database?
  8. C

    importing metal prices

    The way the quotes are done now are done through a certain market. Each supplier uses a market based on where they are from, but we have to enter the market value into the excel spreadsheet that is generating the quotes at this time.
  9. C

    importing metal prices

    Hi, I am creating a database for a company that makes parts. They sometimes use precious metals, and they issue quotes based on certain market prices at the end of the day before. I would like to have a combo box to select from the individual markets they may use. From that combo box I...
  10. C

    Linking Tables

    what do you mean by normalized? I am new to Access.
  11. C

    Linking Tables

    Final Result: I want an employee to be able to log in to my database and click a button that takes him to a form where he can create a new job. I want him to be able to choose from a drop down menu any Master Part Number he wants, and enter a quantity, date, and some other fields which will...
  12. C

    Linking Tables

    I have attached the three tables referenced in the descriptions. within the Brazing and ScrewMachine tables there are many more fields, but I really only need the part number to be linked and the rest of the fields can be called automatically.
  13. C

    Linking Tables

    I have a table called "FinishedProductT". This table will store a part number for a ready to sell product which I call the Master Part Number. Within this table there are steps to get from raw material to finished product. Some have more steps than others. I have 7 different tables for the...
  14. C

    Linking Tables

    Hi, I need help with some tables. I have a master table that has a part number and steps, and within each step there is a sub part number. I also have a table for each step and within those tables there are the sub part numbers. On the master table in the step field I want to be able to...
  15. C

    LogIn and Tracking LogIn

    I already have a lot of the needed data in the database. I am new to databases, but I am not new to coding. I have imported a lot of data from excel and have completed a lot of the background information. I am stuck on putting it all together the way my management and I want it. The pain need...
  16. C

    LogIn and Tracking LogIn

    the database is far from working. I am going to focus on the functionality on it and come back to the tracking feature at a later date. thank you for the advice. It just seems like so much to do.
  17. C

    linking access with excel

    what about using the OLE Object?
  18. C

    lookup tables

    1. I do not think I can post actual information from the business here. 2. I know what I want the database to do, but I am not sure how to make it do that, or the best way to approach it. Within each department one specific step is performed. Not all parts must go through every department, and...
  19. C

    linking access with excel

    Hi, I am new to this website, as well as Access. I am doing an internship for a company that wants me to create a database for them. Right now everything is done in an excel sheet. There are master part numbers that all have steps with sub-part numbers. Each time a master part in ordered...
  20. C

    lookup tables

    Hi, I am new to this website as well as Access. I am doing an internship for a company that wants me to create a database for them. One of the things they want the database to be able to do is hold all of the orders. The business makes parts with master part numbers that sometimes have...
Back
Top Bottom