Search results for query: *

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

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

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

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

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

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

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

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

I am trying to import a number of text files into access and my code seems to work fine, but only if the files have a .TXT extension. If they have another extension ie. 083, then it gives the error &quot;database or object is read-only&quot; and will not import the file. I have tried it with...