Recent content by Umpire

  1. U

    Search results in no records. How to get back to my Switchboard when this happens?

    OK, As I learn more about VBA I think I understand what you saying. Let me see if I have this "flow" correct: Switchboard selection opens my form; I have a OnOpen event set to run my VBA code My Code opens a message box asking what I am searching for; Then I transfer the message box...
  2. U

    Is this a good start to learning VBA?

    Thanks. I do have a database that I am working on. It is doing a few things I want to change and don't know how. When I asked here, the answers were in VBA. I found a workaround for now but I need to understand VBA to figure out the "right" way to do things.
  3. U

    Is this a good start to learning VBA?

    I found a PDF of the book "Access VBA Programing for Dummies" by Alan Simpson, on line. I was wondering if that is a good place to start to learn VBA in general and VBA for Access in particular. Thoughts?
  4. U

    Search results in no records. How to get back to my Switchboard when this happens?

    One additional question: While looking online for VBA courses, most (all?) refer to Excel VBA. Does that matter? or is Excel VBA applicable only to Excel and the information will not translate to Access?
  5. U

    Search results in no records. How to get back to my Switchboard when this happens?

    To all, I found a workaround. If I allow editing of the form (in form properties) it will show a blank form including the command button to return to the menu. For now, this will allow me to have a usable set up. As I gain experience and understanding of VBA and Access, I will implement the...
  6. U

    Search results in no records. How to get back to my Switchboard when this happens?

    OK progress is being made. Using the code builder for the event "OpenForm" I have ended up with this: NumRec = DCount("*", "LocationSearchResults", "Source") If NumRec > 0 Then DoCmd.OpenForm "LocationSearchResults" Else MsgBox "There are no records to view."...
  7. U

    Search results in no records. How to get back to my Switchboard when this happens?

    Thank you for your help. However I am using a form not a report. I do not see a "No Data" event for a form.
  8. U

    Search results in no records. How to get back to my Switchboard when this happens?

    I have a database that is a record of equipment and software tested in my section. I have a switchboard that opens a Split Form that has fields from multiple tables that list things like Date Tested, Who tested it, What was the result etc. The lower half of the form is a Datasheet View showing...
  9. U

    Help For dummies

    YES!!!! I don't mind the code as long as I know what to change AND how (where) to plug it into Access.
  10. U

    Help For dummies

    Where can I find help that does not give answers in programing languages? I posted about a problem with a search returning no records and no way to get back to my switchboard. I got a quick response (Thanks) but it was a page full of VBA code. I asked for clarification on what to change to fit...
  11. U

    Search results in no records. How to get back to my Switchboard when this happens?

    Thanks for responding. I am so knowledge challenged in VB, that I do not even know what to change in your code to match my form. Can you point out what I need to change? Also just to verify, I am using a form and this code will allow the form to work like it does now if the searched data...
  12. U

    Search results in no records. How to get back to my Switchboard when this happens?

    I have a database that contains equipment serial numbers. I have a switchboard set up to run the database. One option is to search by serial number. When I enter an existing number, everything works fine. I have a button on the form to return to the switchboard. The problem is if I enter a...
  13. U

    New to this group and Access

    I will be sharing some of these. Thank you.
  14. U

    New to this group and Access

    Trying to take advantage of the COVID-19 shutdown and convert a 5,000+ line Excel test result log to a database. Been a challenge to say the least. I have a few points I am stuck on and look forward to the groups help.
Top Bottom