Search results

I have two queries (A and B) that are each pulling data from the same table. The only difference between the two queries is that query A has 1 parameter and query B has 3. For some reason, I can edit the results from query A in the datasheet view, but I cannot edit the results from query B in...

I have 4 columns in my table called Ovens: Last_Name, Age, City, and Clerk. First, I want to count the last names and sum them by clerk. Second, I want to filter based on a number I type (i.e., if I want to see the clerks with sums greater than 24, I only want the query to display sums of 25...

I have a table that I was in the process of cleaning up when I got the following errors: "type mismatch in expression" and "microsoft office access can't open the table in Datasheet view." What does this mean, and how can I get rid of these errors? Thanks.

I have an if statement that keeps giving me a parameter box that asks me to enter a C: Expr1: IIF(IsNull(TORRY.PAF) AND (TORRY.TYPE = “C”), (TORRY.USER_DEFINED), (TORRY.PAF)) What is wrong with my if statement...is it a syntax error? I cannot figure out why the parameter box keeps popping up...

I have a query called Spans1 that calculates the difference between dates: SELECT [Rasp].[Issue Number], [Rasp].Issues, [Rasp].Status, [Rasp].Date_Received, [Rasp].Date_Resolved, DateDiff("d",[Date_Received],[Date_Resolved]) AS Span FROM [Rasp] WHERE ((([Rasp].Status) Like "*" & [Enter...

I have a form that doesn't show all my records when I open it. For example, I open Access and then open the database. I click on my form to open it, and it shows no records. I know for a fact that there are several records entered into the database via my form, but the only way I can see them...

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

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

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

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

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

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