Search results for query: *

...State. The look up table has the following fields: StateID, Abbreviation, State The StateID field is the primary key. When I merge the document into Word, the StateID shows up rather than the Abbreviation. How can I get this to show the Abbreviation rather than the ID? Beth **Learning...

...donated in the previous years. What would be the best way to do this. I also need to purge the names that are not continuing the campaign into another table so we can mail to them later with seperate information. Any help in these two matters would be appreciated! Beth **Learning Access**

Jeff got it! :) I knew it was going to be something as simple as that also! Ugh! Thank you Jeff! Now I feel dumb, but that's okay. We learn from that sort of thing right?! :) Thanx for your help everyone! Beth Beth **Learning Access**

...with the correct report names. Yes I know that they are 0 based, and that column one is really column 0, which is the column that it should be. I also tried putting quotes, and parenthases, and different combinations of the two and it still doesnt work. **confused** Beth **Learning Access**

...reports. I am now getting the an error message when I double click on one of the reports in the box: run-time error '450': Wrong number of arguments or invalid property assignment. Can anyone help with this? Why am I receiving an error message and how can I fix it? Beth **Learning Access**

..."Microsoft Access might have encountered an error while trying to save a record. If you close this object now the data changes you made will be lost.Do you want to close the database object anyways?" It gives me this error, but the information is still saved. Beth **Learning...

...Value1 = Me.FIRST_NAME Value2 = Me.LAST_NAME Forms![Registration]![NAME] = Value1 & " " & Value2 End If Exit_cmdRegister_Click: Exit Sub Err_cmdRegister_Click: MsgBox Err.Description Resume Exit_cmdRegister_Click End Sub Beth **Learning Access**

...the "Register" button, but it give's me an error message "Does not have a related record in the Names table". Why is this happening?????? How can I fix it? We have looked at everything, and apparently we are looking over something. Can anyone help? Beth **Learning...

...and the PAID checkbox's are both set to true. The AMOUNT NOT PAID field should be the subtraction of the AMOUNT PAID from the TOTAL AMOUNT DUE. I am having trouble writing the code for this. Can anyone give me some suggestions or help out in any way? **confused** Beth **Learning Access**

...and the PAID checkbox's are both set to true. The AMOUNT NOT PAID field should be the subtraction of the AMOUNT PAID from the TOTAL AMOUNT DUE. I am having trouble writing the code for this. Can anyone give me some suggestions or help out in any way? **confused** Beth **Learning Access**

...the 'Registration' table is a number field. I have the relationship drawn from NAME ID in 'Names' to NAME ID in "Registration". It's a one to many relationship with referential integrity enforced. Why am I receiving this error message, and how can I fix it? Beth **Learning Access**

...DoCmd.OpenForm "Registration", , , "[NAME ID] = " & Me.NAME_ID End If Exit_cmdRegister_Click: Exit Sub Err_cmdRegister_Click: MsgBox Err.Description Resume Exit_cmdRegister_Click End Sub Where am I going wrong here? Beth **Learning Access**

Okay--now I got that code to work. I wasn't reading the code right. But, now i'm getting the message: "The OpenForm action was canceled" Suggestions? Beth **Learning Access**

I am still getting the same error message. This code works fine with a click event that I have on a command button on another form. I dont understand why it's not working here. Beth **Learning Access**

..., , stLinkCriteria Exit_GROUP_ID_DblClick: Exit Sub Err_GROUP_ID_DblClick: MsgBox Err.Description Resume Exit_GROUP_ID_DblClick End Sub I keep getting the error message: "Syntax error (missing operator) in query expression" Help? Beth **Learning Access**

I have a table with several fields, but the one's in question are: NAME ID, PREFIX, LAST NAME, & SALUTATION I would like to fill the SALUTATION field by using the PREFIX and LAST NAME field--how can I do this? Beth **Learning Access**

This was GREAT!!! It worked perfectly! Thank's for the help! Beth **Learning Access**

...My problem is that each time I try to put in any code, it debugs because of the preceding 3 or 4 letter is not in the list box. (lst, lbl, cmty, or otr). Can someone help me with some code to be able to double click on a selection in the list box to preview the report? Beth **Learning Access**

...know that we are putting the conference on, then people will register. At that time some people will register in groups. We will probably set those groups to about 5 or less. I want to find a way to capture these groups together in the database as well as separatly. Beth **Learning Access**

...people. I want to be able to capture those groups as well as each person individually so at the registration desk at the conference if they come seperatly or if they come together--either way the registration will be quick and less painful :) Any ideas would be helpful! Beth **Learning...