I have a table with visits entered and the date of visit. I need to be able to show the average number of visits per day of the week. We want to look at our data and see what day is busiest. I am doing this all in the query builder. When I use the SQL view I get this string if it helps at all...
Ok thanks for the input and suggestions I got it to work I forgot that the visit type was on a subform and had to code to look at the sub.
This forum is awesome, the folks here are more help than a dozen textbooks! Zorro
Ok I tried this but now when I fill in all the required fields I still get my msgbox. Help!
If IsNull(Me![Last Name]) Or IsNull(Me![First Name]) Or IsNull(Me![MRN]) Or IsNull(Me![VisitType]) Then
Response = MsgBox(Msg, Style, Title)
Else
DoCmd.close
End If Zorro
Well I thought it was working but you are of course right it only checks the last name. I want to check all four of the above fields and it anyone of them is null I want to get the error message, if they are filled in let the form close. Zorro
I am using this code to insure that required fields are filled in before my form closes. The check works but now I cant close my form.
If IsNull(Me![Last Name]) Or Me![First Name] Or Me![MRN] Or Me![VisitType] = Chr(32) Then
Response = MsgBox(Msg, Style, Title)
Else
DoCmd.close
End If
Any...
I have been searching the forums and according to what I have been reading it appears that calcultated fields do not activate the normal events when they are changed. I test this by making a calc field that is the result of 2 text boxes dividing box 1 by box 2 and when I change the values the...
Hmm this is funny.
I made a new form set it up the same way but now text3 is not calculated from other things on the form. If I do this the code works. As soon as I make it a calc feild it won't work after update or on change. If I put the code on the WMS field to run when it gets focus things...
Well I used me!WMS = me!Text3.VALUE in the after update, I made wms unbound and still nothing. No error but nothing happens when I modify the info in the calc feild. Zorro
Ok I tried this
Me!WMS.Value = Me!Text3.Value
Still no joy. I am storing this since I don't need the data to change in the future and will actually want to compare it easily to more calculated data later. Zorro
I am using access 2000 and I have an unbound calculated feild that I want to copy into a table.
I have created a bound textbox to the table and feild the data should reside in. I have tried the following code on the after update event.
Me!WMS = Me!Text3
Text3 is the calculated feild and wms...
I have a form where numeric values are selected from combo boxes. The values 0-4 may be chosen and an alpah character of "X" if none of the numerics are valid. I need to take these values add them up and average them. I want to ignore the fields containing "X" and also not...
I am trying to use the code show here to prevent edits when a form is loaded. I try putting the code on the forms open event but it doesn't seem to work. I even went so far as to tell the form
on load
me.allowedits= false
me.allowadditions= false
me.allowdeletions=false
But I can still edit...
The values are brought in with a query and I am making it zero width, I even tried making the hidden column wider to see it and that was a dud. I figure if I could set the combo with a line of code on the load event or something that may give me a clue on how to do it with my if then.
I...
The age is entered as one component of a formula. Some of the components are subjective so they cannot be set by code but rather by user input. The values are read from the non-subjective fields and I would like the to set the combo's to the appropriate values. Once this is done the dubjective...
I have a textbox that has a persons age. Based on that value I want the form to modify the value in an unbound combobox on the same form. I am trying to refer to the value in the first (hidden) column of the combobox. I keep getting an error object required. Any help would be appreciated...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.