Search results for query: *

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

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 need to make a query that will show all results from 1 year from today + or - a week. Any thoughts? 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 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...

I have some code in my vb editor attaching a string of text to a chkbox. The code works fine but it looks nasty because its 3 screens wide in the VB editor. Is there a way to word wrap in the VB editor. This is just to make it pretty it works fine on my form. Thanks! Zorro

I have a combo box with the following code attached to a command button. Me!TextBoxFemScore = age.Column(3) + ldl.Column(3) + hdl.Column(3) + bp.Column(3) + Diabetes.Column(3) + smoker.Column(3) This is on the click event. What I am trying to do is add the data from each combo box together...

Has anyone typed up a list of the 50 states to use as a row source for a list or combo box. I hate to retype it if I can just copy it from someone. Thanks! Zorro

I have a data entry form(A). This form can be loaded in two ways. The 1st is from a search page which loads and allows data to be entered, this works fine. The second way to load said form is from another form(B). I have a command button to load formA from formB. The form loads displaying the...

I want to seearch my table and add a period to each text string that doesnt have a period at the end of it. Should I use a query to do this or does someone have a bit of code that would do it. I don't want to type 600+ periods. Zorro

I have a query that I qant to exlcude 2 text strings. I use the following. Not Like &quot;w*&quot; Or Like &quot;*chagrin&quot; It exlcudes the first but not the second. If I reverse their order it still excludes the first not the second. If I use <> its the same deal I can exlcude the first...

Are there advantages to using the MSDE that comes with Access over the standard MDB. From what I have read its a limited SQL server correct? I have a multiuser database with 10-15 users at 3 facilities run on our &quot;tempermental&quot; lan. Should I look into this? What are the drawbacks? Zorro

I am trying to learn VB and want to make a project to search a specific directory for doc files and when it finds the file with the correct name in the string it opens the file with word. I just unwrapped VB6 and got 2 nice books to reference. How would you folks start this? Zorro

How do I get a form to display a clock (more or less). I can get it to show when the form was opened but it wont update my time. Zorro

Whats the most efficient way to print 2 copies of a report? I have a command button to print my report and I made a second button to print 2 but I did it by sending the docmd... twice. This makes the query run twice to pull the data. Is there a way to tell the printer hey do this 2 times so I...

I want to be able to associate a picture in a table in my database with each entry. The same idea as what they do in Northwind for the employees. However I have 1 of 3 images I would like to be able to choose from. So if I pick image 1 from a combo box can I load that image into a bound frame...

I have an unbound image box on my form. Within the database is a table Images, inside is ID PEN (visit number to relate to other tables) ImageName Image (ole feild) I want to populate these fields from a table called tbllkupImageTmplt, within it are ImageID ImageName Image (ole feild) On my...

I have a multi site multi user access database and want to know if there is a way I can kick everyone off the database? I have gotten errors where the mdb needs to be compact/repaired and there are still people who left it running on their desktop and aren't around to shut the thing down. I...

I have a table with 6 fields that are check boxes, there is also a date field mixed in with some other things. I want to make a query that will give me a monthly total of each of these check boxes. Example -----check1----check2----check3----check4 June 1 5 3 7 That is...