Recent content by TheSafetyGuy86

  1. T

    Tabs

    Alright Pbaldy! Thanks for the heads up. I figured out how to make it work and it is doing exactly what I want it to do. Thanks for your assistance!
  2. T

    Tabs

    Thanks, I will try it.
  3. T

    Tabs

    Pbaldy, Thanks, does that mean that I can set the visibility property to, lets say, a yes or no field?
  4. T

    Tabs

    Good Day! I have been asked to make a database for tracking employee data. In this database, the manager wants to be able to select what tabs (subforms) the employee can fill out. I was thinking of using a form and creating a tab system inside the form that allows the employee to click...
  5. T

    Linking

    Good Day, Alright, I know that this may have been answered 1000+ times, but I am not really able to take something from another answer and apply it to this particular instance, I have tried. I am building a database to keep track of facility inspections. I have done the best I could to...
  6. T

    Cost and DLookUp

    Alright... nevermind. I was going about this way too complicated... I guess that's what I get for sitting here working on it for about 4 hours... I figured it out and appreciate your looking over the initial question and reply.Have a great day, sorry for the waste of time.
  7. T

    Cost and DLookUp

    Sure, I will do my best here. Alright, I have 2 tables. One is a list of show types with a base cost per show. This is built as follows: Table Name: ShowList ID Show Type Cost 1 Birthday $100 2 Wedding $200 3 Stage $300...
  8. T

    Cost and DLookUp

    Good day! I have a table that holds information for a type of show and the base cost of the show. I am trying to make a query that gathers information for all the shows in the table and uses the Dlookup function to identify the base cost of that show. This will in turn be used in the same...
  9. T

    Import button

    All, Good day! i am trying to add an import command button to a form so that personnel not familiar with Access can simply push the button and then select the file to import. I want it to import information to a specific table by replacing all records in the current table with the import...
  10. T

    Number Jumble

    Good day access forums! I have a minor issue here. I have a set of tables. One has a set of 6 numbers, each number being in its own field, and a field with the date that those numbers were generated. I have another table that has over 500 rows of dates and numbers in it, with dates that are...
  11. T

    Log In Form

    It worked! Thanks again for your help!
  12. T

    Log In Form

    It's not working and I am sorry about the code thing. First time I have ever pasted code. Its telling me that there is a missing syntax error and the debug highlights the line with the final msgbox, but I have no clue what is missing from it.
  13. T

    Log In Form

    This is what I used. In the table that me.usernametxt is referencing, there is also a field that has the users first name. I am trying to reference the users name in order to make it a little more friendly. Private Sub LogIn_Click() Dim tmpPass As String If Len(Me.usernametxt &...
  14. T

    Log In Form

    Alright, so the above worked great and is doing exactly what I want, but now I am trying to work out a minor thing in relations to the msg box. Is it possible to have the final message box, the one that welcomes them to the database, populate the name of the user? if so what code do I need to...
  15. T

    Log In Form

    pr2-eugin, Great! Thanks. That was much simpler than I was going about it. I was about to start using the docmd.findrecord and then go about writing the code above in a different variant. In other words, having it validate against something else on the form and not having it look up...
Top Bottom