Recent content by villan60

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