Search results

The easiest way would be to create your query and in design view click the "totals" on the design ribbon. In the [points] field Instead of "group by" choose "sum". this will give you your total points. To get the dates you need, you would have a date field in the query as well. In the...

Thank you for your patience! This now works. :) You are a genius!

Allow data entry was already set to yes.

No pressure. I don't mean to be a pain. I did save it down to 2003 but can definitely wait. thanks again.

okay, thank you for being so patient. The dbase it attached now.

The message box showed the employee name is being provided for the search. I've been trying to attach a zipped file of the dbase or parts of it and its too large no matter what i do. Its down to the bare bones, just 3 small tables and the form. Any suggestions, what can i do to best...

I changed all the controls to be bound except for the combobox I am searching by and added the combo box i am searching as a bound control so both exists. I still get "record does not exist." my form is bound to the table it is pulling from and needs to save changes to. Any more suggestions?

Thank you so much. I fixed that and then when i make a selection from the combobox i get the message "that record doesn't exist", At this point all of my controls are unbound.

Thank you for such a quick response. I used your code and the debugger stopped and highlighted ".Close" the Compile error is "Invalid or unqualified reference."

I have a form [Emp_Edit] which lets you search for a record and then edit the fields it returns. I cannot get this form to save the changes. I get the error “The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or...

Hi Mark, I think the easiest solution would be to create a subform to show your history details and then add this macro to your button's "on click" event; Action: SetProperty Control Name: name of your subform Property: Visible Value: True

This is an update. I figured this out myself today. I changed the list boxes to text boxes. Used a query for the first combo box that includes all of the fields from the Emp table that I want to display on the form. I chose the Employee Name field as the bound column, set the column count to...

Thank you for taking the time to help me so much.

I sure appreciate your help! I have just a couple questions. The form works fine to add a new class until I try to add more than one in a session. The error debugger goes here: DoCmd.OpenForm "frmManageClassesTaken", , , , acFormAdd, , Me.txtEmp_ID and then when I choose a class I need to...

the Classes_taken table is set as my form's record source. I haven't set the default value for controls on the form and I'm having a hard time with the form loading blank like i need it to. Right now it saves a new record that is blank. Unless after you make selections, you go back and just...

Me. B, Classes_taken is the table i want to save the record TO The combo box source tables are Emp and Class_Catalog I have it to where after making your selections, the record will save to the Classes_taken table only when you click in the fields you want to be saved (even though they have...

I have a data entry form that contains 3 combo boxes and 2 list boxes. I want the selections to be saved to a table named "Classes_taken" (This is what I have set for my form record source). There are two tables used to populated the combo boxes and list boxes. They are "Class_Catalog" and...

I am using MS Access 2007 and importing from MS Excel 2007. I have a query that has some calculations and these calculations are built on other queries. This query runs great, the only parameters are BETWEEN[Begin]AND{End Date]. The problem is when I imported 78 records, the same way and...

I am trying to do the same thing. On a form I have 3 controls. They are all bound to the same table and all in text boxes. I have the field named [txtLton] calculating as one of the other fields divided by the other. It calculates beautifly and stores in the table but the problem is I don't...