Search:

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

Page 1 of 15 1 2 3 4

Search: Search took 0.02 seconds.

  1. Replies
    2
    Views
    56

    solved

    Thanks Paul No there is no column with a space in it..however, I have just managed to solve it.
    The problem arises when the formatting of the column is indented and vertical centre.
    I set the...
  2. Replies
    2
    Views
    56

    Save as csv creates trailing space

    have an excel sheet where saving as file format xlCSV keeps all of the columns but one column is having a trailing space added to the text.




    EMPLOYEE
    PAYCODE
    HOURS
    DATE WORKED
    PROJECT
  3. Replies
    4
    Views
    1,510

    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...
  4. Replies
    4
    Views
    1,510

    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...
  5. Replies
    4
    Views
    1,510

    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...
  6. Replies
    5
    Views
    847

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

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

    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
  8. Replies
    5
    Views
    847

    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...
  9. Replies
    2
    Views
    843

    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...
  10. 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...
  11. 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...
  12. 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...
  13. Replies
    1
    Views
    963

    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...
  14. Replies
    3
    Views
    2,170

    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...
  15. Replies
    3
    Views
    2,170

    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...
  16. Replies
    5
    Views
    2,147

    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
    ...
  17. Replies
    5
    Views
    2,147

    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'
  18. Replies
    5
    Views
    2,147

    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...
  19. Replies
    5
    Views
    2,147

    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...
  20. Many thanks John, great starter to exactly what I...

    Many thanks John, great starter to exactly what I need. Really appreciated.
    Alan
  21. 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...
  22. Replies
    2
    Views
    5,123

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

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

    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"
  25. Replies
    3
    Views
    2,562

    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
Results 1 to 25 of 367
Page 1 of 15 1 2 3 4