Search results

  1. M

    Issue with Clients use of Add/Edit form

    I by no means am a master programmer. I've adapted my original program over the years as issues have developed. The first issue I had years ago was when employees would start to change information on the main form page. That's when I added the Add/Edit button which opens to the specific record...
  2. M

    Issue with Clients use of Add/Edit form

    My issue has only developed as a result of a new person using my existing database program. My other employees understand how the Add/Edit function works, but this person did not; even after having explained the process. I can't seem to find a way to resolve the issue on my own, hence this new...
  3. M

    Property Sheet Issue

    that did it. Thank you. i knew it would be a simple fix! lol
  4. M

    Property Sheet Issue

    In answer to your reply: I read that as you have two separate windows, one for fields and the other for properties? Yes That is correct I have one window, in which it changes depeding on my selection? That is what I used to have and I am trying to find out how to get back to that Have you...
  5. M

    Property Sheet Issue

    I don't understand your reply, Gasman.
  6. M

    Property Sheet Issue

    this will probably be an easy fix, but for the life of me I can't seem to resolve "it". In the design mode of a report or form, the property sheet and add existing field used to stay "attached" to the report or form. However, now both the property sheet and add existing fields boxes act as pop...
  7. M

    Pop Up Form Issues

    When I open the [AIAContact]form it is "filtered" by the number of Contacts at the firm in question. However, the form is filtered when I open it in standard form or pop up form, so I'm not sure why that would make a difference. I can search the [AIAContact] form in standard mode and...
  8. M

    Pop Up Form Issues

    My database has a main contact form [Architects] with a Contact button, which, when clicked on opens up an [AIAContact] form. I can search the [AIAContact] form when it opens up in “standard” mode, for example the contact name, but I can’t search it when it opens in Pop Up mode. Any ideas...
  9. M

    can't change anything in query property sheet

    I see that now, just didn't understand what you were saying earlier! thx for your help
  10. M

    can't change anything in query property sheet

    I fixed it. Apparently, I moved the 2nd column in the form property sheet too far to the right which made it appear as if everything disappeared.
  11. M

    can't change anything in query property sheet

    As I have investigated this issue further, it appears I can't change the properties on any query or a form. I have attached the property sheet for the form here. This leads me to believe, I turned something "off" somehow and I don't know how I did it or how to fix it.
  12. M

    can't change anything in query property sheet

    database is too large
  13. M

    can't change anything in query property sheet

    I tried your suggestion and it didn't change anything. The issue is I can't click in an of the fields under the "General" Tab and make a change in the Description/Format/Input Mask/Caption property fields.
  14. M

    can't change anything in query property sheet

    I must have clicked on something to cause this but Suddenly, I can't change the property sheet values in any of my queries. As you can see from attached (.jpg), all the fields under "General" tab are empty, and yet, this particular column has the title "TSDQ-1" as it's column header. I want to...
  15. M

    query stays open when form is closed

    Bingo! for some reason, under the Event tab/On Current there was an event process advising form to open up the offending query! I am not sure how it go there, but once I deleted it, I could open the form without the query opening. Same old story, garbage in, garbage out! lol Thank you very...
  16. M

    query stays open when form is closed

    I have a button on the [frm_ASI] which runs the [qryASI-Quote-FU] when clicked. I copied and renamed [frm_ASI2], deleted the button which runs the [qryASI-Quote-FU], debugged the new form. I opened up [frm_ASI2] and the query still opened up with the form
  17. M

    query stays open when form is closed

    Yes, both the form and query opened up.
  18. M

    query stays open when form is closed

    Aha! thx Ran DoCmd.OpenForm "frm_ASI" and both the form and query opened up. Again, just for comparison I entered DoCmd.OpenForm "frm_Pawling" and only the Pawling form opened up
  19. M

    query stays open when form is closed

    I have the database open per your request, and other than the ribbon, nothing but white space is staring back at me. sorry to be such a dunce, but where do I find the "Immediate Window" to type in the code?
  20. M

    query stays open when form is closed

    thank you for the reply There isn't any underlying code for the form Here is the code behind the ASI button: Private Sub open_frm_ASI_2_Click() Dim stDocName As String Dim stLinkCriteria As String stDocName = "frm_ASI" stLinkCriteria = "[ID]=" & Me![ID] DoCmd.OpenForm...
Top Bottom