Search results for query: *

Thanks, I had not thought of using TOP I need to go away and ruminate over this. Thanks for your help. Dax

Thanks for the feedback... I have studied your suggestion a bit, and I can't get it to work because the same calltype can apply to different plans but at different rates. But you have given me an alternative idea, something like this... tblCallPlans PlanID PlanType Plancode Desc Indate Outdate...

You are correct, I realise that it does create an opportunity for integrity errors. Something I hope to avoid through the use of forms which will automatically fill in the additional field with the same date. You notice I did say it was a way of checking the integrity, not aiding it. Which is...

Hi I need to be able to price calls made by phones. The way that I am doing it seems to go against design principles but I can't come up with a better way of doing it. I thought maybe someone here could point me in the right direction. Each call record tells me what type of phone is making the...

That is a good point... I do find it useful having the outdate for 2 reasons: 1) If I need to select the applicable record for a specific date I can just select for indate < date and outdate > date. 2) It's a good way of checking the integrity of the database, because if an indate does not match...

Hi I have a fair amount of experience with databases. I am currently redesigning a system in Access for tracking and billing phones. There are some things that I would enjoy some feedback on. The first is the question of dates. Phones change their status over time, so I have a table with the...

I don't quite follow what you are doing there. In the interim I have worked out that I can display the form by saying me.subform.form.allowadditions in the addnew button of the main form. There are some small issues I still have to work on but I am sure I will be able to sort them out. Thanks...

When I go to a record on my main form that has no related records in the subform recordset, the form does not display. This obviously happens when I add a new record to my main form as well. I need the subform to be displayed though, so that I can add a related record. Any ideas? Villan

Thank you... I suspected that there might be decimals hiding somewhere and I guess I should have thought of using round myself... it works fine now. thanks for your help Dax

I have a table with telephone call records. One of the fields has the price of the call and another contains my calculated price (to check that the charged price is correct). I have a query which subtracts the one from the other and is supposed to show me those where the diff is <> 0. So that I...

Thanks for the response. It seems that dates do have to be in American Format when using SQL in VB (according the the Access help). Thus I am using FORMAT and it is working well. Thanks Dax

What is the story with dates in SQL? Do they have to be in American format? if so, how will I convert my dates in my fields to that format when I construct queries in SQL in VBA code? thanks dax

Excellent.. thank you very much the AutoIndex thing was def the problem... any ideas on the second part of my question? where my loop through the index collection is not deleting all the indexes.. here is the code I use For Each Ix In td.Indexes td.Indexes.Delete Ix.Name Next Ix thanks dax

I am importing a text file using a file spec. When creating a file spec in Access there is an option to specify for each field whether it should be indexed or not. I specify that none of them should be indexed, and yet when the file is imported it ends up with at least 3 indexes. So I loop...

Thank you, you were absolutely correct. Could you tell me now, why it does not delete all the indexes? After running that code I drop all the columns from the table and it gives me an error bcos there is still an index on one of the columns. I also am bamboozled by the fact that it creates...

Hi could someone tell me why the following code gives me the error &quot;object does not support this funtion&quot; Set td = dbs.TableDefs(&quot;St12InvTemp&quot;) For Each Idx In td.Indexes td.Indexes.Delete Idx Next Idx I am trying to delete all the indexes from...

Thanks for responding Joe Miller, but I think that you have misunderstood what I am trying to do. you see, a call type does not have a selling price. A priceplan has a selling price for a call type. so to ascertain the price of a call I need to look up a table the intersection of...

This is a bit cryptic for me, I haven't been able to solve this yet. THe one solution I could do would be to loop through the databse and assign the result of my function to each record. However I am sure there must be an easier/quicker way. People must do two dimensional lookups all the time...

Can I use a function that returns a field name as a field name in a query? I have written a function which selects the field and returns it but when I use it as a field in the query I get an error 'Undefined function in expression' any ideas? Thanks dax

Hi everyone I need to choose a field of a table based on the value of another field in a query. eg. Name Call type SellPlan Sellprice Sell price comes from a table which has the different call types as fields, so I need to take the call type from the second field of the query to tell...