Search results

Sorry if some of my suggestions sound stupid. I know that sometimes when I am faced with a problem I miss some of the obvious things I could do. Have you tried compact and repair database? Have you compared settings for access for the problem computer with other computers? Is the same...

I have set-up a nice, using forms and command buttons, a nice menu for my database. I have attempted to added to this menu a command button that would allow me to close the current database and open another access database. I tried a few things with macros and such but obviously didn't...

Instead of doing a loop consider using an update query to change the "yes/no" field to what you want. As you indicate the trick is to idenfity the specific records to be updated. If I understand correctly what you are trying to do is you have certain records in your database that are set to...

Awesome. All I had to do is change my query parameters statemet (which the reports are based on to: Between Forms!FormName![Start Date] and Forms!FormName![End Date] And it worked. Thanks Fornatian. You have now openned the door for me to create some nice easy to use menus (using forms) so...

Have you tried to do something with an iff statement. You could possibily update your records by doing something like iff([Field Name]=no,yes,) Sorry I can't offer a more complete answer, but it might point you in the right direction of something you haven't tried yet. Good luck. Peter

I have created several reports that use the same two paramters [Start Date] and [End Date]. I am in the process of creating a form from which these reports can be launched and the paramters only have to entered once. I set-up to unbound boxes and named them Start Date and End Date, enter the...

Thanks Rich@ITTC. Worked like a charm. I very much appreciate it. I have been trying to figure out this problem for almost a week now. I had tried differen versions of "if" statmenets but couldn't get them to work. Now I know why. Thanks again.

Thanks Rich@ITTC. Worked like a charm. I very much appreciate it. I have been trying to figure out this problem for almost a week now. I had tried differen versions of "if" statmenets but couldn't get them to work. Now I know why. Thanks again.

Hi Mark. Trying playing with where you put the calculaiton. Which groups header or footer you put the calculation into will determine which values are bieng used. Trying putting your Total and Average calculation in the report footer. Hope this points you in the right direction.

I am currently tyring to develop what has turned out to be a very difficult report. One little problem I am having is as follows: I have one field which is defined through a combo box which gets its values from a separate table (examble A = assets, L = Liabilites, R= Revenue). Of course the...

First of all, I would like to thank everyone in all the groups for the great help they have been to me. I have another problem I hope people can help me with. I have a report that is created using a query which has data parameters giving me data between a start date and an end date. The...

Thanks Richie, that is exactly what I have been looking for.

It is in the page footer.

I have been trying to put in into the control source for the file. Is this wrong?

I have tried to change the query field to be formated as a general number field. When I add my sum function, all I get is an #error. Any ideas?

I am making a report from a query. The query has been programed to count data based on certain categories. ( Based on Category, count the number of reports that fall into that category) In my report, I have listed all the categories and the counted number as in the query. However, I would...

Thanks. This is exactly what I have been looking for. Have a great day!

It sounds like you need to be using sub-forms inside of a main form. The sub-form would contain your Film Table and the main form would contain the customer table data, the two would be linked some how, such that when you select a certain customer, the sub-form displayes the film data for that...

I have two forms set-up to enter data to my database. Currently, when I open them, the form displays record 1 and you have use a command button to add a new form. Is is possible to program my form so that it does not display record 1, but goes right to a blank form. (I would prefer the data...

My table is setup like this Issue Number Category 1 Category 2 Issue Detal Category 1 & 2 fields are assigned standard codes/categories such as AR, AP, INV etc... to classify each each. Two categories are necessary because some issues could relate to two different categories. I have created a...