Search results for query: *

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

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

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

Hi Is there a simple way to make the ODBC linked tables read only for all users? The database is going to be used purely for reporting and I don't wish for anyone to tamper with the data. thanks S

Hi I have a huge query, with too many fields for it all to go into one report. Therefore I have had to split up data into many queries and thus many reports. EBITA-margin report and query PBT-margin report and query Net return on sales report and query DSO report and query Inventory Turnover...

Hi I have a combo list with all the records from a table. I also have a delete query with a parameter to enter a company. is there a way to incorporate the 2? So that when the record is selected from the combo list, it goes off and deletes it from the table? But also gives several warning...

Hi I would like to create a customized delete command. Which enables a user to delete a record. But there may be 2 records with the same name, so when this occurs either give the user a pop up window to ask which one (select one) (maybe show another field, so that they can differentiate.)...

Hi I would like to create a query which changed the colour of a field (name)to red if another field is null (sales) and if the sales field is not null or "0" then the name field comes out green. Does anyone know how to do this? thanks S

Hi I am trying to create a combo list, but for some reason it isn't working properly. It keeps picking up the sector_id instead of the name. Basically, in the wizard, I select the table and field I want listed in the combo list. I then select in which field I want this stored. Each time I...

HI How would I get my form to add todays date and the time when a user updates the data? many thanks S

HI I have a form with no links to a table. What I want to do is once a user has added data to this and clicked save, I want the data to be populated into a table. All the data is going to be uploaded into one table How would I do this please? many thanks S

HI How can I make my combo list appear with the list of records in alphabetical order? thanks S

How do I remove the scroll at the bottom which enables one to toggle through records? The reason I need to remove it is because I have a combo list with all the selections in there and this is a sub form. The scroll makes this combo list look rather messy. thanks in advance S

I have a form which has numerous records sorted by year. How do I change it so that year is descending and the new record row appears that the top instead of at the bottom? thanks S