Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.03 seconds.

  1. Replies
    3
    Views
    333

    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...
  2. 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...
  3. 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 :
    ...
  4. 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:...
  5. 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...
  6. Replies
    2
    Views
    522

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

    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!
  8. 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...
  9. Replies
    2
    Views
    725

    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 :...
  10. 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
  11. Replies
    8
    Views
    1,169

    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.
    ...
  12. Replies
    8
    Views
    1,169

    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.
  13. Replies
    2
    Views
    667

    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
  14. 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.
  15. Replies
    3
    Views
    1,005

    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...
  16. 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,"")
  17. 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"...
  18. 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...
  19. 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.
  20. Replies
    4
    Views
    557

    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.
  21. 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...
  22. Re: Run the “ready” query in ACCESS from VBA Excel with the parameter

    What do you mean it doesn't work?

    what would you like to happen? The original query is a select query - if that runs you wouldn't see anything. Are you trying to write something back to the...
  23. Replies
    3
    Views
    707

    Re: Report Queries Back End vs Front End

    Your back end should only contain tables, no queries or reports.

    even if you had the reports in the BE you would need to release a new FE every time in order to link to the the new report.

    In...
  24. Replies
    2
    Views
    567

    Re: help with iif statement in access

    I would say adding a basic table with 2 columns is the best option for this, it is a lot easier to maintain than updating formula across all queries/reports/forms.

    Nested IIF will have a...
  25. Replies
    7
    Views
    1,042

    Re: Access: VBA to Make a Table from a Query

    gheyman - why do you need the calculated fields in a table? Can you not use the query?

    Does this tie into your previous DSum issues - perhaps there is a better way of going about the problem if...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4