Search:

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

Search: Search took 0.00 seconds.

  1. Replies
    0
    Views
    218

    Using SharePoint username in Access

    I am developing an application with a MS Access front end and a MS SharePoint back end. Currently a user must login twice to use the app, first login to the app and then into the SharePoint server.
    ...
  2. Let's define the constants: Total Volume = 500...

    Let's define the constants:
    Total Volume = 500
    Max Gross = 100
    Let's Define the Known Variables:
    Avarage price
    Volume Sold

    Your Formula would then be:

    (Max Gross-(Vol Sold x Avarage...
  3. Replies
    1
    Views
    350

    Parent - Child influence on coding

    I have a form with the following getfocus event:

    DoCmd.OpenForm "frmLineInfo", acNormal, , "[idsLineID] = " & Me.idsLineID, , acDialog

    This works fine and performs precicely as I expect.
    ...
  4. Thank you for pointing me in a direction, I will...

    Thank you for pointing me in a direction, I will investigate further.
  5. Replies
    1
    Views
    218

    Run a first query to Determine the totals: ...

    Run a first query to Determine the totals:

    SELECT Table1.Hora, Sum(Table1.Volume) AS SumOfVolume, Table1.Unidad
    FROM Table1
    GROUP BY Table1.Hora, Table1.Unidad;

    Then run a second query on the...
  6. Can single Access front end connect to two SharePoint back ends?

    Is it possible to have a single Access 2010 based front end application connecting to two different SharePoint sub sites?

    If it is, how can I accomplish this?

    24000 people need access to an...
  7. Replies
    0
    Views
    521

    SharePoint restrict access to app

    In using SharePoint as a back end for an Access based app, is there a way to restrict users from accessing SharePoint lists directly? i.e. When using the app they are granted access, but when they...
  8. Replies
    19
    Views
    886

    Where/what does it link to? what happens if you...

    Where/what does it link to? what happens if you follow the link?

    Does it occur in random cells or only in a certain range?
  9. Best Practise: Determine behaviour when form closes

    I have a form (frmSubmitterAdmin) and depending on how the form was called, I want different things to happen when the form is closed e.g. if the form was called from a button on the main menu, I...
  10. Replies
    2
    Views
    443

    The fields updating from does not all reside on...

    The fields updating from does not all reside on the subform, though some do. I fixxed the code by adding Parent. in front of all field references.

    Duh - Icecream to my forehead!
  11. Replies
    2
    Views
    443

    Updating form values from subform.

    On my form I have a button with the following on click event:

    txtUserFirstName = txtEmployeeName
    txtuserLastName = txtEmployeeLastName
    txtUserEmail = txtEmployeeEmail
    ...
  12. Password property for field in SharePoint list

    For background info on the project, please see this thread.

    I need to create a text field in a SharePoint list with the password property. This is not available as standard, but it seems that one...
  13. Well the decision was basically made for me; I...

    Well the decision was basically made for me; I have to make do with what is currently available to me; so in my opinion the best option is SharePoint back end with Access front end. Due to the...
  14. Thank you for your input, in my opinion the best...

    Thank you for your input, in my opinion the best compromise between cost, scalability and ease of access would be an independent domain with a MySQL back end and PHP front end. Thus it would even be...
  15. Redeveloping and streamlining database developed by ignoramus

    The aim of this tread is to provide background information for guidance I will be asking in individual threads in the near future.

    First off, I am knowledgeable enough on access and VBA to know...
  16. Setvalue of field on Access form to value of specific cell in excel form.

    Hi,

    I have a form as part of an access database. Amongst numerous other fields on the form (from Different tables), I have the following fields:
    [CNum] : Primary key (autonumber) from one table...
  17. Replies
    9
    Views
    729

    Thank you, it is possibly the best way for me to...

    Thank you, it is possibly the best way for me to go. The main reason I want to go with help files is to provide the users with graphical step by step instructions.

    I sometimes feel that...
  18. Replies
    7
    Views
    19,606

    I found this, it does not use ActiveX at all and...

    I found this, it does not use ActiveX at all and fits in with what I need, my only problem is that using it as is, the funcionality is available in the whole sheet, I want it restricted to the range...
  19. Replies
    9
    Views
    729

    Thank You, I still need to find a way to bundle...

    Thank You, I still need to find a way to bundle the help files with (preferably in) my workbook, as (99 + 1)% of the people using the workbook will not save the help files even if I beg them to!
    ...
  20. Replies
    2
    Views
    3,021

    PS: Should you want to use other mail fields than...

    PS: Should you want to use other mail fields than those listed above, you have to use MS Access and not Excel.

    Ensemble
  21. Replies
    2
    Views
    3,021

    Exporting would be slightly different depending...

    Exporting would be slightly different depending on what version of outlook you use:

    Using Outlook 2010:

    go <File>, <Options>, <Advanced>, <Export>

    Follow the wizzard steps, selecting your ...
  22. Replies
    9
    Views
    729

    Helpfile for a workbook

    I want to add custom helpfiles that is only applicable to a workbook that must be destributed within our company. any sugestions?

    Ensemble.





    WHY?
  23. Replies
    7
    Views
    19,606

    With Excel 2010 this does not work. A similar...

    With Excel 2010 this does not work. A similar Active X controll is available in the professional version only. The problem is that there are noe forward, backward or sideways compatability. So even...
Results 1 to 23 of 23