Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.08 seconds.

  1. Replies
    2
    Views
    134

    Re: Access 2010: Scroll Bars - again

    There is no scrollbar option for a detail section. However, you could try having a copy of your form as a split form (don't try this on the original) or you will have to recreate your detail section...
  2. Replies
    3
    Views
    272

    Re: How to handle duplicate vendors

    I'm not sure if the following is the same as 2 above, but I don't think so: Without knowing what the source data or the db table(s) looks like I'll say that if you created a table of "synonym" names...
  3. Replies
    3
    Views
    290

    Re: What's the fast way to do this?

    The regex approach shown will remove apostrophes as well? Might be a good thing, or maybe they want to keep the ' in O'Hara?
  4. Replies
    1
    Views
    592

    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...
  5. 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...
  6. Replies
    2
    Views
    693

    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...
  7. 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...
  8. Re: Excel Userform to Export to Access data base

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

    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...
  10. Replies
    8
    Views
    1,540

    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...
  11. Replies
    11
    Views
    1,005

    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...
  12. Replies
    8
    Views
    1,540

    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...
  13. 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...
  14. Replies
    2
    Views
    748

    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...
  15. Replies
    4
    Views
    893

    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)...
  16. Replies
    4
    Views
    694

    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....
  17. Replies
    4
    Views
    694

    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...
  18. 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...
  19. 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...
  20. 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...
  21. Replies
    4
    Views
    768

    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...
  22. Thread: Checkbox issue

    by Micron
    Replies
    4
    Views
    666

    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...
  23. Replies
    8
    Views
    828

    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...
  24. Replies
    1
    Views
    481

    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
  25. Replies
    8
    Views
    828

    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()...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4