Search results

Harry, If you could give me the code I would be thrilled. I am using the form in a report which is based on a query. The query will be using values from the combo box. Between forms!whateverName!combobox [StartDate] and forms!whateverName!combobox [EndDate]. For example, if I choose 1st...

Hi, Thank you for those who responded but I am still having a problem. basically there are three values in my combo box that I want to be able to use. The first one is Quarter, the second is start date and the third is end date. I can't figure out how to bound to all three values. For...

Can you help me with the thread listed below. Thanks. Eva

Hi Pat, Your suggestion won't work for me because I am using various time fiscal time periods. I basically want to have different periods in a table for them to chose from. Thanks, Eva

Yes to all three questions. When I run the report, it will open up a form on which the combo box is used. combo box has a field for Quarter and the second has a field for Between [the first Date] and [The second Date]. The query in the report runs off the field in the combo box. Thanks, Eva

I am trying to do a query that would time periods from a combo box but I can't get this to work. I have a table for quarters. With Quarter 1 set between #1/1/01# and #3/31/01#. I want the user to be able to chose 1st quarter from a combo box and for the report to query during those dates...

I was able to do the 13 month by employee by doing a subreport. still wondering if I could have done it another way.

Is it possible to have a report showing the last 13 months but only summing the last 12 months. I was able to do it with a subreport but was wondering if there was another way since I also have to do it by employee. Thanks, Eva

Thank you so much, it worked. Eva

Can anyone tell me how to manipulate dates so that if November, 1 2001 is entered I can make a txtfield November, 1 2000. I am making a form that will summarize data for a period of time but I also need to be able to automatically query data for the same period the previous year. One thought I...

I need code to automatically print a report after it is open. Can anyone help. In other words after clicking on a radio button for a person, I want to open the report, print it and then close it. Thanks, Eva

I just came accross this at http://www.studenthelp.f2s.com/access3.htm Forcing a weekday Limiting the type of data you enter doesn't always require a complex event procedure. Sometimes the Validation Rule property can limit the type of data you enter. For instance, if you want a control to...

Thanks, I just bought Beginning Access 97 VBA. I will let you know how I will like it. even though I had programming classes I think it is good to restart with the basics and I like the fact that it has code. I also have available to me in my office the Access 97 Developer's Handbook. Has...

Thank you in advance for your suggestions Eva

Hi Rich, I would like that code for conditional formatting too. I am still having trouble. I tried everybody's suggestions. I also have Microsoft 97 so I don't have the conditional format as a property. Thanks, Eva

Thanks. I did not notice your post when I posted my question. I hope I will get this to work now. Again many thanks, Eva

Why is this code not working. The program accepts the code but the text is not coming out bold. Thanks, Eva If [Text357] > [Text406] Then Me![Text406].FontWeight = ExtraBold Else Me![Text406].FontWeight = Normal End If

the show hidden object is checked. But I still can find the macros.I know they are somewhere because if I copy the report into another blank database it looks for the macro. I also checked the modules and the macros are not there. Thanks, Eva

Hi, My precessor has written a bunch of macros but they do not show up anywhere. The reason why I know they are hidden is because if I try to copy a report into a new database it looks for the macro. Any suggestions on finding them? Thanks, Eva

Hi, I just compacted a copy of my database and it went from 35,000,000 bytes to 10,000,000 bytes. Just want to make sure that it is safe. Eva