Search results

Oh yeh. I didn't explain dates. All invoice payments are for periods i.e.from date to date. From there I work out daily costs. I then have a daily cost per unit and if we can indicate costs that are higher than average then we can check the apartments for water leakages, gas leakage or...

Cost accounting reply Thanks Curtis. Thats exactly what I am doing. I am fairly new at the VB (yes another one) but I am getting my head into slowly. I tried to igure the running balance scenario but any code you may have would be helpful. I work out days between dates by linking the text box...

I am not sure how to do this? I have a table>Form that I input a payment. That one payment is on one bill but it represents many various properties. I.E Gas payment=1 bill but applies to 13 different properties (Group account that groups properties) I want to be able to enter the payment on a...

Update Combo box through Entry Form Thanks RG. Perfect and was exactly what I was after. Now I have to work through it and try and understand it all. You guys make it look all so easy. Until next time. PR- Oz

I have a form that lists all my properties that we manage. I have a combo box that lists the property owners(landlords) I have found and adapted some code that when you add a new landlord that is not in the list it asks you if you want to update, This code works very well and does a requery...

Hi Dsigner1 - wisdom always prevails. I have spent a lot of time already trying to find programs etc so what you suggests sounds like experience. I will follow you suggestion and then down the track if I have time look at VB - Maybe a good retirement pastime. All the best - Thanks

Paul NB - Thats me in the header of the post (i.e Paul) - i will get use to this soon Thanks.I have forgotten most things but by normalising I think you mean setting up the tables with no duplicates and primary fields (id's). My tables are pretty good, but I am getting stuck on stupid things...

Hi David- I agree with George W. (not bush) I am in the accommodation and travel business and software runs everything we do from reservations to GDS. Sell a yearly license to the user and with that offer a limited say email support for another charge or make it inclusive. Also suggest that...

I am trying to figure out a way to set up an application that handle cost management of our business. We have serviced apartments and when I get a group bill say for electricity I want to record it as one payment but for different apartments,billing days,etc. Then have reports that give me daily...

Thanks Bob.

Thanks for reply missing.... Thanks for that. I used the code instead of the macro and checked the properties and it works fine. I am teaching my self again as I use to write applications in dBase iv back in the 80's, and havn't programmed anything since except a few bits and pieces. Its taking...

I am pretty new with this so pls excuse ignorance. I have designed a form based on a table. I have used a macro to go to a new record(append) when form is opened. Trouble is after I open form the navigation buttons on buttom will not move between records as if it is locked. I searched forum...