Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: mrkshpntf
  • Content: Threads
  • Order by date
  1. mrkshpntf

    Sub Totals

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

    Numbering items

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

    Query for Totals

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

    Message Box

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

    Query on single field

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

    Minimize Form

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

    Combo Boxes

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

    Wrapping

    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?
  9. mrkshpntf

    mouse wheel scrolling

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

    Cancel Button

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

    List

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

    Time Format

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

    Order By

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

    Shared Access 97 DB

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

    Close Form

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

    Restrict Data

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

    Form to Form

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

    Unhide Table

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

    Switchboard

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

    Query

    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

Part and Inventory Search

Back
Top