Search results

I have a form that includes to comboboxs populated form two table, the second combobox changes values depending on what has been selected from the first combobox, this is working fine. The problem im having is when i try to add a textbox and save the records, the records save by the textbox...

Rabbie i have changed the textbox name form date to datecompleted, i am adding a new recoird to the table, i want fill the date textbox in by default when a user adds a new record. Paul i have tried date() but it doesnt work, my code for this is currently: Me.DateCompleted = Now() Is there...

How do i format this date: Me.date = Now() To display only the date, not time etc

Thanks bob :), btw i noticed on the functionx website there are a list of different versions, 2000, 2005 and 2008, what is the difference in these, which one would be most suitable to get started with?

I would like to start and learn how to use sql server and im wondering if someone could point me in the right direction as to where to begin learning the basics etc

David you have uncovered a mistake in my patient table, a patient can have more than one toxin date as this will be different for each admission, thankyou for that :o. I have changed the table structure so that the dates are in the same table, no need for a table join now. Im assuming the...

David thanks for the reply, the patient id is the relationship in each table. The patient has a date for "positive toxin" in the patient table, the admission table has an admission date for the patient, i need to get the no of days between the "positive toxin" and the "admission date". The dates...

I need to join two dates from two tables, "Patient" and "Admission". I have Date from the "patient" table and a date from the "Admission" table and i want to calculate the number of days between the two dates, i think i need an inner join to join the two tables but im unsure how to do this. Can...

RuralGuy thanks for that, it solved the problem :)

Im having a problem with a form when i open it in Add Mode, i get an error "Division by zero", the error points to the line below in Form_Current: "Me.Q_Total = (100 / [Opp_Total] * [Action_Total])" Can anyone help? My database is below:

Sorted, thanks for that :)

I am having difficulty changing the format of a form textboxs to 1 decimal place, i have tried to change the decimal places option in the properties windows to 1 but its not formatting the textbox to reflect the change. Can anyone help?

I got this sorted, thanks :)

Brian i have added another field to the table and query called Total, i have added the calculation to the query which adds the indcount and the countaction together and it works fine, how would i add the Total calculation to the form?

Hey thanks for that, i totally forgot about the zipping the file, really appreciate your help :)

Im having a problem adding two textboxes that contain calculation value to a table. The calculations are inside two textboxes called "Total" and "Action". The form i am working on is series of questions and i need to calculate an overall percentage based on the user inputs at the end of the form...

Thanks for that brian, im having a problem with the formula, when i add another record to the database the formula add together the new record totals with the previous record totals. Is there anything i can do to stop this from happening, my test database is below:

I have this working, but the code same quite long: =Sum(IIf(Not IsNull([Indication1]),1,0))+Sum(IIf(Not IsNull([Indication2]),1,0))+Sum(IIf(Not IsNull([Indication3]),1,0)) Is this the correct way to do this?

Rabbie i want the output to sum both the indication1 and indication2 fields if they do not contain a null value, so if indication 1 does not contain a null value the sum is 1 then if the indication2 field also does not contain a null value the sum is 1, i want the two values added together to...

Sum IF NOT IsNull Help I have a formula for calculating value within a table field called Indication with the value "bef-pat": Sum(IIf(Not IsNull([Indication1]),1,0)) i want to add another field and to the formula, for example Sum(IIf(Not IsNull([Indication1] & [Indication2]),1,0)) I...