Search results

I've read through a number of discussions in different forums on this topic, but there's something that I'm not getting to make my project work. So I'm attaching a sample to illustrate my problem. My goal is to count only those checkboxes that appear on the form to get the "total checkboxes"...

I have a continuous subform that has changing conditions of whether it will be controled by a date range or not; also whether all its checkboxes are selected or not. This amounts to a multitude of possible combinations. 1. All checkboxes checked with no date range 2. All checkboxes checked with...

Pat, Is there a link to the posting? I'd like to see the answer also. Thanks, PC

I did find the solution. When the UserID field is a text field, you need to enclose the value for it (which you pick up from the combo box) in quotes. If that value won't contain the single-quote qharacter ('), try this: strWhere = "WHERE tsubPermissionList.UserID = '" &...

Thank you for your reply, ghudson. I must be getting a little closer, but I get a little popup window Enter Parameter Value and there's a yellow highlight over Me.RecordSource = strSQL2. When I put the "I" bar cursor over the formula there's a correct value for strSQL2, but Me.RecordSource...

I have code on a subform that is referencing another form that is still open (not the parent form, but the form which's button openned the form that the subform is on). I'm trying to get the value from a combobox that contains the data that will filter the subform in question. See below...

Thanks again Travis, your recommendations worked. For others to see, I'm including the working code below. Tasks are not like e-mails, in that I don't see a way to send a BCC to my managers. Unless someone else has any ideas about that, this code is still correctly programmed...

I'm still struggling with this filter issue. This is my latest try. I'm missing something, because I can't get this to work. I hope someone has time to help me. ==================================== Private Sub btnUsersProjectCalendar_Click() On Error GoTo Whoops Dim strForm As String...

Thanks Travis, I'll adapt my code to your KB reference next Monday and let you know what happened. I'm away from the office today. PC

Thanks for your reply Travis, I'm trying to apply your recommendation to the code that your suggested and I have a few questions. If I understand your suggestion correctly, I changed the following lines: From: Dim OutlookTask As Outlook.TaskItem Set OutlookTask =...

I found this example in Outlook's VB editor's help on task assignments. Example This Visual Basic for Applications (VBA) example uses CreateItem to create a simple task and delegate it as a task request to another user. To run this example, replace 'Dan Wilson' with a valid recipient name. Code...

I'm working on a project tracking database for my manager and I've programmed it for sending out e-mail notifications, but after seeing this discussion, I'm wondering if Access can create tasks on other user's Outlook. It's possible to do that directly through Outlook, but I'd like to have that...

The corrected sort function and event code is as follows Sort Function Code: =================================================== Private Function SortOrder(col As String, xorder As String) As Integer Dim strSQL As String Dim sf As Form 'Set sf = Forms!frmMainEntry!fsubNotifications.Form...

After correcting the formulae in the calculated dates, I discovered that the sort function does work on dates. I will show you the errors in the formulae by displaying the before and after code. Before Code: ========================================== AdvancedNoticeDate...

I get an error on this statement at the "@" symbol. How can I correct it? =============== strSQL = strSQL & "[tsubPermissionList]![LastName] & "@mwdh2o.com" AS EmailAddress, " =============== The rest of the code is very lengthly and I can post it, if necessary. Thanks, PC

Sorry if you misunderstood my comments. I didn't mean to offend you. Please have a nice day. You may see my posting in other forums, because it increases the possibility of me getting an answer and there are seperate websites. PC

I think I've found the problem. In the query there's a calculated field AdvancedNoticeDate: DateAdd("ww",-2,[DueDate]) that gives an error when the [DueDate] is blank. It may be that the sort function is trying to sort on erroneous data (ie. #Error). I'll need a solution for the case when no...

That's the way it shows in the example I uploaded. I didn't use the date conversion and it still doesn't work. I used the format from the example first, then I tried the date conversion and neither attempt worked. Could that be a problem between A97 and A2K? I can't seem to trace the error...

I'm not sure what you mean. Can you clarify your idea? I'm attaching the sample that I found on the internet. I added the date field to show you my problem on the subform. Thanks, PC

I have a subform that simulates a listbox and I click on the header label to activate the sort. My problem is sorting by date. Below is the sort function and one of the date labels that I need to sort on. Sort Function:Code: ========================================== Private Function...