Search results

  1. F

    Trying to populate text box

    I understand now. Thank you for your explanation.
  2. F

    Trying to populate text box

    The data we obtained is available to the public to download. Not too fearful of being called a insurrectionist as I was far from DC and looked on aghast at what was happening. Thanks for the url. I'll investigate it.
  3. F

    Trying to populate text box

    That is almost exactly what we wanted to do. Don't believe I have used anything other than the regular query but am eager to try the union and aggregate queries to see what they do. Thanks again for this suggestion.
  4. F

    Trying to populate text box

    You are correct in that there is a column for each year's election. The data we have is from Pennsylvania's web site. There is a record for each voter ID with no name attached. So each voters id has columns for many different years of voting. Will check the dlookup & dcount functions to...
  5. F

    Trying to populate text box

    My friend and I are trying to analyze some data from election returns in a state. What we want to know is the party of people in the state as of different years. We are checking to see if the party affiliation is the same over many years. Then if the party is the same for perhaps 3 of 5 (this...
  6. F

    Trying to populate text box

    Wow, did not expect a reply so quickly. Thanks. Do not know what you mean by "pull the data"
  7. F

    Trying to populate text box

    I have a form I am using just to learn some VBA. Is there a way to populate a textbox (properly named) on a form with the result of some VBA code that has performed a calculation. What I was looking for was something like Forms![Formtest].[textboxname] = c I know this is not too...
  8. F

    Lost the "File" menu while working in the Code window

    I changed the resolution of my monitors to try to match their resolution. In the process I tried the Ctrl Alt Right and then when it didn't seem to work, I changed the resolution of my primary monitor back to its higher original resolution. When I did, I saw the errant menu ribbon floating...
  9. F

    Lost the "File" menu while working in the Code window

    I am not using a tablet, in fact its on off button is grayed out in the windows sidebar. I use a desktop with 2 monitors. This problem has never happened before and it is surely strange.
  10. F

    Lost the "File" menu while working in the Code window

    Just tried Ctrl+Alt + Right and my desktop computer did not respond at all. Tried it with the VBA window in each monitor one at a time and nothing.
  11. F

    Lost the "File" menu while working in the Code window

    2 Wow, that never crossed my mind. Why??
  12. F

    Lost the "File" menu while working in the Code window

    Did the reset and it did nothing. As I do not have the actual "File" menu to reset that is not unexpected.
  13. F

    Lost the "File" menu while working in the Code window

    Yes that is true, but I NEED it in the code window while I was there.
  14. F

    Lost the "File" menu while working in the Code window

    I saw that and was hesitant about clicking on it. Ill try it. Can't be worse than what I have now I guess.
  15. F

    Lost the "File" menu while working in the Code window

    I just did a screenshot of the code window WITHOUT the file menu ribbon. There used to be 3 ribbons and now there are only two.
  16. F

    Lost the "File" menu while working in the Code window

    While going over some code in the VBA for Applications Window I noticed that the File menu is missing. How do I turn the "File Edit View Insert Debug Run Tools Addins Debug Help" Ribbon back on. Thanks for any help. I am using Access 2016.
  17. F

    Red Run Icon does not function when using "Action Query" creation

    That i That is correct. It was the Macro settings in the Options section.
  18. F

    Red Run Icon does not function when using "Action Query" creation

    That was it? Everything is back working correctly? Thanks for your help.
  19. F

    Red Run Icon does not function when using "Action Query" creation

    They are set to disable all macros with no notifications. What should they be set at?
  20. F

    Red Run Icon does not function when using "Action Query" creation

    When I tried the DoCmdSetWarnings in the immediate window, it says the Macros have been disabled. Perhaps this is the problem. How do I enable the macros? From within the Options setting?
Top Bottom