Search results

Hi, It might be indeed a normalisation problem. With im trying to avoid by using these union queries is the folllowing. I have a query consists (among others) of the following: product| currency|yield| year|month|conversionrate_curr1|conversionrate_curr2 I need the query to check the currency...

Thanx.. I put a few index, but no change..

Hi, In my database im using several union queries as they turn out to be very useful. However, whenever I have a calculation that involves one of the union queries, things happen at a very slow pace. Is there a way to speed it up a bit? Thank you Stacey

Hey.. i did not use the date serial solution... but u were right about the alpgabetical order. I put on a filter and forgot to take it off. Guess the filter is stronger than the order in the query. Thanx for pointing that out. Stacey

Hi, I have a form based on a query. In this query I sorted the columns year and month in a chronological order. However, on the form this does not appear that way on the form. How can I enforce this? Thank you Stacey

Hi, Im trying to import a spreadsheet from Excel. I use the wizard and I get the sheet imported. The only problem is that I get additional blank fields in my table in Access. How can I make sure that this does not happen? I want to keep on importing into the same table, so these useless empty...

Thank you..I figured it out. Is there a way I can change the message that pops up when someone tries to enter duplicate values? Thanx Stacey

I have the following table: YieldID |ProductID | Year | Month| Yield I want to make sure that it is not possible to insert the same date (so, year and month together) twice for each productID. But at the other hand, it should be possible to insert the same date but then for different...

Hi everybody, There is a chance that I might be overlooking a simple way to solve this, so any suggestions I would appreciate. I'm working on a database and since it's my first database, I did not follow the first design and afterwards put your information in. This is the situation: I...

I dont know.. Actually, I dont know what is meant by "Duplicating keys". Can you give me an indication? Stacey

Hi, Im copying information from Excel to Acces. As I enter the information in fields in Access, this goes just fine. The problem is that sometimes I have to change the information I put in. So for example I first copied 10 record(cells), but now I discover that I have 20 records/cells. But...

Thanx anyway... its good to know alternative ways.. *stacey

hey muffinimal, your way worked and it's easy... thanx.. *Stacey

so, the only way out is to BUILD one from scratch? and not through the switchboard manager?

unfortunately that didn't change anything.. whatever I can do, it does not appear on the "forms area"... any other suggestions?

It could be... But can I get rid of it and make a new one that will appear on the "forms" area? so far i haven't been able to delete it since its giving me the default sign.

I accidently deleted the swithboard from the "forms"-area. I know it is still there, coz when I got to Database utilities|Switchboard Manager I can still see it. How can I get it back in the "forms area" Thank u.. Stacey

thank you.. that did it... Stacey

HI, I have an input form on which I have a combobox. The user can choose from the list of products. However, I want to use this input in a code and I need the productid to work with in the code. How can I arrange it that when the user selects, they can see the name of the product and the id...

Sorry for the late reaction... (got different time zone over here.. ) Thank u for the tips. I did change the structure a bit, and now its working properly.. Stacey