Search results for query: *

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...

You automatically open the database exclusive if you start working in design mode on forms, reports, or modules (not sure about macros). The best way to share a front end is to give each person their own copy and find a way to have it look for new versions when the person opens it. Please let...

By implementing this rule you would be having duplicate data in your database, since this information is being held in 2 tables. So if you are worried about normalization of data, this is a no no. I do not necessarily believe in normalization of data, but Access does not allow you to have...

What I would do is create 2 queries for your report. The first one would only grab records from T Removed that fall into your date range. You can ignore the null, because you do not want any to have null in that table. From this query, you can also create an aggregate query that will give you...

What I think that you are asking is how to put together a query that uses lookups to translate different values? Please let me know if this is not the case. How I would do it, is to create a table with all of the lookup translations. For instance my table called tblLookup will have columns...

Yes, if a bunch of the views that you are using are actually just views on the same table, you will probably be better off referring to the underlying table once instead of to all of the views. I do not know much about MS Query, but I know that many people use MS Access to get at SQL Server...