Recent content by jeds

The name property is Frame935 (copied and pasted from the other tab). I understand it would be good practice to name it something meaningful, I'm thinking it will not change the compile error. So would that mean there is something else in my design that is giving the desired end result over...

I had considered doing so, ended up with the 3 tables as I thought I could wrap my brain around it all better. With both you and Pat suggesting to put all in one table I may go ahead. I currently have an Active member status table with 14 different statuses just for the members of that...

I may not have set the sort order before importing, so here is another just in case jeds

mahenkj2, see if you can open this one. I have followed the instructions on: http://msdn.microsoft.com/en-us/office/cc907897.aspx The one thing I am not sure is that it says to "pick an Access 2007 sort order in the New database sort order list box", It was set to general, now I have it set...

WES9659, here is a tutorial on relationships I found useful. http://www.functionx.com/access/Lesson35.htm Lesson 34 and 36 are also on relationships. What you name the primary and foreign keys does not determine how they interact, but the names can be useful to keep track of the...

This is the db, I have removed all info from the members and life members tables as they contained personal information. The past members table only includes ficticious people used to test. Thanks, jeds

Happy Holidays! I have an option group on a form. It is unbound, but the form uses a query to pass the selected radio button value to a table with: [Forms]![RemoveMembers]![Frame935] AS Expr2 where Frame935 holds the option group I expect this is where part of my problem is as searching here...

So if you are not going to do any calculations with the data use text data type, correct? Interesting. jeds

When I run the analyzer on all object types it recommends to change the data type for field "zip" (zip code) to "long integer to: "benefit that table and potentially other objects in my database" The field type is currently set to text, And I have the same setting for the same field in a...

Thought I posted this earlier, but it is good now: Dim Member As String Member = [FirstName] & " " & [LastName] Beep If MsgBox("Are you sure you want to remove " & Member & " from the active member list? This cannot be reversed!" & vbCrLf & "Click Cancel to add a comment.", vbOKCancel, "Please...

jdraw, you're right :o mostly confused, but appreciate it. Stumped getting the value into the message box: Private Sub Reason_Click() On Error GoTo Reason_Click_Err DoCmd.RunCommand acCmdRefresh Beep Member = ([FirstName]) ([LastName]) Dim Member As String If MsgBox("Are you sure you want to...

Absolutely correct! And cleaner code. Thanks.

mahenkj2 - Yes! it works! Thanks! I did realize I needed to move it above the first query which appends the record to the new table, now it is working. You all have motivated me to change my sig. jeds

jdraw, great information in the links! I had started to come to realize I need to declare a variable for the response to the msgbox after spikepl's reply, your reply has made it a bit more clear. mahenkj2 seems to accomplish the same thing in a method that is simpler to me than using Dim, now...

Thanks spikepl; 1. The definiftions are frankly quite greek to me. 2. intellisense offered "vbOK" after the "=" , nothing more, but the editor did complain if I stopped there that it needed a "then" or "goto", hence the "then". That is all intellisense offers. 3.What I am getting from the help...