Search results

Thanks for the reply. I will look and see how to implement all of this over the next day or so.

Hi Guys Thanks for the replys. Im not to sure about the DMxa() function as I have not used this before but I can look into this. From what I think I understand is that I create one table for the main bulk of the information and one for holding the percentages. Would it then be advisable to...

Hi I am looking for the best way to create a multiple invoice system where a customer gets an invoice each month based on the percentage of work carried out. I have a table that records item, value, percentage, and percentage calimed. Each month the percentage of each item may change. I need...

Hi Wazz Thanks for all your help. You can get info from list box by following method: Private Sub Form_AfterUpdate() Dim lstdata As Integer Dim lst2data As Integer Dim lst3data As Integer Me.List10.Requery lstdata = Me.List10.ItemData(0) lst2data = Me.List10.ItemData(1)...

hi cannot load main programme as file size is too large. I have tried to compress it with winzip yet is still 1.4MB If you take my sample programme I would just like to see how the data is taken from the listbox to one of the unbound text boxes. Thanks again for all your help

Thanks Wazz That is really just what I wanted. I have now been looking at ways to get the info from the list box and am struggling still with this. I would like to be able to take the vales of shoes and put this in a seperate text box any ideas? Paul

Hi Thanks for that help. Only I'm reaaly new to this could you please tell me where I put the requry statement .

Hi I have attached a sample file to show what I am trying to do. This has one table, a query and a form. In the footer of the form I need the values calculated as to how many coats, shoes and hats there are. I hope this answers your question

Ok I been at this most of the day and I have got no where fast. I have a table with two fields [type] and [amount] when populated I have something like this hats 23 coats 33 shoes10 hats 18 coats 19 shoes 5 I need the individual sums of each of these records. for example shoes 15 I have...

Thanks for that. I was thinking along the same line but it is always reasuring to hear how other people would do things.

Hi I am creating a contact management database. I have set it up and now need to create an invoice section. An invoice needs to be issued every month and is worked out on a percentage of works complete. For example in one job there may be 10 items of work and for 8 of these iems 25% of the...

Hi Ken here is my simpe bit of code: Private Sub datev_Change() Dim db As DAO.Database Dim rst As DAO.Recordset Set db = CurrentDb Set rst = db.OpenRecordset("table2") Dim valdate As Date Dim newdaten As Date 'set some calculation to show that it works valdate = CDbl(Me.datev) 'Get date from...

Hi Ken Yes that is it I take the date from the first table then add x days onto it and store in the second table. This may happen a nuber of time where I just keep adding x days to the new date and I end up having y new records. These all have to be related to the id. Thanks

Hi I have created two tables which are linked with a one-to-many relationship Using a form the user enters a date. Then in VB I add a value to the date and store this in the second table. I have simplified this to try to find out what was going wrong and found that when the database adds a...

Thnaks guys This is what I was thinking. What is causing me a problem now is how this works as a relationship. I have a table contract setup and another one called valuation. from calculating the dates my valuation table is updated with the new dates but I do not seem to beable to reference...

Hi I have read a number of these threads now where it says you should not generate new records based on calculated fields. So can some one help with my following problem. I am creating a customer/contract database where when an order is created, a record set is generated to store dates for...

Hi I'm new to this but I did read somewhere that VB does not handle spaces in field names. You could try renaming field name not to include space.

fixed Solution to this problem was a simple bit of code re-write. Access dates handling is just like they say. Each day and part of is effectively a number and so calculations can be carried out in the same way as manipulating any other number. Just have to make sure your code is doing what you...

Hi I would like to manipulate some date information. I have a start date field and an end date field and I would like to draw up a schedule for payment where the Acess takes the finished date and the start date to get total days appart then devides this by a value set by the operator. say If...