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...

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...

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...

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 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...

I have two combo boxes. CBox1 is called "Produce" which has two options in the list: Fruits and Veggies CBox2 is called "ProduceList" which displays either a list of Fruits or a list of Veggies depending on the selection in CBox1. When Fruits is selected in CBox1 a list of Fruits is displayed...

Is there a way to make the text line wrap after a certain number of characters in a text box? Also, can the character limit of a text box increased beyond 255 charachters?

I have a data entry form. I want it to work for entering a single record at a time. After I have entered data in the form partially and use the mouse wheel to scroll it take me to the next record which blank. Is there a way to make the wheel scroll down the form and not to the next record...

Is there a way to NOT get a 'action was canceled' prompt when cancel button is clicked on a parameter form? Thanks, mrkshpntf.

I have simple data table (single column) which contains a list of items that is the row source for a combo box. As of now, the items in the list are sorted in alphabetical order but I want it to display the items by the order of my choice. I tried the remove sort option but the order persists...

I have a form which needs to display the current date and time in the respective (date and time) fields/text boxes on the form, when it is opened. I have set the default value of the date field/text box to 'Date()' which works fine. I need the time field to display the current time in 4-digit...

I have a MS-Access form which displays records. I want the records to be displayed sequentially by date. I added 'Date' the form's 'Order By' property but the form displays the records in the original order which is not by Date. I have sorted the underlying table by date but there is no...

I have a shared Access 97 database. It is supposed to be used by 6 users. I can open the database and update it at my computer. But, when I try to open it from any of the user computers, I get the message that it will open only as Read-only. Is there a way to share this DB completely among...

I have a form with command buttons. Some of the buttons open other forms in a order. For example, on the form called customers I have buttons such as orders, customer contact, etc. If I click on the 'orders' button, it opens the form 'orders' but the 'customers' form remains open. I would...

I am trying to restrict users from entering data above and below certain values. On my form, I have a text box where users need to enter a number which cannot be higher than 2999 and lower than 0001. The value entered here needs to be stored a text datatype. Where do I add this restriction and...

I have two forms. Data entered in text boxes on the first form is displayed in corresponding text boxes on the second form. What happens is, once data is entered on the first form and an openForm button is clicked, the second form opens and displays the data entered on the first form. But...

I accidentally hide one of my tables in my Access DB. I can't find a way to unhide it. Please help. Thanks, mrkshpntf.

How can I make the switchboard of my Access DB to (open up first) pop-up whenever I open the database? Please suggest solutions, Thanks mrkshpntf.

I have a table (no PK is established for the table) with multiple records for an employee ID and with multiple employees. I want to create a query in which the parameter is the employee ID and will return the multiple records for each of the IDs. Please help. Thanks, mrkshpntf