Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Hmadyson

    Append Query with 2 Subqueries Runs extremely slow

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

    Access Parameter Popup - Needs to be Removed

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

    Access Parameter Popup - Needs to be Removed

    Yes I did. Other ideas?
  4. Hmadyson

    Access Parameter Popup - Needs to be Removed

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

    My forms are opening behind other open forms

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

    My forms are opening behind other open forms

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

    Forms Shrinking in Strange Ways

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

    My forms are opening behind other open forms

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

    My forms are opening behind other open forms

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

    Forms Shrinking in Strange Ways

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

    My forms are opening behind other open forms

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

    Windows Listing

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

    Search form with multuple fields

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

    Dynaset within a Dynaset

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

    Table Validation Rule with SQL

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

    unable to share database

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

    Table Validation Rule with SQL

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

    Null Values Problem

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

    Dynaset within a Dynaset

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

    Query optimisation help - SELECTs within SELECT?

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

Part and Inventory Search

Back
Top