Search results

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

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

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

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

Each button runs a query and I have got the first button to display the query results in the bottom of the split form. Private Sub UpdateSignIn_Click() On Error GoTo UpdateSignIn_Click_Err DoCmd.RunCommand acCmdRefresh DoCmd.OpenQuery "SignInOrderSort", acViewNormal, acEdit...

1st post, read the "how to post" stickies...ok, breezed through them. I currently have 4 saved queries. When I start a select query, or use the query wizard, only my table are available. Asking for future reference, I simply expect that at some point I am going to need to "query a query"...

Guess you could say I'm an amateur at Access. I have been self-teaching for a couple of months, got interested as I am a member of the local volunteer fire department where we store a lot of data and many times it is done repetively. Decided to join the forum as I have ended up here many times...