Search results

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

Using Access 2010. I need to run 2 queries with a command button, giving the user the option to cancel out. Private Sub MoveToLife_Click() On Error GoTo MoveToLife_Click_Err DoCmd.RunCommand acCmdRefresh DoCmd.OpenQuery "MoveToLifeQ", acViewNormal, acEdit Beep MsgBox "Are you sure you want to...

Update: Save form data and clear fields At this point I have my form working by working around the error message (changed the message to "success"). And to close the query I have added a close window command to the macro for the command button. Unless someone can tell me I am creating...

joncue, if you create a new form and go to layout view, then click "Add Existing Fields", you can drag or double-click the fields you want in your form. Depending on what you have for tables, you may need to have relationships between the tables. This is offerred by an Access newbie, but...

Thanks Pat. It's almost working except for 3 things: 1st, the navigation bar will not be in the end user interface. It is not obvious enough to not make it evident that they need to go down there in order to go to the next new record, and we can place command buttons on the form to make it...

I have built a form to enter new members and add them to the members table. The record source for the form is a query that pulls the fields from the members table (name, address etc.) that I need for each new member, where the first field value = null: AddNewMemberQ: SELECT Members.LastName...