Search results for query: *

Thanks for the help! Zorro

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

Thanks gol4, I tried the first option you gave me and it worked great. I couldnt get the other 2 to work but one is all I needed. Zorro

I need to make a query that will show all results from 1 year from today + or - a week. Any thoughts? Zorro

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

Thanks!! That got me going where I need to. Zorro

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

Yes it looks just like that, then I pasted what you typed in place of mine and still I can type whatever I please. I don't get it. Zorro

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