Alphabetize church Name

[Dick7Access]

In data sheet view when I try and Alphabetize church Name I get this error.
What is it talking about and how do I fix it.

 

[LarryE]

I don't know what you did to get this message because you didn't tell us, but you can simply open the query in Design Mode and set the Church field Sort to Ascending.

 

[Dick7Access]

I don't know what you did to get this message because you didn't tell us, but you can simply open the query in Design Mode and set the Church field Sort to Ascending.

Sorry should have specified. Clicked down arrow in the church field, clicked sort A to Z

 

[LarryE]

ACCESS appears to be looking for a unique ID. Do you have unique ID's in all your tables? Are they Primary Keys? Do you have relationships established between tables? This error may be caused by many different things. If you could attach your database file, I can take a look to see if your design is proper to begin with. When I open one of my own forms in Data Sheet View, I cannot duplicate your error message.

 

[Dick7Access]

ACCESS appears to be looking for a unique ID. Do you have unique ID's in all your tables? Are they Primary Keys? Do you have relationships established between tables? This error may be caused by many different things. If you could attach your database file, I can take a look to see if your design is proper to begin with. When I open one of my own forms in Data Sheet View, I cannot duplicate your error message.

Thanks I will look into it.

 

[GPGeorge]

Thanks I will look into it.

I'll put money down on this reason.

That field is actually a Lookup Field and you set it up to DISPLAY the text value.

 

[Dick7Access]

I'll put money down on this reason.

That field is actually a Lookup Field and you set it up to DISPLAY the text value.

Thanks. I am looking at it.

 

[gemma-the-husky]

Can I recommend you remove the dbl quotes from the Church names. They will give you grief somewhere along the way.

You may be able to capitalize the first letter of each word by using vbProperCase. (if that's what you mean)

 

[Dick7Access]

Can I recommend you remove the dbl quotes from the Church names. They will give you grief somewhere along the way.

You may be able to capitalize the first letter of each word by using vbProperCase. (if that's what you mean)

thanks

 

[The_Doc_Man]

Hi, Dick. That error message is suspicious. From the looks of things, you opened a query to get that view, but it is talking about a VBA procedure. Can you show us the SQL that led to that displayed error? It thinks you have triggered a function of some kind.

 

[Dick7Access]

Yes, as soon as I can get back to it. I am trying to arrange meetings in Lewisburg, WV, Hallsville, TX and Greada

 

[arnelgp]

Godbless Pastor!
not related but curious?
i saw one Baptist church in the PH.
aside from that one do you have a name like Mandaluyong Bible Baptist Church?
i attend service there when i used to live there.

 

[Dick7Access]

Godbless Pastor!
not related but curious?
i saw one Baptist church in the PH.
aside from that one do you have a name like Mandaluyong Bible Baptist Church?
i attend service there when i used to live there.

No I don't but I would like any information on it you might have.

 

[arnelgp]

you can find the location here:
mandaluyong bible baptist church - Google Search
unfortunately i don't have it's history.
what i do know (based on what i heard) is more than 60 years old (or much older) and has been
a mother of many bible baptist all over the PH.
it is mission driven church.
and the first missionary who build the church was from baptist bible international (usa).

 

[NauticalGent]

I seem to remember seeing this issue a lot as well. I changed a setting and it seemed to fix it...

 

[Dick7Access]

you can find the location here:
mandaluyong bible baptist church - Google Search
unfortunately i don't have it's history.
what i do know (based on what i heard) is more than 60 years old (or much older) and has been
a mother of many bible baptist all over the PH.
it is mission driven church.
and the first missionary who build the church was from baptist bible international (usa).

Thanks

 

[Dick7Access]

Doc,
This is what I can find on your question
Correct me if I am wrong but isn’t a sql mostly in a query. If I am reading my code correctly the CMD that opens this form has no query. However while going over this code I discovered the property sheet for this form has the default view as datasheet view, and allow form view and datasheet view, yet when it opens from CMD it opens form view, so I have to manually switch to datasheet view. If I open the form from Navigation Pane it opens to datasheet view, so evidently something is changing it.

Private Sub cmdChurchesAllDick_Click()

On Error GoTo errorHandler_ChurchesAllDick

Dim strFrmName As String

strFrmName = "frmChurchesAllDick"

DoCmd.OpenForm strFrmName

Forms(strFrmName).Controls("lblSupportingCH").Caption = "All Churches"

DoCmd.Close acForm, "frmMainMenuDick", acformyes

Exit Sub

errorHandler_ChurchesAllDick:

MsgBox "An error has accured. You will be taken back to 'Main Menu. If it happens again" _

& vbCrLf & "try closing the program and re-opening it. If that doesn't work call Dick", vbDefaultButton2

DoCmd.OpenForm "frmMainMenuDick"

End Sub

 

[arnelgp]

you can change the code to explicitly tell it to open the form in Datasheet view:

DoCmd.OpenForm strFrmName, acFormDS

 

[Dick7Access]

you can change the code to explicitly tell it to open the form in Datasheet view:

DoCmd.OpenForm strFrmName, acFormDS

Yes, I know that, but most times I want it in form view. My problem is when I switch to datasheet group and then try to alphabetize it either A to Z or Z to A it will do it, but gives me the error code (see first post)

 

[arnelgp]

can't really tell why the error. would you be willing to share your table/query/form of that particular form?