Search:

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...

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...

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...

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...

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...

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...

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
...

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'

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...

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...

Many thanks John, great starter to exactly what I need. Really appreciated.
Alan

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...

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...

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...

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"

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

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...

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...

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

That's great Steve.
I should have realised creating the text file in code was the solution.
Many thanks for that.

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.

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...

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...

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...

Thanks Andrew, form version works fine. http://windowssecrets.com/forums/images/smilies/cheers.gif