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
    394

    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...
  2. 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...
  3. 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...
  4. 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...
  5. Replies
    1
    Views
    760

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

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

    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...
  8. Replies
    5
    Views
    1,631

    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
    ...
  9. Replies
    5
    Views
    1,631

    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'
  10. Replies
    5
    Views
    1,631

    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...
  11. Replies
    5
    Views
    1,631

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

    Many thanks John, great starter to exactly what I need. Really appreciated.
    Alan
  13. 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...
  14. Replies
    2
    Views
    2,174

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

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

    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"
  17. Replies
    3
    Views
    2,086

    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
  18. Replies
    3
    Views
    2,086

    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...
  19. Replies
    2
    Views
    606

    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...
  20. Replies
    2
    Views
    606

    Custom View settings

    Excel 2007 Windows XP sp3
    Is it possible to view the settings for existing custom views in a workbook - and how?
    either from ribbon or vba.

    Thanks
  21. That's great Steve. I should have realised...

    That's great Steve.
    I should have realised creating the text file in code was the solution.
    Many thanks for that.
  22. Just re-read that post and, the text/cells in...

    Just re-read that post and, the text/cells in Excel window have just the single quotation marks around them but then have 3 sets when opened in notepad.
  23. Saving as csv with quotation marks around values

    This is the current part content of a csv file when opened in notepad:
    Invoice_Date,Invoice_Net
    20110518,4662.73
    20110518,4662.73
    20110518,4662.73
    20110518,4662.73
    20110518,405.07...
  24. Replies
    9
    Views
    1,261

    Thanks Guys. Yes, the greater than portion on...

    Thanks Guys.

    Yes, the greater than portion on it's own works fine, which is why I was getting confused.

    The splitting of the fields criteria as per John's suggestion works great and now I get...
  25. Replies
    9
    Views
    1,261

    I'm quite comfortable working with Access and VBA...

    I'm quite comfortable working with Access and VBA but one brief field in a query is confusing a little.
    Any help would be appreciated:
    I have form of frmReports
    On this form is a combo drop down...
Results 1 to 25 of 359
Page 1 of 15 1 2 3 4