Search results

  1. theDBguy

    Solved Pivot Table Summary Count minus Total Count

    Update: I'm at work right now, so I can't show you how, but I finally figured out how to add the calculated column without modifying the data source by using Power Pivot and DAX expressions. Sent from phone...
  2. theDBguy

    Set two column combo box value using bound column value from openargs

    Not sure your level of experience is, but that description is a little vague. The Value property stores the value from the Bound Column of the Row Source. What's displayed is dictated by the first non-hidden column controlled by the values in the Column Widths property. So, if the bound column...
  3. theDBguy

    Set two column combo box value using bound column value from openargs

    Hi. Can you show us the Row Source for your combobox and the string you're sending via OpenArgs? This will help us see the relationship between the two.
  4. theDBguy

    Solved Dynamic Insert statement

    Okay, that's what I thought. Take a look at the ReDim statement and see if that helps.
  5. theDBguy

    Solved Dynamic Insert statement

    Are you getting any error messages?
  6. theDBguy

    Update multiple records in sub form

    Hi. Welcome back! You can certainly automate some repetitive tasks in Access. For example, you can try to use an Update query to edit a bunch of records at the same time.
  7. theDBguy

    Closing Excel from Access VBA

    See if this page helps. Scroll down to the code tag. https://www.access-programmers.co.uk/forums/help/bb-codes/ Edit: Oops, looks like I forgot to send this.
  8. theDBguy

    Solved Pivot Table Summary Count minus Total Count

    I still haven't found a way without using extra columns. Please let us know if you do find a way to get rid of them. Good luck!
  9. theDBguy

    Closing Excel from Access VBA

    Hope you don't mind, I've reformatted your post to use code tags to make it easier to read.
  10. theDBguy

    Closing Excel from Access VBA

    Just in case it helps, have you seen this? https://www.devhut.net/ms-access-vba-export-recordset-to-excel/
  11. theDBguy

    Closing Excel from Access VBA

    What error messages were you getting?
  12. theDBguy

    Variables changing to fields

    Just in case it might be useful, look up TempVars too. I think you can use them directly in Control Sources without using code.
  13. theDBguy

    Hi people

    Hi. Welcome to AWF!
  14. theDBguy

    I need to be able to type in text box and for the list box to show me all similar text. No VBA )-:

    Hi. Welcome to AWF! It would be hard to work with Access without VBA enabled, but I suppose some functionalities are possible using only macros. If you need help with your macros, consider posting a sample db.
  15. theDBguy

    Solved stuck on simple issue

    Have you tried? Status<>"Rejected"
  16. theDBguy

    Mandatory FK values? "You cannot add or change a record because a related record is required in table"

    Hi. Glad to hear you got it sorted out. Good luck with your project.
  17. theDBguy

    Mandatory FK values? "You cannot add or change a record because a related record is required in table"

    I am guessing the error is showing up due to referential integrity is enabled. Just as a test, see if the error goes away if you temporarily turn RI off.
  18. theDBguy

    Solved Pivot Table Summary Count minus Total Count

    Yup! That's another way of doing it. Good luck with your project!
  19. theDBguy

    Hello Everyone

    Hi. Welcome to AWF!
  20. theDBguy

    Correlation between two records of the same table

    Actually, "tags" make more sense in Access than just simply connecting products together. In that case, when you want to list all products with a certain tag, it would be easier to query the tables by simply providing the tags as a criteria.
Top Bottom