Recent content by Hmadyson

Hi helpful people, I have been trying to do research on my own, but it is not helping. What I want to do: I have 2 tables with multiple records per person. For every record in table 1, I want to know what the previous date from table 2 is and also what the next date in table 2 is. I have...

For future knowledge, this popup was occurring because there was conditional formatting in the form which was converted into a report. Next time I will know to look there. Thanks.

Yes I did. Other ideas?

Hi, I have an access report which I created from an access form. I did a Save as on the form to create a report. Without making any changes to the report, when I open it, I get a parameter popup asking for a field called txtPhoneHome (although the name probably doesn't matter, but it may be a...

For anyone else looking for a solution to this, I think that this was occuring because Echo was off when I opened the form, then I would close another form, and a different one would be on top when the Echo went off. I was able to fix this by using Forms(XYZ).Setfocus after the close form and...

Thank you so much ProgramError, but I have tried all of your suggestions. Can someone else please chime in with some help?

I do not want the forms maximized, since there are many forms open at once that people will be going between. I just want the form to shrink from the bottom instead of the top of the detail, since it is hard to get back. I am thinking that this may have something to do with the first field on...

yes, clicking some sort of button launches the code that opens another form. (docmd.openform)

How do I make sure that the newly open form has the focus? I need to keep them all open in this environment.

I have a form that uses a header and detail section. It is pretty big and sometimes needs to shrink to fit in the area. Strangely enough it moves the top of the detail section out of view instead of shrinking from the bottom. How can I get this to stop? I am using Access XP.

I am using Access XP. I have a fairly complex application. I am using normal, non modal forms. Sometimes when a form opens, it is opening behind the active form. The following code is used to launch a form Note that my forms are Popup=No, Modal=No DoCmd.OpenForm "FormName", acNormal, , "ID...

I would like to create a listing of all open forms in Access in my own commandbar. I saw thread707-1157070, but it doesn't seem to work for me. I am trying to add control 830 which should list the open windows, but it will not let me add it. I also wrote some code that adds all of the open...

I see that you are using a filter in the end. One thing that you can do to speed it up is to have the form have no recordsource at all, but then when they choose the filters, you set the recordsource to "Select * from YourTable Where " & strWhere. This would be faster than the filters, because...

I think that updating data a field at a time, is a lot faster than updating data a record at a time. Maybe that is not what you are saying that you are doing, but that is what is sounds like to me. Good luck with your project. Please let me know if I can provide more assistance.

Les, thank you for taking my quote out of context. In fact I started my posting by saying that she should not do what she is trying to due because of normalization. I think that there are some cases where normalization slows down your database, that is all. And I hope that wvandenberg has...