Search results for query: *

It's a straight statement. Here's the part of the WHERE that references the controls. ((CSP_T_Opportunities.OwnerNew)=[Forms]![F_Prt_ClientStatusRep]![txtOwnerFilter]) AND ((CSP_T_UserNames.UserClient)=[Forms]![F_Prt_ClientStatusRep]![txtClientFilter])) Thanks for taking a look at this!

I have an option group on a form that is meant to filter a report. The SQL in the RecordSource refers to a control on this form. I get the report to run fine with the radio buttons that only filter by one criterion, but I can't when I need multiple criteria. For Example, Option1 puts a number...

I ended up killing the ost and letting outlook rebuild while the user was at an appointment. It seems to be working now. Is there anything in particular that would cause this, or can I just chalk it up to a random bug? Thanks

I guess I should say everything else seems in normal working order, still doesn't sync the inbox. Thanks

It does show online, and everything seems to be in normal working order. Thanks for taking a look at this.

I have two users whose Outlook Inbox suddenly stopped syncing with the Exchange server. They both use Outlook 2003 in cached mode and we use Exchange server 2000. The other seven users' Outlook works fine under the same setup, and these two users with the problem had worked fine up until this...

Thanks a lot! I'll use that, I've got a few more forms to fix in the same manner.

Thanks so much for putting me on the right track! Just had to revise a little sintax: Set rstident = db.OpenRecordset("Select @@IDENTITY as ident") maxnum = rstident("ident") Thanks again!!!

I have a form that creates new records in which the ID needs to be inserted into another table. This form was working fine until we started using replication. I took the easy way out and used the Max() function to get the newest entry. My question is, is there a quick way to get this...

I found the solution to my problem. And, as I suspected, I'm an idiot! Turns out the table had long date format and the Date Picker control had short date format. I guess I just needed a little food to spur my brain! Sorry if I wasted anyone's time.

I know, I shouldn't mix ADO and DAO. It really just stems from me piecing this together from other modules and I havn't gotten to the point where I go back and "clean-up" yet. Thanks for pointing that out. I should also say that the "DatePicker" control is the MS Date and Timer Picker. Would...

I'm appending data from a form into a table. The code works fine without trying to add the date, but when I try to add the date, I get the syntax error. CODE: Private Sub cmdTarget_Click() Dim strSQL As String Dim strSQL2 As String Dim db As DAO.Database Dim rs As DAO.Recordset Dim rs2 As...

I have a New Call form that creates a new Activity and has a subform to enter in details related to this activity. I'm trying to get the subform to list active opportunities and be able to enter details for each opportunity for the particular Activity at hand. tblDetails ----------- ID...

No, but Access would make it seem that way since the innermost subforms are loaded first. I was mistakenly trying to pass the autonumber from the main form to the subform before the new autonumber was being created.

I have found the solution to this problem, I should be more careful! Sorry for the waste of space.

I realize this... that was the problem. I needed this new autonumber that gets created from the main form to be a value in the subform's new data entry field. This field is the link between the subform and the main form. I realize that when the form is opened, the subform will have zero...

I get this error when invoking the click event from the subform. This is the code in the click event. Me.txtActivityID = Forms![Fmast_ContactTabs].Form.CSP_T_TeamActivityLog_ID Forms![Fmast_ContactTabs].Form.subDetails.LinkChildFields = "txtActivityID"...

Sorry for being confusing. With the innermost subform being loaded first, the autonumber of the mainform (that gets created for the new record) doesn't happen until after the subform is already loaded. But I need the new ID number from the main form to relate the Details to the Task. Again...

I have a data entry form with a subform. The main form is used to enter the Task information while the subform is used to enter and list specific details associated with this new task. The subform is a continuous form that will not show any records at first but will allow new details to be...

That's what I'm looking for! Thanks a million!!!