Recent content by abz_y2k

Hi, not sure if am in the right forum. I have created a database which contains customer details and type of work they have requested to be done. What i want is to add a diary/notepad so i can record correspondence and any updates on daily basis. So I have records of all corresonpondence and...

Thanks mate, its sorted !

Morning all Hope someone can help me with this query. Sorry if I put the post on the wrong section. I have created a database on access 97 (that's local authority for you 13 years behind) at work. What I want to do is to put a VB code on the database for a particular date (25th Dec 2010) so...

any suggestion?

how would i do that?

Re: vd code for calculation from single text box Hi i have attached the sample database am working on. What am trying to do is to sum up all the window locks fitted for every records. So when i eg: enter 6 windows lock fitted for abs, it should show up on Total lock fitted text box. And when...

Re: vd code for calculation from single text box Any advice anyone?

Re: vd code for calculation from single text box The database is on access and coding am doing in visual basic

Hi Can anyone please guide me how to carry out this simple task I got a database with record and total spend for each record. I want the total to be summed up in another text box to display the total i have spent so far can anyone please help

Hi I just created a database, which is on shared drive . Users enter detail of any cancellation they like to request (eg name address etc) Once the detail has been entered I want someone with authroity to aprove the cancellation. So what i want is to have a button on the form (Approved) by...

Hi I just designed a database for personal record. i want to add notepad to the form so i can add any notes/information when required regarding any person. and when I enter any additiona notes i want it to automatically put date next to the note. so if we look back after 3 weeks we know when...

Hi Can any one please tell me how I can set the "match" criteria on find button to "Any part of Field" all the time using vb code, without me having to change it all the time Help would be greatly appreciated

Hi Can any one please tell me how I can set the "match" criteria on find button to "Any part of Field" all the time using vb code, without me having to change it all the time Help would be greatly appreciated

Hi pbaldy I tried exactly what you said but it keeps giving me the same reference number everytime i enter a new record hps0766

I have this code below to generate custom numbers Private Sub Address_AfterUpdate() Dim cw1 If NewRecord Then cw1 = Nz(Right(DMax("[Reference]", "Table1"), 3)) Me.Reference = "HPS" & Format(cw1 + 1, "000") End If End Sub but when it reached 1000, it wont add any...