Search results for query: *

I have a monthly report which lists the calls made by reps to customers. The report shows the days on which these calls were made and the number of calls for that day by that rep. I would like to sub total the calls by rep as shown below: 06/02 Rep 1 1 06/14 Rep1 2 06/24 Rep1 1 06/30...

Duane (dhookom), It Worked!! Thanks a lot, your help is very much appreciated!! mrkshpntf.

I have a simple report which displays results of a query. I want to number the results in a sequential order like numbering items on a list. I have added a text box to the left of the report to show the numbers. Thanks for your help, mrkshpntf.

I am trying to write a query on a single field(column). The query is supposed to count 4 different types of contact methods Email, Phone, Fax and USPS mail used in a specified time interval. The table is a simple three-column table (created from a larger table with other data). The three...

crowley16, Thanks for your response. Can you please explain what 'emp' and 'ctl' represent? I can understand your code but am a little confused about 'emp' and 'ctl'. Thanks for your help. mrkshpntf.

I have a form with multiple text boxes where data is to be entered by the user. Once the data is entered, the user clicks on a 'save' button to save the data entered. I would like the users to get a message when they click the 'save' button if they have left even one text box empty before the...

PHV, Thanks a lot! Your solution worked perfectly! I am sorry I didn't get to thank you earlier. mrkshpntf.

PHV Thanks for your prompt response. What I want to do is count and total the number of times the customers reps contact customers using each method. This is an example for June: Date contactMethod 01-Jun-07 phone 01-Jun-07 Phone 04-Jun-07 Mail 04-Jun-07 fax 04-Jun-07 phone 04-Jun-07 Phone...

I am trying to write a query on a single field(column). The query is supposed to count 4 different types of contact methods Email, Phone, Fax and USPS mail used in a specified time interval. The table is a simple two column table (created from a larger table with other data). The two columns...

I figured it out. Exit_OpenForm_Click: DoCmd.OpenForm "Form1" DoCmd.Minimize Exit Sub Thanks for you responses. mrkshpntf

Missinlinq, Check the system time on that computer.

Yes, PHV. That is what I meant. Thanks, mrkshpntf.

randy700, Yes, once the user clicks the openform button (which opens the second form), the first form minimizes. The openform button does two things (1) opens second form and (2) minimizes first form. Thanks for your response, mrkshpntf.

I have two forms. The first form is like a login form. The users enter data like their name and click on an openform button that opens the next form. Is there a way to that when the openform button is clicked on the first form, the first form minimizes as the second form opens? I tried using...

PHV, It worked!! Thanks a lot!!! Also like to thank all the others (Crowley16; TheAceMan1; Randy700; Max Hugen) who took time to suggest solutions to my problem. Your suggestions are always appreciated! Thanks guys, you all are always a great help. mrkshpntf.

Max, Thanks for your suggestion but it didn't resolve the issue. What continues to happens is (for example) If I select 'Fruits' in the Produce Combo Box (CBox1), the list of Fruits appears in the ProduceList Combo Box (CBox2). Now if I select "Apple" from that list in CBox2 and then change...

PHV In the AfterUpdate event of CBox1 ('Produce'). I tried the code in 'On Current' event too but there is no change for either events. Thanks, mrkshpntf.

PHV, Thanks for your response. I already have the code you gave (see above). My problem is that if a change is made for the second time in CBox1 (i.e. if a user changes his/her mind and changes selection in CBox1)it leads to no change in CBox2 i.e. CBox2 keeps displaying the list...

randy700, Thanks for your help. Where do I enter "CBox2.Requery"? mrkshpntf.

Crowley16, Thanks for your suggestion but it didn't resolve the issue. I have tried putting the code in other events like OnDirty, OnChange but it doesn't help. Thanks, mrkshpntf.