Have you changed the SCALE property in the general properties tab?
It needs to e set to 3 to give 3 decimal places....
VALIS
Last Activity: Nov 6 '06, 01:49 PM
Joined: Oct 17 '06
Location: Manchester, UK
-
A couple of questions
If two rounds have the same result for the rebate do you need to record this in the result?
Are there going to be move rounds?
If there are only 3 you could use a nested IIF statement to get the result in a Query.
Any...Code:MaxRebate:IIF(AND([Round 1]>[Round 2],[Round 1]>[Round 3]),[Round 1],IIF(AND(([Round 2]>[Round 1],[Round 2]>[Round 3]),[Round 2],[Round 3])
Leave a comment:
-
You won't need to write any queries.
If all the tables have 8 fields all you need to do is change the record source of the controls to reflect the fields of the table selected.
Dim ctl as control
For Each ctl in Myfrm.Controls...Leave a comment:
-
Julie
There needs to be a common field - PatientID?
Your report needs the following as it's control source
...Code:SELECT [QryPatients].PatientID, Max(QryPatientResults.TO) AS MaxOfTO1 FROM [QryPatientsResults] RIGHT JOIN QryPatient ON [QryPatientResults].PatientID = [QryPatients].PatientID WHERE (((QryPatientResults.DateVisit)>Date1 And (QryPatientResults.DateVisit)<Date2)) GROUP BY
Leave a comment:
-
Do the other fields update if you tab away from the list box?
(The form will only update once the list box loses focus unless you have some event driven code behind it.)...Leave a comment:
-
Mel,
Are the 8 fields common to all the tables?
If not, are there always 8 fields in a table?
If so you could have a generic form with 8 fields.
Your code could change the controlsource property of the form depending on the selection.
If the field names are different for each table you will need to right some code looping through the controls collection to change the control source of each cont...Leave a comment:
-
Is there a date field in your table?
If you're looking to show a weekly total you could create a control with something like the following as the control source
This would display a last 7 days total...Leave a comment:
-
Can you be more specific. Do you mean the tab order for instance? If you do then all you need to do is right-click the form in design mode, select "tab order" and you can re-order all your controls....Leave a comment:
-
Is there any coding associated with your form? ( I assume there is since you mention you're using a LABEL to input ) If your code deals with searching for the typed entry in the table it might need a requery statement....Leave a comment:
-
Hi Sandro997,
Is SetUserGroupCri teria used anywhere else?
If it isn't it might easier to refine this than mess around re-formatting the text string. Could you paste the code for the function SetUserGroupCri teria()?
Thx...Leave a comment:
-
Agreed. I was dealing with a problem that didn't exist. The problem was the test not the code. Doh!...Leave a comment:
-
Hi,
This might not be very orthodox declaring varBirthDate as String would avoid the ambiguity with the date format....Leave a comment:
-
Do you save the table and refresh the query before searching for this new record? If the form or underlying query behind the control isn't refreshed access won't register the new entry....Leave a comment:
-
Doesn't Me refer to the current object executed?
If so you'd be opening and closing the form almost instantaneously ?
What happens if you step through the code?...Leave a comment:
-
j0rdanf1,
Yes it is.
How are you searching for the user id? Are you using a combo box?
If so you could use the "On Not In List" event to update your listbox.
This will update the underlying table being used as the recordsource.
There's an example in the Access Help files for the NotInList Event.
Or you could send more detail?
Regards,
VALIS...Leave a comment:
-
You might need to load an add-in msowcf.dll.
Can you use ASIN() ?
If this works then 2*ASIN(1) = Pi...Leave a comment:
-
Try typing a version of the following in the SQL view of the query.
You need to substitute your table name and field name for tbl & Field.
SELECT tbl.*
FROM tbl
WHERE (((tbl.Field) Is Null)) OR (((tbl.Field)=" 0"));...Leave a comment:
-
Try the YEARFRAC function ( See Access Help )
YEARFRAC
Calculates the fraction of the year represented by the number of whole days between two dates.
If this function returns the #NAME? error value, you may need to install msowcf.dll.
Syntax
YEARFRAC(start_ date,end_date,b asis)
Start_date is a date that represents the first (or start) date.
End_date...Leave a comment:
-
How about using =Ceiling((now()-#01/11/05#)/7,1)...Leave a comment:
-
Try typing the following formula in the control source
=Now()-Weekday(Now(),1 )-2
This should give you last Sundays date....Leave a comment:
No activity results to display
Leave a comment: