Search results for query: *

I didn't realize access had a 1024 character limit. I broke up the query and created a union query afterwards to put the results together. It's kind of a long way of doing it. But it worked. Thanks for the posts.

Thank you all. I'm making all the names shorter and will see if that helps. Thanks again.

My query doens't work after the 13th IIf statement and gives me this message: "The expression you entered exceeds the 1,024-character limit for the query design grid". How can I resolve this issue? Thanks, SELECT IIf([qryJOE_REPORT_2.MaxOfEffortLevel]="4" And [qryJOE_REPORT_2.subscription_def]...

Thank you, it worked like magic. I appreciate your help.

I'm trying to update records to their appropiate weeks according to the week they fall in. It works till WEEK 13, after that I get a message that says: "Expression too complex in query expression" Can anyone tell me where this is breaking? Thanks. UPDATE SR_Status_Report SET...

Thanks for the help. I'll give them a try today. In the mean time, I created a few dummy records where there were no records just to make it work:-)

When ContactStatusID is null the code doesn't work. Private Sub Command85_Click() 'Open Pending Records For This Month Form.Filter = "[Rep#]=" & Trim(Me![Combo38].Column(0)) & " AND ([runmonth]) = #6/1/2004#" & " AND ([ContactStatusId])= 2" Form.FilterOn = True Form.Refresh End...

Figured it out if anyone interested. stLinkCriteria = "[Rep#]=" & Trim(Me![Combo4].Column(0)) & " AND ([runmonth]) = #6/1/2004#

I have a login form where sales reps put in their login name and password which opens a customers form. I want customers form to open with only a particular month's records for that sales rep. What I want to do is 1) Open records for the sales rep who is loging in. (This part works). 2) Open...

They are being updated. However when there's an update it does it for every single order not just that current order. It's something to do with the calculation code being applied to somewhere else, or somewhere additional in one of the forms events.

I have an order form where the changes in one record applies to every record. What do I need to do so if I update one record that update is just for that record not all the records in the form? The fields I have are: Subscription Code: (combo1, Unbound). Rep selects a record in here which...

Here's the answer to my own question. I figured it out:-) If Me![Combo0] <> 9 Then '9 = Admin stLinkCriteria = "[Rep_Name]='" & Trim(Me![Combo0].Column(1)) & "'" DoCmd.OpenForm stDocName, , , stLinkCriteria Else DoCmd.OpenForm stDocName End If

I created a login form that opens a main form. FRMLOGIN form is created from a tbl_Sales_Reps table. Fields in table are: Rep# (number), Rep_Name (text), Password (text). Fields in FRMLOGIN are: Combo0: SELECT tbl_Sales_Reps.[Rep#], tbl_Sales_Reps.Rep_Name FROM tbl_Sales_Reps - rep selects...

The solution was different. I just had to add the code to the Current tab on the form to make it work. Thanks.

This almost works. Private Sub Quantity_AfterUpdate() OrderTotal.Value = Nz(Me.Price.Column(1, Me.Price.ListIndex), 0) * Quantity.Value End Sub When I use this the same OrderTotal appears on all the records. How can I correct it? Thanks.

Thank you. But I don't think that's the answer I am looking for.

I want to calculate “OrderTotal” by multiplying “Price” by “Quantity” minus “DiscountPercentage” OrderTotal = (Price*Quantity)-DiscountPercentage -- Price is already populated in the form and is a text box. -- Quantity will be filled out by salesrep. (Should it be text box or unbound?) --...

Private Sub Combo8_AfterUpdate() If Me.Combo8 = "Call Again" Then Me.callagaindate.Visible = True Else Me.callagaindate.Visible = False End If End Sub This worked on a sample table I created. It won't work with the other table since there are more than one rows in that table depending on how...

It's not working and I can't figure out why!?

I tried this as you guys explained: It's not working and I think I might know why but don't know how to fix it. Call_Results_ID can't be "Call Again" because this is a drop down list as well and it's a number which is 8. So I tried; 1- Putting 8 for Call_Results_ID. Private Sub...