User Profile

Collapse

Profile Sidebar

Collapse
hbaf208
hbaf208
Last Activity: Dec 14 '10, 07:13 PM
Joined: May 13 '10
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • hbaf208
    replied to Form won't open
    in Access
    I've attached the database. One other thing that I noticed before this happened, my c drive was full and I was unable to save another word doc. I now have plenty of space on my hard drive but I'm wondering if this caused the issue....
    See more | Go to post

      Leave a comment:

    • hbaf208
      replied to Form won't open
      in Access
      I tried debugging. I also tried erasing all of the code in the form module. The form will still not open. I exported the entire database to another database but this form doesn't export and I cannot copy it.

      Any other suggestions?

      Thanks, Jason
      See more | Go to post

        Leave a comment:

      • hbaf208
        started a topic Form won't open
        in Access

        Form won't open

        I have a form that I am unable to open. I had the form set to open on startup. It now will not open, even in design mode. I tried creating a form with a command button to open the form and it gives me an error code, "You canceled the previous operation." I tried copying the form and exporting the form. Neither work. All of the code for the form is still in the module. Any suggestions on how I open the form?

        Thanks,...
        See more | Go to post
        • hbaf208
          replied to Using IIF in Query Criteria based on Option Group
          in Access
          Worked very well after I added the other criteria to the SQL statement that I had in the query builder. If someone else uses this code, they will want to remove the ) in Case 3 after [CallReport].[Date].

          I very much appreciate the assistance.

          Thanks,
          Jason
          See more | Go to post

            Leave a comment:

          • hbaf208
            replied to How to Requery combobox in subform based on unbound parent form listbox
            in Access
            Thanks everyone. The On Current on the subform worked great. I had previously tried the afterupdate on the listbox on the mainform but I couldn't get it to work.
            See more | Go to post

              Leave a comment:

            • hbaf208
              started a topic Using IIF in Query Criteria based on Option Group
              in Access

              Using IIF in Query Criteria based on Option Group

              I have an option group (TimeFrameOptio n) with three options: All, Last 6 months, and Last 12 Months. When an option is selected, I want to query dates in a listbox (CallReport) to display all dates (I used Date() - 9999999999 days for all), dates within the last six months, or dates within the last year.

              I placed this formula in the criteria in the SQL query builder for the listbox.

              IIf([timeframeoption]=1,[CallReport].[Date]...
              See more | Go to post
              • hbaf208
                started a topic How to Requery combobox in subform based on unbound parent form listbox
                in Access

                How to Requery combobox in subform based on unbound parent form listbox

                I have a combobox on a subform that is based on an SQL that uses a listbox on the unbound parent form as the criteria. When the form is first loaded, it works perfectly, limiting the dropdowns to only those associated with the listbox. However, when I update the listbox, I cannot get the combobox to requery. I've tried requery AfterUpdate on the listbox control, AfterUpdate on several subform controls, as well as trying to requery the combobox...
                See more | Go to post
                No activity results to display
                Show More
                Working...