Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.05 seconds.

  1. Replies
    3
    Views
    280

    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)...
  2. Replies
    4
    Views
    321

    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....
  3. Replies
    4
    Views
    321

    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...
  4. 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...
  5. 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...
  6. 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...
  7. Replies
    4
    Views
    459

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

    by Micron
    Replies
    4
    Views
    438

    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...
  9. Replies
    8
    Views
    655

    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...
  10. Replies
    1
    Views
    346

    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
  11. Replies
    8
    Views
    655

    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()...
  12. 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...
  13. Replies
    3
    Views
    398

    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...
  14. Replies
    3
    Views
    464

    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...
  15. Re: Lock form on a given time period from adding new records

    In your code that enables/starts the req process, you can compare the current time (using Time function) to your values.
    If Time > #07:00:00 AM# AND Time < #05:00:00 PM#
    or some similar logic.
    ...
  16. Re: DLookUp for Search Strings in another table...

    I believe I have seen this before and the determination was that you cannot use a string from a table as criteria in a query. If you create a table with just one where clause string and a new query,...
  17. Re: DLookUp for Search Strings in another table...

    you cannot use DLookup to lookup values based on a sql statement or any part of such as statement. The first parameter must be a field; the second must be a domain. The domain can be a table or...
  18. Replies
    1
    Views
    315

    Re: filter subform using cbo box

    f_WorkingHoursSub.Form

    Bold has to be the name of the subform control. Possibly they are the same, but not guaranteed that they are.
    Also, if combo does not return a value of Date data type, the...
  19. Replies
    2
    Views
    366

    Re: Show all Buttons

    Certainly. You'd loop through all the controls on a form and for those that are command buttons, set their visible property. Assumption made on how you determine if the condition is true (untested):...
  20. Re: Number Serial Numbers in sequential order by order of appearance

    That and your last post suggests that the ranking criteria is probably there - such as date or a combination of other data. I agree with xenou that your approach is most likely not required and may...
  21. Re: How to remove date picker from query fields

    Sounds like you are working in queries, which is really no better than working in tables, which should be discouraged. The safer/better place to work on data is in forms.
  22. Replies
    6
    Views
    681

    Re: Select A Textbox

    Is there a naming problem here? Probably not, as
    Issue_To_Floor_Work_Order is the actual name, I suppose. If the control is disabled or locked you can't set focus to it.

    Not being much of a...
  23. Re: Is what I want even possible? *Warning - long post*

    As to your first question - if you can conceive it, someone can, without a doubt, build it. However, the learning curve for building something like this that "sorta works" is not nearly as long as it...
  24. Re: Show all records of Main form in the subform instead of just one

    Technically I don't think this is possible. A subform view doesn't show "all the records". It only shows records that are related to the ONE record in the main form, and a main form doesn't show "all...
  25. Re: Query - Filter out multiple bar codes to show only 1 bar code per product.

    Be very careful with Last or First - it seldom works the way many would expect. Do not use it on an un-ordered set of records or you run the risk of getting what you think is Last sometimes, and...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4