Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.06 seconds.

  1. Replies
    2
    Views
    73

    Re: Bound Column Change Not Working

    This looks like a variation of another of your posts? Regardless, I don't know what you expect to get in the way of an answer with so little information provided. Maybe post what you tried for...
  2. Replies
    6
    Views
    133

    Re: Maintenance of MS Access Back End

    That is something that raises a red flag. If anyone left a half-finished form edit in play and you're forcing a shut down you can expect things like this to happen. Not sure myself, but I would even...
  3. Replies
    6
    Views
    455

    Re: Formula in a Query in the Feild

    Don't forget that if expressions start getting real hairy, you can call a function from a calculated query field as well.
  4. Re: Add next number based on previous record SET

    Well, so many points I raised and no comments on any of them. Between (mainly) that and the fact that I can make no sense of your bolded comment, I have to bow out. I figured I ought to try at least...
  5. Re: Add next number based on previous record SET

    Not sure what your problem is with the code, but here's what I wonder about:

    - you have OPTION EXPLICIT set (good) yet I see a variable that you didn't declare - lngCurrentName.
    - you show doc no...
  6. Replies
    2
    Views
    365

    Re: Access Split Database Issue

    The details are a bit confusing. If I ignore the word Front and suppose these are back ends (because they have tables RS and RS_Hist) and they are split. But they have tables linked to Front_DB_A ??...
  7. Re: How to find all combinations within a constraint

    cross posted
    https://www.access-programmers.co.uk/forums/showthread.php?t=306791
  8. Re: Method for maintaining listbox possible values

    there is also the Not In List event for a combo box, which doesn't require a form for editing list items. However, it can be problematic if not done correctly, and requires additional code if more...
  9. Replies
    2
    Views
    1,316

    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...
  10. Replies
    3
    Views
    1,204

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

    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?
  12. Replies
    1
    Views
    1,263

    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...
  13. 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...
  14. Replies
    2
    Views
    1,099

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

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

    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...
  18. Replies
    8
    Views
    1,765

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

    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...
  20. Replies
    8
    Views
    1,765

    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...
  21. 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...
  22. Replies
    2
    Views
    769

    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...
  23. Replies
    4
    Views
    972

    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)...
  24. Replies
    4
    Views
    738

    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....
  25. Replies
    4
    Views
    738

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