Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.02 seconds.

  1. Thread: Len() function

    by stumac
    Replies
    10
    Views
    154

    Re: Len() function

    Don't know why you seem so annoyed, to me it's a downside if not to you that's grand.

    Have a nice day.
  2. Thread: Len() function

    by stumac
    Replies
    10
    Views
    154

    Re: Len() function

    *No additional if statements :eeek:
  3. Thread: Len() function

    by stumac
    Replies
    10
    Views
    154

    Re: Len() function

    No if it is within a loop - no if statement required.

    the downside to this is if the control does not have an associated label it will error out. I tend to have meaningful control names and use...
  4. Thread: Len() function

    by stumac
    Replies
    10
    Views
    154

    Re: Len() function

    One way is to make use of the tag property of the controls (in the example below this looks at controls with a tag of reqd.


    For Each ctl In Me.Controls
    If ctl.Tag = "reqd" Then
    If...
  5. Replies
    3
    Views
    349

    Re: How to Link your Access DB to Sharepoint?

    Access supports migration of the back end to SharePoint, it basically creates lists within the SharePoint sites, imports your data into them and then creates a linked table in their place within the...
  6. Re: External Table is not in the expected format - ms access 2013

    Could you be running into this issue:

    https://docs.microsoft.com/en-us/office/troubleshoot/access/import-export-access-to-excel

    Looks like workarounds are to change the file type or open the...
  7. Re: Set Due Date/Time using DateAdd exclude weekend and holiday

    Sorry the link above will give you the number of days, something like what is posted here should work :
    ...
  8. Re: Set Due Date/Time using DateAdd exclude weekend and holiday

    unfortunatley Access doesn't have a built in function to achieve this, however, it can be done using a UDF. Here is a link to one that you should be able to use or adapt:...
  9. Re: Run Access Function from Excel without opening database

    If the the function residing in Access is dependent on other Access objects then that is probably the best way to go.

    I take it you are giving each user a local copy of the front end and this is...
  10. Replies
    2
    Views
    524

    Re: Date and Time code

    if you have a control for the date and time on the same form to add the date and time you should be able to set it on the On click event


    Private Sub MyButton_Click()
    Me.MyField = Now
    End Sub
    ...
  11. Replies
    3
    Views
    1,007

    Re: Constant Back End Corruption

    Glad you have a solution, going down the Azure route seems sensible. Something I have been wanting to test with an Access FE, be good to hear how you get on with that!
  12. Re: Run Access Function from Excel without opening database

    You can connect to your database, query it and even add a record without opening the access application - infact you can do it without having access installed on that machine.

    However, you cannot...
  13. Replies
    2
    Views
    731

    Re: Access: On Load On Current

    The On current event will fire directly after the on load event and then every time you move record.

    You can see the order of events here :...
  14. Replies
    2
    Views
    76

    Re: If then statement failing

    The code does not know what B2 is, it is looking for a variable with that name. You need to tell it to look at the range B2:


    If ActiveSheet.Range("B2") = "" Then
  15. Replies
    8
    Views
    1,173

    Re: Access: If Statement to Run Macro

    In Access 2016 this doesn't work. I have tested it as per the OP's scenario, without the private statement it works fine, with the private statement the following error is returned.
    ...
  16. Replies
    8
    Views
    1,173

    Re: Access: If Statement to Run Macro

    Think this is referring to Excel, Macros are a different object in Access, furthermore, I don't think this works with Access subroutines.
  17. Replies
    2
    Views
    669

    Re: Access: Using Toggle/Option Buttons

    The value is assigned to the frame control:




    Private Sub Frame244_Click()
    Select Case Frame244
    Case Is = 1
    Text256 = "1"
    Case Is = 2
  18. Replies
    19
    Views
    371

    Re: Archive data error in code please help

    what is the error?

    again you are going from top to bottom, you will eventually run in to blank lines and some rows will not be tested.
  19. Replies
    3
    Views
    1,007

    Re: Constant Back End Corruption

    There is a known corruption issue with Access running on Windows 10 where the back end is on certain versions of Windows Server - I think Windows Server 2012 is the worse culprit for it but also...
  20. Re: Either of 4 cells equals a value then get the desired result

    If C2 & E2 never contain 1 then you could use countif, if they can then use OR.


    =IF(OR(B2=1,D2=1,F2=1,G2=1),100,"")
  21. Replies
    19
    Views
    371

    Re: Archive data error in code please help

    Using the method you are using you would just check mytext for the values:


    Option Compare Text


    Sub archive()
    Dim i, lastrow
    Dim mytext As String
    lastrow = Sheets("projects").Range("A"...
  22. Replies
    19
    Views
    371

    Re: Archive data error in code please help

    Just now it is lookiing for any value including delivered - therefore not delivered would be picked up.

    An issue you will face is starting from the top down means some rows wont be checked.

    if...
  23. Replies
    19
    Views
    371

    Re: Archive data error in code please help

    Looks like your quotation marks are wrong throughout -
    “ instead of
    "

    If you replace all of them to the correct one the code appears to run as intended.
  24. Replies
    4
    Views
    558

    Re: Access Annoyance: ComboBox Ordeal

    Can you share a copy with no data or mock/test data?

    Your description of what you are trying to achieve is unclear.
  25. Thread: Table Compare

    by stumac
    Replies
    7
    Views
    880

    Re: Table Compare

    As Micron Says, it is unclear if the only difference is the additional space, assuming it is there are a few options.

    The cleanest is to create a query (or 2) that changes the format of one or...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4