Search:

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

Page 1 of 15 1 2 3 4

Search: Search took 0.02 seconds.

  1. Replies
    4
    Views
    1,073

    The LEFT function is a red herring! I have a...

    The LEFT function is a red herring!
    I have a module in the database that declares a function completely unrelated to the Left/Right/Mid and I had overlooked it when including PtrSafe in the 'Declare...
  2. Replies
    4
    Views
    1,073

    The code is actually in the query field in this...

    The code is actually in the query field in this particular instance and is:
    "Left([sort_code],2) & Mid([sort_code],4,2) & Right([sort_code],2) AS S_C,"

    all pretty basic run of the mill, but the...
  3. Replies
    4
    Views
    1,073

    Left function problem in Access 2013

    Having just updated to 2013 I am seeing the expected errors with macros in Excel needing declaration including the PtrSafe but in Access I am seeing a problem wherever the Left() type function has...
  4. Replies
    5
    Views
    508

    that certainly helps a lot thanks! Very much...

    that certainly helps a lot thanks! Very much appreciated :cheers:
  5. Replies
    5
    Views
    508

    Thanks RG partial table for illustrative...

    Thanks RG
    partial table for illustrative purposes is:
    Order_Ref YearS Period Session
    W15 2014 7 1
    W16 2014 7 1
    W17 2014 7 1
    W18 2014 7 1
    W19 2014 7 4
    W20 2014 7 4
    W21 2014 7 4
  6. Replies
    5
    Views
    508

    Greater than and less than

    I am trying to apply an sql connection to retrieve data complying to a set of parameters as applied against the 2 fields
    One field is period and the other field is session

    The table contains many...
  7. Replies
    2
    Views
    693

    declaring 2darray in excel vba

    I need to declare a 2d array purely in VBA to cater for checking an incoming file for completeness.
    each line of the array would be of strings such as "Person ID", "BE"

    I know the complete list...
  8. Thanks, been a long busy few weeks so just back...

    Thanks, been a long busy few weeks so just back on this.
    Yep, all users have same mappings at logon and having checked their sessions the mappings are remaining in place.
    I have tried the files in...
  9. workbook links updating strange behaviour - Excel 2010 SP1

    Several workbooks each with many worksheets (50+)
    but lets just say workbook1 and workbook2

    Workbook1 has multitude of links to workbook2
    Some of the links used a mapped drive references suchs...
  10. Excel 2010 SP3, intermittent link cell problem

    We are experiencing this problem with virtualised servers, Citrix and excel 2010 files.
    Link formulas cells return #REF! and on other occassions return maybe a 0 instead.
    I cannot repeat the error...
  11. Replies
    1
    Views
    876

    We are experiencing this problem with virtualised...

    We are experiencing this problem with virtualised servers and excel 2010 files.
    Link formulas cells return #REF! and on other occassions return maybe a 0 instead.
    I cannot repeat the error on...
  12. Replies
    3
    Views
    1,938

    Thanks Guys, the sql was very basic where 1 query...

    Thanks Guys, the sql was very basic where 1 query was linked on one to one join with another query based on a text field.
    One of those queries that you take down to a single field and it still...
  13. Replies
    3
    Views
    1,938

    Access 2007 SP2 - Invalid Operation

    I'm running the simplest of queries (honest) but am getting Invalid Operation every time I run it.
    1 query and 1 table.
    I run the query with 1 query and it works fine
    Run it with both and invalid...
  14. Replies
    5
    Views
    1,902

    Weirdly enough, the parameters are in an earlier...

    Weirdly enough, the parameters are in an earlier query which feeds the end query, but I added the following in:

    Set qdf = db.QueryDefs("qry_MT103_Output")
    For Each prm In qdf.Parameters
    ...
  15. Replies
    5
    Views
    1,902

    Forgot to add: form parameters are in the style...

    Forgot to add: form parameters are in the style of:
    [Forms]![frm_Choice]![cmbEmployerRef]

    where cmbEmployerRef is a drop down selection on the form 'frmChoice'
  16. Replies
    5
    Views
    1,902

    Thanks John, specified the parameters at the...

    Thanks John,
    specified the parameters at the start so I thought that would not be part of this problem, so I then wrote the criteria direct into the query and removed the query parameters.
    the...
  17. Replies
    5
    Views
    1,902

    Too few parameters - RESOLVED

    Access 2007 sp2

    I am using an export to write values from a query out to a text file.

    the source query returns data based on the choices from a form.
    All standard stuff.

    I have included the...
  18. Many thanks John, great starter to exactly what I...

    Many thanks John, great starter to exactly what I need. Really appreciated.
    Alan
  19. MT103 files and exporting individual records to text files

    Just throwing this out there before I go and reinvent the wheel.

    Has anyone used access db for generating the source data for an MT103 type file?

    MT103 being a text file for the transfer of...
  20. Replies
    2
    Views
    3,568

    Charts when legend doesn't contain all data

    Excel 2007 SP2
    Chart based on table
    Table header contains the legend titles
    For 5 series displayed on the chart there are only 4 series included in the legend.

    The workaround I have is to...
  21. Replies
    3
    Views
    1,262

    thanks Rory. I've implemented the calc for...

    thanks Rory. I've implemented the calc for counting each indiivdual element of y/m/d rather than relying on datedif.
    I did notice however that the error crept in when the start day date was of a...
  22. Replies
    3
    Views
    1,262

    DateDif "md" returning excessive numbers

    Excel 2007, SP2
    Date1 is 25/5/2011
    Date2 is 11/1/2012

    DateDif returns:
    0 years when using "y"
    7 months when using "ym"
    181 days when using "md"
  23. Replies
    3
    Views
    2,417

    thanks

    Thanks Guys, just trawling through the database now to check and correct.
    Didn't help that the 2008SM was installed blindly with nothing checked.
    Thanks again.
    alan
  24. Replies
    3
    Views
    2,417

    Collation on SQL Server 2008

    I have database which I am testing on sql server 2008 as installed by a.n.other.
    the server is a shared area so I am pretty much tied to the set up already chosen by the installer.

    When I have...
  25. Replies
    2
    Views
    679

    Thanks Rory, it was actually the definition of...

    Thanks Rory, it was actually the definition of the custom view just as you say.
    Once custom view is selected the workbook goes into long drawn out process of switching sheets and calculations run...
Results 1 to 25 of 365
Page 1 of 15 1 2 3 4