Search results for query: *

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.

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...

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...

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...

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...

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...

thanks for your input. That is what I was dreading

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...

Thanks for your help

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...

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...

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

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...

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...

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

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...

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...

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

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...

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...