Search results

I have a table with 3 columns: name, id, and stamp. I want to count the number of times the person's name appears in the table and display only the ones that appear more than 3 times. This query seems so simple, but it only shows me 3 people when I know there are many more. Also, the query...

Ok. Thanks. I have to play around with your code to get it to work...it keeps giving me errors for some reason.

Ok. Thanks for the help. How would I switch my code from hard-coded user names to a table with user names?

I want to add another user name to the following code, but I am not sure how. For example, I want to add "joesmith22" so that either joe or mwilson can edit the field. Can someone help with the syntax? Thanks. Private Sub txtDate_Received_GotFocus() If Environ("UserName") = "mwilso1" Then...

Thanks for the help. Everything works just fine.

Okay. Is it possible to just have the first part of the code? My form only has 3 fields, none of which is a record ID. My thinking is that once a person logs into Windows and opens my form, he/she would only be able to fill in certain fields. Thanks in advance. Private Sub...

I have 2 questions about the If statements. For the If Environ("UserName") = "Joe" statement, is "UserName" suppoesed to be a field on my form? Also, for the If Len(Nz(Me.Text6)) = 0 statement, what is Me.Text6 supposed to be?

I have a form with a date field (Start Date). I want to limit who can enter/alter a date once it is entered...for example, Bob, Joe, and Jane all use the form, but only Joe should be allowed to change it.

I have a form with a combo box with 3 columns visible in the drop down list; however, when I select a choice from the drop down list, I only see one column in the box on the form. Is there any way to show all three columns in the box once I have made a selection? I changed the column count to...

I made the changes you guys suggested, but I now get an error on the line below: Set rs = CurrentDb.OpenRecordset(strSQL) Any idea as to why?

I have a form that has several fields, one of which is called Pro_ID. I would like to use whatever number is entered in that field to run a query that fills in the rest of the fields with information associated with that Pro_ID. The code below is what I have so far, but it does not work (I keep...

Thanks. Everything seems to work except that a dialog box comes up asking for the region every time I click on a choice in the region list. Any idea as to why that is happening?

I am trying to update a listbox based on another listbox. I have the following code, but I am not sure why it is not working. Ideally, I want to be able to make a selection from the Region listbox and have the CTB listbox update with the relevant choices. Any help is appreciated. Private Sub...

One more question. I want to add a dialog box that asks the user for a school id. Based on what is entered, I want the information associated with that id to fill in on the form (i.e., school address, principal, phone number, etc). How would I go about doing that?

Thanks. That works fine.

I have a form that has a list box with states as options. I have another list box on the form that has schools as options (I use a query to get the schools). Based on the state chosen, I want the schools listed in the other drop down to appear for that state only. The name of the table for...

Well, the info is nothing that needs to be kept private. I just want the user to be prompted to enter an ID because it is a unique # and would be easier than prompting for anything else.

I want to create a form that prompts the user for an ID and then fills in the form with that person's contact info. However, I do not want to use a drop down because it would be far too long. Ideally, I want the user to be prompted for an ID, type in the ID, and hit enter. The next form to...