Search results

I have a form that I created in order to update a table. I had a combo box that would search for the name of the things in the table and then I could update the information for that particular thing. Well now I have a new problem sometimes the thing that I would like to look at is not in the...

I have a combo box that has a range of years in it. I would like to be able to select more than one year at a time. Is there anyway that I can accomplish this.

Is there anyway to change the criteria in a field without going into design view I bascially need to be able to type in a particular item in a certain field in a query and it return all the results for that one. The database has over 160000 records and when I try using a form it takes forever.

I have a button in a form that runs a macro. I need to somehow password protect that button. How could I go about doing that.

I currently have a query that lists the date of something. I just need to have the year in which it is done for a task so I need to somehow find a way to write a function that will just show the year instead of the entire date. Any ideas.

Im trying to graph the costs on a bar graph within certain ranges. For instance one range is $0 to $999 another would be $300 to $399. They are set up as strings. Well the problem is on the x axis of my graph it shows the ranges which are cost per mile in the order of $0 to $999,then $1000 to...

I am trying to create ranges in data in order to create a graph. I have the following IIf statement that access says is too complex and also Im getting an error saying that it is too long to edit so does anyone have any ideas how to do this with out these problems. I need to get to $25000...

I need to be able to create graphs in access of the standard deviation and mean of a cost of something. I currently have a query that is being filtered by a form and I would like the graph to take the form of a normal distribution. Ie average money would be at the top of the curve and then it...

Is there anyway in a query or a form to set the amount of decimal places on a number or change it to currency. In one query im dividing a price by a mileage and I get a really long string of number and I need to make it just be two decimals. Any ideas.

Create Chart to show the standard deviation of filtered results graphically I have a subform that has filtered(by the main form) information from a query. The information that is displayed in subform some of the columns I would like to take the average, median, standard deviation. So how do I...

I need to have about 4 or 5 combo boxes in the same form that will when I make a selection from one it will filter itself until I am left with just what I need in a subform. I also need it to be able to select any one of the boxes anytime.

I need to be able to use a query to be the basis of a form. I need to make a form that will be selectible when I choose for instance name and area it will just show me that particular one but when I choose area and company it will show me all the companies business in that specific area. There...

I have some problems with a combo box when I hit enter once everything is fine and it displays the info that it attached to that number but when I go and click on the a number and accidentally hit enter twice it will go to the record after the one I typed in is their any command I can turn on or...

I created a form in order to update the records in a table with new records. One of the fields in a record id field and the table that it is set up to write too has over 9000 records already. I need to start with the next number and then auto count as new records are inserted. How would I be...

Is there anyway to run a report every month and then have it be archived with that same data even if it changes from month to month.

Is there any way to possibly to run a macro at the same time each month. I basically need to set up one Macro to run every month say on the fifth or something. Any help would be appreciated.

I need to be able to send a report via email to about 12 people. I need for the report to automatically be generated on the fifth of each month and mailed out. How would I be able to to do this. I just need it to take a Report that I have already created in Access and either email as an...

hello I have a database that keeps track of things that the mileage of changes on a monthly basis each month the mileages are updated unsually about 20 to 30 a month have significant differeneces in mileage. So what I have done to keep track of it and so that the information can be kept...

I need to make a form into a user interface and I have no clue how to do that. I dont really know very much about coding or anything like that does anyone know of any place with examples on how to make a from into a user interface that will link into reports and forms in my database. If anyone...

I have a query that had a thing some information and the person responcible for it. kind of like this 12341201 Sam 14525166 Ian 15648463 Ian 14584853 Bob 56646466 Sam 89414672 Bob 54668469 Bob Well what I need to be able to do is make a drop down box with each name in it and...