Search results

  1. M

    Delete All But...

    Hello Access Braintrust, I have a table [Project Costs] which will be regularly updated with the most current information from our accounting files. I have included a Report Date with each entry so that I can tell what is the most up-to-date info. I have been able to create a query that will...
  2. M

    Solved SetValue (last entry)

    Hello Again, This group has been super helpful in the past here's hoping for another! I have a form that is used to enter new data - often times there is one piece of data (ProjectID) that is entered into the form 3-6 times in a row before having to enter a different ProjectID. Is there a way...
  3. M

    Solved Conditional Formatting on Split Form

    Hello again Access Wizards, I created some conditional formatting so that my users would be able to see at a glance when some of their project metrics were out of balance or almost depleated. I used the Conditional Formatting tool from the ribbon (seen below) to set it up but it does not work...
  4. M

    Solved Enter Parameter Value - Help!

    Hello All, I am trying to filter a split form using a combobox and a macro to apply the filter. When I first wrote the macro and applied and tested it - the filter worked great returning exactly what I asked each time. I saved the db and made a cup of tea and when I came back to my desk I got a...
  5. M

    Search/Filter on more than one list/combo box

    Hello Access Masters, I've been using access for almost a month now with some success with the basics but still have much I do not know and have been learning by scouring google and this forum. I have not been able to find an answer to this challenge yet and I'm hoping you all can help. I am...
  6. M

    Union Query Returning Error

    Hello All, I am working on a query that is using a UNION to join two other queries. I have another successful UNION based query in this db which returns no errors and looks almost identical to this query except for the SELECTed fields. I am receiving the following error when I run it through a...
  7. M

    New Member - still learning

    Hello Everyone, I recently started with a new company in a new field and have found myself tossed into the deep end of the MS Access "pool". I have enjoyed learning Access and SQL (and a bit of VBA) on the fly by finding solutions on this forum and across the web. I'm not sure how much I may...
Back
Top Bottom