Search results

  1. M

    VBA for enable contents

    Hi All, Thanks for this, it wouldn't allow me to add a folder as a trusted location, it just says it cannot add it as a trusted location for security reasons. I changed the ActiveXsetting to enable all controls and in Macro Settings I enabled all macros. This has worked but obviously not ideal?
  2. M

    VBA for enable contents

    Hello!! I have a DB that is on a server, when it opens I have to click on enable content every time, I've looked in the trust center settings and none of the changes in here makes a difference. I have an AutoExec file that runs but obviously I get an error as I need to enable content. Is...
  3. M

    Export Query to Excel - But with combobox values not text

    Have emailed it through to you, might want to check junk folder
  4. M

    Export Query to Excel - But with combobox values not text

    DoCmd.SendObject acQuery, "Export", acFormatXLSX, vRecipient, , , vSubject, vMsg, True I export it to an email attachment using the above
  5. M

    Export Query to Excel - But with combobox values not text

    Row Source SELECT [tblDept].[ID], [tblDept].[Department/Charter] FROM tblDept ORDER BY [Department/Charter]; Column Count 2 Column Widths 0cm;2.54cm Bound Column 1
  6. M

    Export Query to Excel - But with combobox values not text

    Should have said also that the DB is split, don't think it should make too much difference though?
  7. M

    Export Query to Excel - But with combobox values not text

    The tbls with the lookup info in are ID Code 1 1.01 dlkjcnsldc 2 1.02 dkcldc Etc. the ID is autonumber There are about 5 fields in the main tbl that all use different tbls for the lookup value
  8. M

    Export Query to Excel - But with combobox values not text

    I did but they're linked to another tbl rather than me entering the lookup value
  9. M

    Export Query to Excel - But with combobox values not text

    Hello All, I have done some VBA to export a query into excel which was easy. Issue is that this is then to be imported into another DB. There are several combo boxes that take data from other tbls, instead of exporting the number it exports the actual text, this owuld be fine except when you...
  10. M

    Control source properties for combo box

    Sorry not all access wizards....trying to do this alongside a day job
  11. M

    Control source properties for combo box

    Each FE user just has the same FE but with differing options on the main form (I don't have seperate log ins etc, for them, just their FE version has a slightly different form to the others). I have the following setup: tblExpenses tblCodes tblExpenses has a lookup field that looks up a...
  12. M

    Control source properties for combo box

    OK. So I've a combo box called Budget Code, this shows a list from tblBudget![Budget Code], what logic would I need to only show budget codes that start "0.*" (text value)?
  13. M

    Control source properties for combo box

    Hi All, I have a combo box that looks up values in a tbl. Is there a way in the combo box control that I can change which values it shows for different FE users? But without having different queries to designate the criteria? I thought I could just use a query and control the combo box with...
  14. M

    Multiple Group Totals

    Awesome, thank you
  15. M

    Multiple Group Totals

    Good Morning!! I have a total qry which returns the following: Budget Code(Group By) SumOfBudget (Sum) 0.01 Management 50000 0.02 Bank Charges 6000 0.03 XXXXXXX 10000 1.01 XXXXXXXXX 20000 1.02 XXXXXXX 30000 2.01 XXXXXXXXX 40000 2.02...
  16. M

    Chart Axis

    This seems like the better option but I cannot seem to get it to work, this is my SQL: SELECT [2022 Monthly Totals].[Budget Month], CDbl([SumOfBudget]) AS Budget, CDbl(Nz([Sum Of Home Currency (USD)],0)) AS Actual FROM [2022 Monthly Totals] LEFT JOIN [tblExpenses Query1] ON [2022 Monthly...
  17. M

    Chart Axis

    Hi All, I've a chart based on a query, the query is all in order but the chart X axis is not, any ideas on how to make this correct? Cheers
  18. M

    Crosstab Type Form??

    Hi Arnelgp, Good idea but the date field in qry2 is a Group of dates from a total query that returns a grouped value of dates in a month...IE 1/1/21 45000 2/1/21 10000 2/2/21 5000 3/3/21 1000 Returns Jan 21 55000 Feb 21 5000 Mar 21 1000 Therefore the left join query does not work as...
Top Bottom