Search results

I'm stuck and I usually can find an answer, but I don't work with reports often. I need to ask the Pros here whether it's possible to group Area by the following: Dim str as string str = Left(Area Field, 2) Select Case str Case Is = "11", "12", "13" Report Group Area = "Division 1" Case...

I have a problem. I need to take the newly created table column (Field) I had just name "ID" and PRIMARY / INDEX it. I have tried several ways with no success. All I'm asking is for someone to offer a fresh perspective. ~ Shaw Public Sub OrcleJEtoUnmatched() '---DONE--- Dim db As Database...

Question: Frm "Match Summary" isn't bound to any Records (Table, Query). TxTBox "Parameters" is unbound as well. I need to give the End-User an ability to add information to Table "Parameters" My VBA Solution: Since Frm isn't bound, [DoCmd.GoToRecord , "Parameter", acNewRec] won't work. My...

I need to be able to return a recordset or filter out the line item data having B22, B02, etc. I can't do [NOT LIKE "*B22*" OR NOT LIKE "*B02*"] because of the double FALSE is TRUE Problem. Does anyone have an idea? _____________________ Field 1 Journal Entry Description...