Search results

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

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

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

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

Hi Below is a sample database I have created, which allows me to enter people details and kind of work carried out etc. What I want to do is to have a button I could click for certain customers so next time we enter the same address it brings up a alert msg to say any custom messages...

How can i protect my database from being edited by any other users except me.

Hi I am trying to count how many record is displayed in a report. I have tried this formula on a unbound text box but it doesnt seem to work always comes up with error message. =Count(Address) or =Count(Name) and =Count(*) none of them seem to work

Hi Am having bit of problem, with the form below. Everything seem to be working fine but all I wanted it to do is to add up any prices I put down on the extraitem cost and add it to the total cost and work out the profit and soo on. i have attached the form below many Thanks

Hi Am having bit of problem, with the form below. Everything seem to be working fine but all I wanted it to do is to add up any prices I put down on the extraitem cost and add it to the total cost and work out the profit and soo on. i have attached the form below many Thanks

Hi I have few problems with this datebase I created below (attachment) . When I enter the unit number it calculated the price correctly but I have to put the unit number for all the items before it carrys out a total cost and profit etc. also if I change one of the unit number later on it...

Hi I know someone must have answered this question but I searched everywhere can't seem to find it here. 1. I got 10 fields with different prices. all I want it to do is add them all up in another field called total but in FORMS ( so I guess might need VB coding) 2.also I got three fields...

Hi, I just created a database for work, its got two fields on the form, item and Price. What i want it to do is when I enter the amount of item, I want it to automatically work out (price = £3.99)the price per item and display it on the Price text box on access. I done VB but cant remember...

Hi there Just a quick problem i need a solution to. I just created a database, but i want it to automatically created reference number for example. LAPSS001 n continue creating any tips pls?

Hi, Am creating a database on MS Access 97, I have got different prices for various items without vat, what i want it to do is, when i enter a value on certain item (without vat), i want it to automatically generate total value including vat. Secondly, i want it to total up all the items...

Hi i just created a database with people record and a second database which only contains the people record ref number and a waiting list number (which shows how far they r on the q. What i need to do is, i want the que field to generate numbers automatically from 1-onwards (but dont want to...

Hi i just created a database with people record and a second database which only contains the people record ref number and a waiting list number (which shows how far they r on the q. What i need to do is, i want the que field to generate numbers automatically from 1-onwards (but dont want to...