Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.01 seconds; generated 56 minute(s) ago.

  1. Replies
    4
    Views
    108

    Re: Import SharePoint Excel Files

    Did you try creating a shortcut to the explorer view of your library and then accessing the file through there when importing?

    It sounds like from the below that this approach would work:
    ...
  2. Replies
    4
    Views
    1,037

    Re: Access Track Changes to Data

    See my post in this thread:

    https://www.mrexcel.com/forum/microsoft-access/1112353-advice-best-method.html

    I've not used this audit feature to roll back records, but so long as you have all the...
  3. Replies
    2
    Views
    589

    Re: Access: Advice on best method

    I would opt against this approach of duplicating records and use an audit table to track changes to records. The basic idea is that everytime you modify a record, a code runs to append the old and...
  4. Re: Dont' display rows based on certain columns being empty?

    Your criteria should be in the Criteria row (or WHERE clause if writing the SQL).

    The SQL would be:
    WHERE Nz([SKU],'') <> ''

    The criteria should be able to go under any of the columns in...
  5. Thread: Exceptions table

    by JonXL
    Replies
    3
    Views
    573

    Re: Exceptions table

    What fields are you needing to compare? This can be done in one of a few ways. Here is one possibility:



    SELECT T1.*
    FROM Table1 T1
    LEFT JOIN Table2 T2
    ON
    T1.Field1 = T2.Field1
    AND
  6. Re: Getting a mismatch error when creating PivotTable through VBA

    I don't know anything about creating PivotTables through VBA, but your error would suggest that PCache is the wrong type of variable for assigning what you're trying to assign to it.

    One thing to...
  7. Re: Method for maintaining listbox possible values

    It's a good approach. A couple of thoughts, though:

    1. Since users can't change list boxes, the selections for this field should be hard-coded so they don't have to be separately typed in.
    2....
  8. Thread: excel issue

    by JonXL
    Replies
    1
    Views
    134

    Re: excel issue

    I think hitting F2 will toggle the mode (at the bottom left where it usually says 'Edit').
  9. Thread: Error handling

    by JonXL
    Replies
    10
    Views
    205

    Re: Error handling

    You can get rid of the colon at the end of the 'Goto 1'. (You might also consider a more meaningful label.)



    Where do you want to put a blank? And where do you want to put a 1? And how do you...
  10. Thread: Access Query

    by JonXL
    Replies
    4
    Views
    1,428

    Re: Access Query

    Can you post the two records you are expecting it to return?
  11. Replies
    5
    Views
    129

    Re: If cell contains data then format

    Have you looked into using Conditional Formatting?

    https://support.office.com/en-us/article/use-formulas-with-conditional-formatting-fed60dfa-1d3f-4e13-9ecb-f1951ff89d7f
  12. Replies
    3
    Views
    184

    Re: Setting the name of a PDF file export

    The key is in this line:


    xFolder = xFolder + "\" + xSht.Name + ".pdf"

    Change xSht.Name to what you want to call the PDF. If you want it to be whatever is in C16 (which I assume is on xSht?),...
  13. Re: Microsoft Access cannot find the referenced form 'frmTagPrintEquip'

    Is it closed when that SQL runs? Because it needs to be open and not in Design view.
  14. Replies
    1
    Views
    156

    Re: Networkdays formula issues

    It works as intended from what I can see in your sample.

    Note: NETWORKDAYS includes the first and last day in the count of the number of days.
  15. Replies
    14
    Views
    686

    Re: conditional format to change text

    Thank you! I've tried to do this in the past with no luck - I am sure I will need that formatting again. Very useful information.
  16. Replies
    14
    Views
    379

    Re: Generating a True or False (Advanced!)

    Use this formula - much better than mine!
  17. Replies
    14
    Views
    686

    Re: conditional format to change text

    The closest I can see to using Conditional Formatting is to get some text added to the cell, but not replacing what is there.

    For example, in B1 you can add a formula for the Conditional...
  18. Replies
    14
    Views
    379

    Re: Generating a True or False (Advanced!)

    For me, your explanation doesn't match your picture.

    The explanation tells me that if I am looking for '4', I should get FALSE (based on the data in the picture), but the result in the picture...
  19. Replies
    3
    Views
    183

    Re: Check if Worksheet Object is Set (VBA)

    This should work,


    If ThisWS Is Nothing Then

    But you might avoid the problem all together by declaring your variables properly:


    Public ThisWS As Worksheet
    Public ThatWS As Worksheet
  20. Replies
    4
    Views
    1,093

    Re: Failing to import data to tables

    Do you get any import errors?

    Is there anything at all consistent about the data not importing (always the same type, field, row number, etc.)? Is the DB getting up there is in size?

    Also,...
  21. Replies
    3
    Views
    732

    Re: Audit trail for Unbound forms

    What will you be auditing?
  22. Re: For Next loop to skip formulas that contain specific string - Runtime Error 424

    Dim Dpndnt as a String. Then set its value using:


    Dpndnt = Left(Range("L" & i).Formula, 4)
  23. Re: For Next loop to skip formulas that contain specific string - Runtime Error 424

    You can't set a range variable to a string.

    What are you trying to set it to?
  24. Thread: Select A Textbox

    by JonXL
    Replies
    6
    Views
    858

    Re: Select A Textbox

    Is this part of a With statement? If not, you also need to reference the form, eg, with Me:


    Me.Issue_To_Floor_Work_Order.SetFocus
  25. Re: One Form, Multiple Query Sources (but not at the same time)

    If the queries are identical except for the field used in the criteria, I would opt for one query with a conditional criteria (compares to a different field based on the condition you decide).

    I...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4