Search results for query: *

Someone needed to do lots of calculations (for example adding one field to another and dividing by another to give a new value) so they made it into a crosstab. It's also quite a large database and it would be much easier/safer not to change anything pre-calculation stage. Also, the query will...

Leslie, I will post the SQL in due course but can't get at it at the moment. Duane, By edit I mean build relationships with other tables. There are a number of measure names that in the crosstab query are being used as column headings. I would like to use these measure names as a foreign key in...

I'm working on a fairly large database and there is a crosstab query in it which is the end result of lots of other append/normal queries etc. I need to change some of the field values in the crosstab and it would be much easier to do if it was a normal query. Is there anyway you can convert a...

Thanks, Duane. I think you're right and it's probably not worth it. Thanks for your advice though.

Sorry, I didn't explain it very well. Let's say you were assessing the performance of training centres and you were given monthly data in the form of: TrainingCentre NumberOfCandidates NumberOfQualificationsAchieved CandidateSatisfaction MonthlyCostOfCentre You might want to assess training...

Hi Duane, Thanks for your reply. The formulas themselves aren't very complicated (at the most percentages, subtractions and multiplications). However, I would like the option of just being able to update the formula in the table and any queries base on that value will be changed accordingly...

Hello, I want to have a table describing the various field names that are used in a database. The data to be held in some of the fields are raw data but other fields will be calculations based on other fields. In my table "tblMyFieldNames" I would want to have two columns: "FieldName" and...

Not sure why it's doing it. I wouldn't be surprised if you didn't believe me and I could provide a screenshot if you wish. In cells A8 and A9 I have used the list properly. However in cells A10:A15 I have typed any old letters (i.e not in the list). Any ideas? David

Hi Skip, Just one thing - how can I limit the options to the resulting drop down lists? I thought this happened automatically but now users also can type free text (which I don't want). In my Industries dropdown I currently have...

Great, thank you very much. It works!

Skip, Thanks for your help. I'm just getting a bit frustrated because I'm sure I did what you said and I can't work out why it's working for you but not for me. I did have a Factory selected in SelectedFactory. I have changed my source for validation in A7 to...

Ok, it's not quite as I planned but: B2 is SelectedFactory Then there are a few rows of spaces. In row 6 I have my entry table column titles. Cell A7 is the first dropdown for getting the Industries available in the SelectedFactory. So this is where I have...

Hi Skip, Are you sure the following is correct? I seem to get an empty drop down... I thought you would only need OFFSET for this bit? David

Skip, I really am extremely grateful for this. Haven't yet had enough time to implement it but will let you know. Thanks David

Hi Skip, The initial three column list (Factory, Industry, Workshop) which comes from my database is about 400 rows long. Some Factories would have Industries that are also in other Factories but the combination between Factory, Industry and Workshop name would produce a unique Workshop. eg...

Hi Aceman, Thanks for your help but the form is now behaving strangely. I open the form by selecting a case from a listbox and pressing a button on a previous form. When the form initially opens the combo box allows you to change from one type to another without displaying the message box at...

sorry, I'm being a complete idiot - must be from being away from work for a while. Thank you both for your help.

Sorry, my mistake. If you open the form at a particular record then it seems that nothing is loaded into typOld and it does the message box as above. If however, you click yes you want to change it, then if you try to change it again it gives the warning as is required (i.e only when the type...

Hi Aceman, Just to confirm, it works when it is not a new record but if it is a new record it has the message box as mentioned a above. David

Hi AceMan, Thanks for your help but it is not working yet. My knowledge on Access is very patchy so you will have to bear with me. Every time I make a change to the combobox the message box appears saying So presumably typOld does not have an initial value. Should its value have been declared...