Search results

ByteMyzer Thank you for your reply. how can you tell if your SQL expression exceeds the 255 characters. does it inculde the table name/ fields etc. what is best practice when you need to use DISTINT key word and have Memo fields in the table. thanks agian for all your help Regards Desmond

In the RPT_CCC_PROJECTS_DIM table

I have taken them out as they are being truncated because of the distinct key word in the SQL. I had hoped to add them back in after retriving the data. Is this the best approach?

ByteMyzer thank you for your reply sorry if I have not made my question clear. Basically my question is that my sql statement is longer than 255 charactors long which is causing the memo feilds to truncate. also using DISTINCT causes truncation. can you explain to me some of the methods used...

Can I take out the RPT_CCC_TASK_DIM tanble name too? Regards Desmond

I have been told that they is a way where you don't have to specify the table name for each field you enter into a query reducing the typing and making it easier to read. I have put the code below. how can this be reduced. SELECT DISTINCT RPT_CCC_PROJECTS_DIM.PROJECT_CODE AS [Clarity Ref]...

Allen Browne Truncation of Memo Fields article indicates if your expression is longer than 255 Characters Memo fields will be truncated. Will the SQL code below contravene this rule does it include table names SELECT DISTINCT RPT_CCC_PROJECTS_DIM.PROJECT_CODE AS [Clarity Ref]...

Thanks Guys But I still have the same problem The original query now has 69 lines with the Distinch key word which is correct but you link it with the table which has the memo files it results with the same amount as without the DISTINCT key word code attached what am I doing wrong...

I have read an article by Allen Browne where it describes a workaround for a truncation issue of the Memo field where the DISTINT key word Workaround Open the query's Properties Sheet and set Unique Values to No. (Alternatively, remove the DISTINCT key word in SQL View.) You may need to...

Is it possible to format memo and text fields for instance right justify the text etc Thank you in advance

Found It Thanks RuralGuy

I have a query which I export the results to an Excel spreadsheet the problem is when view within Access the format in the column is DD/MM/YY but when you look at the exported report it is 23 May 09 what is more strange most of the columns in the report are in DD/MM/YY format so why is this...

I have sent a colleagee a copy of a Access database application I have which has 4 linked tables to an Oracle database. I told to him to place the TNSNAMES.DSN in the same location I have it on my PC. When a query is run it invites to to enter the user id and password once entered the...

I have an Access database which I have developed it has linked tables to an oracle database and therefore requires TNSNAMES.DSN file. A colleague who would like a copy of the database on his PC and would like to know how to install the Access database on his PC. To be honest I have no idea...

I have a VBA module which calls a Excel macro which formats the exported spreadsheet. Its currently working fine on my PC referring to the macro in my personal.xls spreadsheet. I now need to distribute the database out to other users and plan to create a add-in spreadsheet to distribute with...

What value should I specify for it to be saved in Excel 2003 form regards

Is it not possible to then open the spreadsheet again and save it with Workbook.Saveas method before I run the called Excel macro. It seems that becase the files has been save as 95 format and the Excel macro benn recorded using Excel 2003 some of the actions do not work like condistional...

Access 2003

Thanks for your reply The version I am using is Excel 2003 I was using Transferspreadsheet but the outputted format was all over the place OutputTo maintained the formatting.

I am using the above command in some VBA code and it is saving the spreadsheet in Excel 5.0/95 Format I am using defaults. I understand I can use FileFormat:= what value will give me Excel 2003 format Thanks in advance Line of Code below xlObj.activeworkbook.saveas "c:\documents...