Recent content by User Name

Is there anyway to update the criteria in a query from a form. Say I give the user a combo box to pick a number of different years. I want those yours to be the criteria in a query.

where do I enter this. UPDATE MyTable SET NewCol = 1

I imported a table into access and I want to add a column in that has a value for 1 for every row. Instead of having to go into the table and changing every single one. (400,000) Is there a way of doing it with VBA or a macro? If so how? Thanks.

I need to show the date of the table that the information is coming from on all of my reports. The only thing is, is that when a new table is brought into the database this data has to change to show the new date of the information. I have the dates of the policies which I tried using the max to...

Is there a way that I can manipulate data in pre-existing queries and crosstab queries by allowing the user to pick a variety of years they want the data to come from. Lets say a report is generated from a crosstab query that shows the number of policies there are in relation to the age and sex...

how would I do this if I had crosstab queries running reports?

I just want the user to be able to pick the dates they need ranging from 1971 to 2003, including an option to pick them all. As well I would like them to choose a report. Thats it. I already have the queries and the reports all I need is a quick form or message box that prompts the user to...

will I have to create a form with a user interface to allow the user the show all of the years?

How can I set up a form that asks the user to pick which Report they want to open up and runs it for them?

I can do this for existing queries. Thanks. What can I do for reports that are created from crosstab queries? Can I do the same thing? In the total row what do I classify the years column as?

If I have already set up a query where I have the groupings of information I want but I also on top of this info want to give the user the option to pick which years out of this data they want to put in a report. How can I use the data I already have in the query but only show the years the user...

Does anyone have a copy of a macro that gets the user to enter in a number of years ranging from 1971 to 2003 and gets them to choose a report for the info to go into then opens the report for the user with the wanted years information.

Does anyone have a copy of a macro that gets the user to enter in a number of years ranging from 1971 to 2003 and gets them to choose a report for the info to go into then opens the report for the user with the wanted years information.

yr/yy same thing. Does anyone have a copy of a macro that gets the user to enter in a number of years ranging from 1971 to 2003 and gets them to choose a report for the info to go into then opens the report for the user with the wanted years information.

Can I see the code you used to do this. Also is there any sort of macro that will allow me to sort data by year so I don't have to put the year feild in a query.