Search results

i am trying to add one more piece of criteria to this syntax =DCount("fldmim_core_id","tblmimtplan","fldmim_core_id=1") the criteria to add is the value obtained from the combo box "Cmb_Grade" which is located on the same form as the text box that displays the DCount value

I had a problem with the Access (2000 Professional) "wizard" not working and just recently found the cure so I thought I would share it in case anyone else has had this same problem. There is a conflict of some sort with Access 2000 and the Small Business Tools (located on CD 2). The trick is...

Thank you both for replying... I am populating tbl_main with this form, population of this tbl consists of mission_id, soldier_id as well as several others...any other ideas???

I have a form that allows users to select a soldier from a combo box which assigns him/her to a specific mission...currently the user can assign any soldier to a specific mission numerous times..I need to prevent this from occuring....each soldier should only be able to be assigned to any...

thanks it's working now, but i have another problem will try to work it out....

I am trying to reference a field in an updatable select query (based on 3 tables) to a combo box on a form and i get this message "Enter paramater value" "Name" event procedure for combo box is shown below Private Sub Combo_soldier_GotFocus() If IsNull(Me.Combo_exercise) = True Then...

oh...ok.....thanks for clarifying......happy access'ing...big smiling teeth back at ya

my bad......i didnt look at the dates..was in a hurry..read through the first page of posts...didnt even notice there were other pages .....but calling me lazy...why so hostile....you have no idea how many rows i have hoe'd this day.... : ) be that as it may thanks for the link

please send me a copy too...thanks patricia.lynn.poindexter@us.army.mil

gracias mucho

will this code work with access 2002??

stay tuned...

the orientation seems to only break when i switch computers...one has access 2002 the other access 2000 could this be the problem???

i figured it out...at least this works for me...the following example is how i made the records sort in alphabetical order CmbWarmup.RowSource = "select fldtplanid,fldmimtplanlabel from tblmimtplan where fldmim_core_id=1 and fldlevel1id=" & Me.cmbNCTM & " and fldlevel2id=" & Me.cmbGrade order...

would you happen to have a sample of the code for this event procedure??

as of now i havent created the second table....the existing table is tbl_Level3 fld_Level3_id (key) fld_Level3 (memo) (with 7 addional fields) I WANT TO USE A FORM TO EDIT THE MEMO FIELD second table (not created yet as i was hoping to get some ideas before i made this change) my thoughts on...

Good day all, I have a table with several fields, one of the fields is set to memo...i need to be able to select a record from this table, edit the text in the memo field and then save (the actual edited text) in another table...keeping the original text in the memo field untouched ....so i...

will do...thanks for the advice

thanks for the information.... at this point with a near completed db would you suggest leaving the crytptic references as is or changing i know the changing is a timely task however, i dont want problems down the road.....

1. I have not changed the page numbers at all..however, they are the x of y style...report template was made from wizard, then i made changes i needed but did not mess with the page numbers 2. I made the changes you suggested (unchecked auto correct)but nothing has changed..report still as...