Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 1.36 seconds; generated 48 minute(s) ago.

  1. Replies
    3
    Views
    22

    Re: If/Then statements with three outcomes

    Sure, use a Case statement, i.e.

    Select Case Len(TB.Value)
    Case 0
    Set XXX
    Case 1
    Set YYY
    Case 2
    Set ZZZ
    Case Else
  2. Replies
    4
    Views
    19

    Re: Calling a Sub within the Main Macro

    You CANNOT imbed one macro inside another. They would be two separate macros, and you would just call one from the other:

    Sub Format_Workbook_Pt2()
    Call ConvertTextToNumber
    End Sub

    Sub...
  3. Replies
    1
    Views
    7

    Re: An easier way than this to SQL update ?

    It looks like you currently have 6 columns. It would be easy enough to loop through it without having to create the temporary v2 to v7 variables. However, building your code would be a bit...
  4. Re: Spreadsheet incredibly slow when moving tabs

    You must remember, while you are very familiar with this problem because it is in front of you, all that we have to go on is what you have provided to us in this thread, and you have provided very...
  5. Replies
    10
    Views
    220

    Re: Access: Refresh DSUM Values

    Do the other DSUM calcs work?

    Do you give thought to doing the calculation at the query level instead of the form level?
  6. Re: Spreadsheet incredibly slow when moving tabs

    That really sounds like a database to me...

    Perhaps this would be a good candidate for Power Pivots (which allows you to do some data grouping/summarizing).
    I think that it handles large groups...
  7. Re: Spreadsheet incredibly slow when moving tabs

    Then why so many tabs and formulas?
    What kind of formulas are they?
    What do they look like?
  8. Re: Spreadsheet incredibly slow when moving tabs

    This could be a clue that you may be using the wrong tool for the job.
    It sounds to me that you may really have a relational database (lots of data related to each other). If that is the case, a...
  9. Replies
    3
    Views
    30

    Re: Challenging If/And statement help please

    Welcome to the Board!

    If your dates are in cells A1, A2, and A3, try this formula:

    =IF(OR(AND(A1<=A3,A2=""),AND(A1<=A3,A2>=A3)),"Yes","No")
  10. Re: VBA-Macro Prevent Copy Paste in Data Validation Cell

    I am sorry, but without the file and the details of EXACTLY what you are trying to copy, I don't think I can help further.
  11. Re: Show (2) Form Tabs Open when Access is Opened

    You could use an "AutoExec" Macro (which runs when the database is opened), and have it open two Forms (though one will be displayed, and the other will be in the background).

    Alternatively, you...
  12. Re: VBA-Macro Prevent Copy Paste in Data Validation Cell

    Without having access to the data file, and knowing exactly the range you are trying to copy, I really have no idea.
  13. Replies
    10
    Views
    220

    Re: Access: Refresh DSUM Values

    You said that you have "several" DSUMs on your Form. Is it just this one having this issue, or all of them?

    I would recommend doing the calculation in the query you are using for the data source...
  14. Thread: Inquiry

    by Joe4
    Replies
    8
    Views
    138

    Re: Inquiry

    I have merged your two threads with the same question together. Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original...
  15. Replies
    3
    Views
    269

    Re: MSACCESS Formula Help

    You are welcome.
  16. Replies
    14
    Views
    144

    Re: VLOOKUP Returns #NA when data is present

    If they are both in the same file now, remove the [Book1] reference, and make sure that you have the right sheet reference.
    Or try using a named range instead, and referencing that.
  17. Replies
    14
    Views
    144

    Re: VLOOKUP Returns #NA when data is present

    You say two different sheets...
    Are those sheets in different files?
    If not, what is with the [Book1] reference? It should be unnecessary if both sheets are in the same file.
  18. Replies
    3
    Views
    269

    Re: MSACCESS Formula Help

    Try:

    Steps Detail Status: IIF([StepsDetailOpen]="","COMPLETE","")
    Note that a single space (" ") is not the same as blank/empty ("").
  19. Replies
    1
    Views
    29

    Re: Integrating Excel and Word

    This sounds like a prime candidate for a Mail Merge.
    If you Google "Mail Merge between Excel and Word", you will find lots of articles and tutorials that should help you through it.
  20. Replies
    8
    Views
    676

    Re: Copy multiple column.

    You are welcome.
  21. Replies
    8
    Views
    676

    Re: Copy multiple column.

    Borrowing the logic from this link I found with a Google Search: http://codevba.com/office/loop_files_in_folder.htm#.XYTOIWlKiCg and the other tips I gave you, you can do something like this:

    Sub...
  22. Re: How to remove every other row in a spreadsheet from report quickly

    What does the data look like?
    Is there anything consistent about this rows that you want to remove (i.e. are they all blank)?
    Is it the odd or even number rows that you want to delete?
  23. Replies
    10
    Views
    220

    Re: Access: Refresh DSUM Values

    Where on your Form is this calculation taking place?
    Have a look here: https://access-programmers.co.uk/forums/showthread.php?t=192694
  24. Replies
    8
    Views
    676

    Re: Copy multiple column.

    Bumping too early/often isn't offending anyone, it is just hurting your chances of getting timely replies by removing your thread from the "Zero Reply Posts" listing.
    I usually recommend to people...
  25. Replies
    29
    Views
    523

    Re: Code needed for Max & Min Values

    I had mentioned earlier that you may need to re-think your design of this. If it were me, I would try to get rid of the situation where you have 13 copies of the code running simultaneously....
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4