Search results

Hi I have a form with 2 dates and a combo box showing the test frequency. Test date, frequency (6, 12, 18 24 months) and the retest date. I want to make a query to return the value after I have picked the test freq. How to do it? For instance, if I enter 01/01/04 and select the value 18...

I know that I have to create two tables, one for customers and the other for branches. The relationship will be one to many (one customer has many branches) in the second table I would like to see the company name instead of the company id. How do I go about this?

Please help with a function I have a field where I can enter the D.O.B details on a form. After I exit the field, it will then automatically update an unbound field with the age of the person. But the function must work out automatically the age of the person when increases by a year when it...

Help Needed!!!!!! I have created two forms; the 1st form is based on the customer’s business details known as FrmCustomers and the second form known as [FrmPATTesting] is based on Portable Appliances that the customer owns. There is a relationship between the tables and the relationship is...

Help Needed! I wonder if anyone could point me in the right direction? I am using Access 2000 and I am trying to achieve this task I have a Check box on my form and when the check boxed is clicked it will make a command button become visible. If I remove the tick from the check box the button...

Can anyone help!!!!! I have a table [TblApplicants], which has 5000 records of people's datails, which i do not want to tuch! On a form i have a combo box, which list's the [Surname] and the [First Name] in the row source properties. Is there anything that i can add to the row source...

Can anyone please help!!!!! I have a form where I have a text box called "Birthdate" Then another text box called "age". I am using this code Dim dbs As Database Dim rst As Recordset Dim lngdays As Long Dim dblYears As Double Dim datBirthdate As Date Dim intage As Integer Set dbs =...

Can anyone help!!!!! I have created a Combo box which has two columns, the second column is bound to a text box. Is there anyway that I can select the information from the two sets of columns in the combo box and then have the information entered into two different text boxes. HL

Help!!!!!! I would like to run a chart report from a parameter query. The query pull pulls data out of the table between two dates and this is working fine. In the query, the field's are Date and the Criteria is: Between [Enter Month Start Date] And [Enter Month End Date] the other fields I...

Please Help!!!!!!! I have created a database which works on information for a month, then at the end of the month it is transferred to a history table. What I like to happen in the header of the form is to have a text box which will covert the first date which is entered into the table for...

Help!!!! I am using Text box with this function in =DateDiff("n",[Equipment Start Time],[Equipment Stop Time]) The format is set to General Number Every time it calculates the time it leaves - sign in from of the number. Q: how do I stop this from happening… Cheers HL

I have two tables which are related on one form. The form is showing the data from the two tables which is great, but I have added a Cmd button for adding records for the two tables. When I click on the button, I have an error message coming up say at the end of the record set. and it will...

Hi I have a form with two subforms showing different information. The main form shows the company details, like company name The first sub form shows the contacts within the company, the two main fields are company name and surname. What I would like to do is when I click on a record of the...

Can anyone help me! On a form I have created a number of text boxes and a combo box which sends the date to the table. Also I have an unbound text box "Actual Down Time" which works out the down time between two times =DateDiff("n",[equipment start time],[equipment stop time]). The only...