Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations sizbut on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. scsuflyboy

    Creating an ID #

    I have a table (and forms) to track lease information. One of the fields is labeld TENANT. I want to be able to create a unique ID for each lease file I create with the following format.. 1st three letters of the TENANT name, followed by a 3 digit number (i.e, Tradewinds Contracting would have...
  2. scsuflyboy

    MDE file

    All of a sudden my database will not let me create an MDE file. Access hangs forever before I manually shut it down. I have modified the database but can't find the problem. Does anyone have any ideas as to why I can't create the MDE file now? BTW, I am in 2002-2003 format.
  3. scsuflyboy

    Help Please....

    Here's what I have and what I want to do: I have a form called "Daily Deposit Info". The form has individual entries for various fees, such as Deposit Info, Prox ID Fee, Mag ID Fee and a few other fee fields. I want to: 1.) On the form I would like to have a calculated total for that...
  4. scsuflyboy

    Calculated Text Boxes

    I have a form with several entries for varying fees, such as Prox ID Fee, Mag ID Fee, Gate Card Fee, etc). Each have their own box for entry. I want to add a calculated text box that will add all these fields together. However, when I have did this it seems to be adding the value in ALL...
  5. scsuflyboy

    Calculation Queries

    Ok, guess I haven't been clear enough. Here's what I have done: 1. I have a table titled "Daily Deposit Info" Table contains fields such as Mag ID Fee, Prox ID Fee, Deposit Amount, etc..plus other fields such as Date and Name of Person paying the fees. 2. I have a Form...
  6. scsuflyboy

    Calculation Queries

    Let me explain further. The form displays the contents of the table. For some reason I can't display the results of the query in the form because it is based on the table that the form is based on. Am I making this clear? i hope so.
  7. scsuflyboy

    Calculation Queries

    Ok, that's what I have attempted to do: I have the table with all of the input fees. I created a query based on that table and I get the sum values I am looking for. Here's my problem: On my form I want to add a field that shows the Total fees (from the query) but am having problems...
  8. scsuflyboy

    Calculation Queries

    Could you expand on that for me please..I am not an expert at programming in access
  9. scsuflyboy

    Calculation Queries

    Help Please..I'm about to pull my hair out. I have a table, called Daily Deposit Info. The table has fields for the following: Name Date Deposit Amount ID # Gate Card # Prox ID Fee Mag ID Fee Gate Card Fee Parking Permit Fee and other "Fee" fields. Here's what I am trying to do: I have the...

Part and Inventory Search

Back
Top