Search:

Type: Posts; User: Micron; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.08 seconds.

  1. Replies
    1
    Views
    460

    Re: Form for Checklist

    The main form is a check list? Then what is the subform for?
    If you need to add a product, you have to add a field to your table? That indicates lack of normalization, which might be contributing to...
  2. Re: VBA or Expression Builder for using toggle button to open a page

    An option group typically contains option buttons aka radio buttons, and will allow you to deal with one choice out of many as you seem to want to do. Calling them toggle buttons may confuse because...
  3. Replies
    2
    Views
    596

    Re: Using a Navigation Form as a subform?

    I have never tried to replicate vertical tabs, but would think that command buttons would be the way to go. If you used the button option for horizontal tabs, you'd have some consistency in...
  4. Re: Use Access Database to auto create Excel template

    You want a database to copy a workbook template as a new workbook or new sheet in an existing workbook, based on a table of names? Then you are going to continue using all these sheets/books to...
  5. Re: Excel Userform to Export to Access data base

    cross posted
    https://www.accessforums.net/showthread.php?t=77825
  6. Replies
    8
    Views
    1,280

    Re: Access query to loop through date ranges

    Pretty sure you cannot use WHERE in a Totals query (HAVING takes the place of WHERE). Your left join will also cause all records from 1 table (subject to any criteria) and any records from the other...
  7. Replies
    8
    Views
    1,280

    Re: Access query to loop through date ranges

    Not sure if I am or not. Haven't convinced myself yet that what I wrote is any different fromIf you read my English version of the query task, aren't those two statements saying the same thing except...
  8. Replies
    11
    Views
    967

    Re: disable check box based on other checkbox

    Absolutely agree that option buttons would be more elegant. However, if they must be check boxes for some reason (perhaps they are bound which would suggest that there are 3 table fields instead of...
  9. Replies
    8
    Views
    1,280

    Re: Access query to loop through date ranges

    Seems to me that a subquery is what I'd try before writing a bunch of code. In English:
    Show me Table2.Area where Table1.Date is greater than Table2.Start and less than Table2.End (not that I would...
  10. Re: Import/append Excel workbook with multiple sheets using VBA.

    Wouldn't that be
    DoCmd.TransferSpreadsheet acImport, , "MyTableName", "myfile.xlsx", True, arr(i)

    This looks more like an Excel question but it's posted in the Access forum. Thus I wonder if...
  11. Replies
    2
    Views
    732

    Re: Back End Only Opening Read Only

    Likely one or more users does not have the correct permissions on the be folder. Everyone must have full permissions otherwise they cannot delete or edit the lock file. If they cannot delete, a user...
  12. Replies
    4
    Views
    881

    Re: Failing to import data to tables

    to troubleshoot this yourself you need to verify that every sql statement you have in code is valid in its entirety. Thus if there are variables or references that provide criteria (or anything else)...
  13. Replies
    4
    Views
    692

    Re: IIF Statement with Multiple condition

    Obviously I don't have your exact tables but an expression similar to yours works as expected.
    I still don't know if your problem relates to all calculations for every record or just some records....
  14. Replies
    4
    Views
    692

    Re: IIF Statement with Multiple condition

    You get either inactive or active when you shouldn't or you get something else, such as an error?
    If the former, one of the values must not be what you think it is. The testing approach is to verify...
  15. Re: Using variable instead of single file name for export to Excel, based on a form selection

    why not just continue your prior post for the same issue?
    https://www.mrexcel.com/forum/microsoft-access/1103967-need-export-data-existing-excel-file-using-variable-file-name.html

    The answer I...
  16. Re: Need to export data to existing Excel file, using variable in the file name

    Doesn't work doesn't help, or so my signature says :wink:
    Posting what you tried is a much bigger help - especially if you copy and paste.
    As mentioned, the code tag button is right on the menu...
  17. Re: Need to export data to existing Excel file, using variable in the file name

    what jumps out is
    - you don't wrap string variables (their names) in quotes, so not "ProjExport & .xlsm" but ProjExport & ".xlsm"
    - there is a space where you probably don't have one, so please use...
  18. Replies
    4
    Views
    759

    Re: MS access - generate query visually

    I started on a form that allowed you to specify the table from a combo, which would then enumerate each field other than autonumber id, I think. The idea was to select a field and code would...
  19. Thread: Checkbox issue

    by Micron
    Replies
    4
    Views
    662

    Re: Checkbox issue

    maybe the Access table field is formatted as Yes/No? Not sure if Excel would still do the same if it was True/False. Would probably not if it was integer, which is really the best choice for...
  20. Replies
    8
    Views
    824

    Re: Running a "Run All" using Scheduled Task

    One way I have done this in the past was to have TS open the db with a command switch because the pc for this was solely used for the purpose of updating db's in the middle of the night. It was...
  21. Replies
    1
    Views
    479

    Re: Volume tracker in access

    cross posted
    https://www.access-programmers.co.uk/forums/showthread.php?t=305791

    see rule 13
    https://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html
  22. Replies
    8
    Views
    824

    Re: Running a "Run All" using Scheduled Task

    what should work:
    change Private declaration for button click to Public
    macros must call functions AFAIK, same as toolbars, menubars, ribbon, etc. so in a standard module,
    Function RunSomeCode()...
  23. Re: switching specific coulmns from vertical to horizantal to get one record !

    research crosstab query. If you need to base a report on a crosstab, you may need to worry about making the output columns fixed because the nature of a ct query is such that the number of field...
  24. Replies
    3
    Views
    509

    Re: access 2013 button

    You can't - literally speaking. You can set button picture property as you already may realize, but you can't "buttonize" an image. I don't know the max image size allowed on a button, but do know...
  25. Replies
    3
    Views
    591

    Re: Audit trail for Unbound forms

    You can probably use temp tables, bind the controls to the temp and use old value property and auditing code. Write record (update) back to main table IF the record is altered and flush the temp...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4