Search results

At Last I have sorted out the problem!!!

Ok I have lost the plot on this one. Ok I have created the query. I have pulled the company name from the tblcompany into the query and saved the query as qrybranch. I have created a form and have used a combo box to choose the data from. When I add a company name I would like that name to...

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

Thanks charityg for the info. I do know about the ascending fields that you can use in a query to put the two set of names in order. But in this case, I was trying to get the information which sits in the combo box straight from the table, then sorting the A ~ Z order in the row source or...

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

I had this problem the other week, when I was trying this statement (=DateDiff("n",[Equipment Stop Time],[Equipment Start Time]) in an unbound text called Actual Down Time to a field name in a table called Actual Down Time without any success. So I set up a bound text box [Actual Down Time]...

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 Jo You will be able to get 5 tables on to a form without having to put into 6 subforms. Then you can install the last table as a subform. One nice way of presenting data on a form is by using the tab control and build up the pages then by dragging the information down from the field list...

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