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!

Register Log in
  • Congratulations derfloh 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. circles

    Calculate age for year of birth

    I am trying to develop a table that when a person enters the year they were born thier age will be automatically be put into the age field. Any help would be great.
  2. circles

    Input masks?

    I have a form that users enter account numbers into. All accounts start with a leading zero followed by a 7 digit number with no spaces or dashes etc. For example 01189703. Is there any way I can format the account number field so that it automatically have the leading zero shown and all the...
  3. circles

    I have a database that will track i

    I have a database that will track individual progress on certain projects that an individual is assigned. Contained within this database are several fields such as goal, objective, project name, follwup date and the expected completion date. What I am trying to do is build a report that will...
  4. circles

    multiple users on a network drive

    What do I need to do in order to get a database so it can be access and used by multiple users at the same time? Currently the data base I have allows only one user at a time and if someone else trys to gain access an eror message pops up saying that the command cannot be completed due to...
  5. circles

    General query

    Below is an example of a table I have built and it contains customers identified with a number and by name and the year they have been a customer. I am trying to develope a query that will identify who has been a customer for the last three years, two years, etc in each and every year. For...
  6. circles

    tab orders

    How do I set tab orders in word? I have a three column table and I need to set a tab order so that my cursor will go to the first part of my question. This is in a protected document using form fields. 2. Is one individual responsible for risk management at your institution? Yes0 No0 If yes...
  7. circles

    I have several graphs in a database

    thanks for your input. That is what I was dreading
  8. circles

    I have several graphs in a database

    I have several graphs in a database and would like to change the graph descriptions all at once. Is there any way you can change a certain string of codes in Access using a find and replace tool. What I have is %of total dollars incurred and would like to change it to % of Total Loss Dollars...
  9. circles

    Input masks

    Thanks for your help
  10. circles

    Input masks

    I have a form that will allow users to look up customer information by entering an ID number. All customer information is imported into the data base on a monthly basis and the customer ID numbers for some reason come with two leading zeros before the actual ID number. For example customer...
  11. circles

    Exporting graphs

    I have an export graph button that will export a graph into a JPEG image, however when you view the graph after the export part of the graph is missing. Is there someway in VB code to set the parameters of area you want to export. This is the only thing I can think of as to why the legends on...
  12. circles

    Help with importing on Microsoft access

    You may want to try importing into Excell then in when in Excell copy the table and paste into a new spreadsheet using paste special then choose the option values. Save it then import it into Access
  13. circles

    Query to skip certain years

    Here is sample table I have built Policy Year Losses Losses Pd Premium 1234 99 1 $3,000 $2,000 1234 00 0 $0000 $3,000 1234 01 2 $5,000 $4,000 I am trying to build a query that will only total the paid losses and premium in the years that this policyholder had claims then in the end...
  14. circles

    I am running a query off a form. T

    I am running a query off a form. The query counts certain items. I am wanting to enter a number if the field off the form, so the query will only show the count greater than a certain number. Currently I use the criteria of >[form feild. This works off the parameters, but not the form. I am...
  15. circles

    exporting Access graphs

    I have developed a datatbase that will produce graphs of claims and I am wondering is there any possible way to export these graphs so others can view them who do not have access to my database? Any help is greatly appreciated
  16. circles

    report

    I have a form with two drop down fields that allows the user to choose a state then a year. I also have a push button that will run a query based upon the choices the user enters and then results are shown in the datasheet view. What I am trying to do is get the results produced on a report...
  17. circles

    Updates via If statement

    I have a table (tbllightning) that has each state coded as a number. For example Alabama is coded as 1, Alaska as 2,Arizona as 3, and so one. What I am trying to do is use an Iif statement to change the state numeric code to the actual state name so that on the table Alabama will replace the...
  18. circles

    Does anybody have any information o

    Does anybody have any information on how I can display results from a query on a form?
  19. circles

    I have the following spreadsheet

    I have the following spreadsheet Zip loc frame brick Steel 900 2 3 4 5 901 1 2 4 6 902 3 3 3 7 903 2 3 5 6 I am trying to build something that will lookup the numbers in the spreadsheet. For Example if I...
  20. circles

    Security

    I have a database with workgroup security here is the problem. Basically it opens to the main switchboard that has three push buttons to open three forms. One form will open with all proper fields showing the others open but no fields show. I did not have this problem unitl I assigned users...

Part and Inventory Search

Back
Top