Recent content by skaurd

Hi I have an Access database linked to an ODBC connection to a sybase databse. The charset set in the ODBC connection is utf8 to match the sybase data. However, special characters are appearing in Access completely incorrect. Ie. Münchener Rück should be displayed as Münchener Rück Can...

Hi I have an ODBC connection to a sybase database. This has always worked fine for me to write queries etc. Although what i have noticed is that when inserting data, the triggers on the sybase database do not run. Is there something I can do to change this?? An option of some sort? many...

Hi I am in a major pickle. A while ago, I created a complex query, rather unprofessionally. The query has many tables joined togethers. Ie FQ 1998 Q1, FQ 1998 Q2, FQ 1998 Q3, FQ 1998 Q4 up until 2002. The tables are joined by a foreign key company_details_id. Which is linked to the table -...

Hi PGK Thanks for your help. But which code do I put in? yours gratefully S

Hi Doug Thanks for this. But can you give me clearer step by step instructions as I really do not understand what to do. Sorry, but I am not that clued up with Access

Hi I have a complex report, which includes many sub reports. Each sub report consists of queries which are calculating formulae. When this report is run for 95 records, Access 97 brings back an error message, along the lines of @not enough temporary memory.." When the same report is run...

Hi How would I run a query/report with a prompt which has a combo list of choice to choose from only? Rather than inputting the answer in the prompt window? thanks S

Hi I have a combo list with a list of companies. When selected, I want my database to set the field research_profiling to "N" in the company details table. After the user has verified that they are sure they want to do this. Can anyone please help me with the coding etc? yours...

Hi RSi2 This is good, but the user wanted it in excel so that they could change/manipulate the data into charts etc. Have you any further suggestions? I can export via text, and this works, but it only works for fixed width and i have to add the lines in manually. Not something a user would...

HI I have a complex report made up of many subreports Layout is similar to this; Sector 00 Q1 00 Q2 00 Q3 Company Sequential Sales Sequential Ebita RoE for each company. Anyway, when I export it into excel, the layout is not the same. The company is in a seperate column...

I am doing this manually - File/Export. I have tried CSV/Text, but the layout is all messed up. Thanx S

HI I have a report but it does not export to excel. It appears as though it is exporting, the processing happens, but there is no file in the exported destination selection. I am not sure what the problem is, but I have made many other reports (although not as complex) and they have exported...

Sorry SBendBuckeye, but call me stupid, but I cannot find your email address in your profile. thanx S

Hi I have a combo list with a list of companies. When selected, I want my database to set the fireld research_profiling to "0". How would I do this please? I would like a message to appear before this is actioned to ask the user to make sure they really want to do this. thanx S

Dear Sailalong This is great! It worked just fine. Can you help me further please? I cannot export the report into excel. Even though it seems like it is exporting, it goes through the process of exporting all the pages one by one, but no excel file is generated. I can export to txt file...