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!

  • 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: neerajam
  • Order by date
  1. neerajam

    Access word mail merge question

    I have a list of 14 soccer players that get the same information on a regular basis. I set up an access database with their personal information. I also set up a standard word document with lastname and firstname, address, city, and state bookmarks. I have no problem with doing it for a single...
  2. neerajam

    sending e-mails to multiple addresses using list box

    Thanks Eupher for the prompt and excellent reply.
  3. neerajam

    sending e-mails to multiple addresses using list box

    I would like to send the same e-mail message to multiple addresses using a list box. I have been successful sending it to a single address but am struggling with multiple addresses. I would sincerely appreciate any help. Thanks. Code used: Dim ol As New Outlook.Application Dim ns As...
  4. neerajam

    having problem saving from data in outlook contact

    I have a form that contains all my soccer player data. I would like to save the same in outlook contacts. I have used the following code to do the same. However, I am able to input only 1 record and that record alone. Can you help me out. Thanks. Dim db As Database Dim rsdata As Recordset Dim...
  5. neerajam

    combo box multiple select

    Another newbie question. I have 2 combo boxes. The first combo box contains information about all the different marketing shows conducted by my company. I designed the combo box to accept multiple choices. After making multiple choices and submitting, I get all the different categories for each...
  6. neerajam

    combo box multiple selection

    Used your suggestion. I am getting an error saying Loop without the Do. Everything looks perfectly logical but yet does not want to work.
  7. neerajam

    combo box multiple selection

    My code is as follows: <% sql = sql & &quot;SELECT top 40 show_i, show_nm, start_dt from show order by start_dt DESC&quot; set rs = conn.execute(sql) For i = 1 to request.form(&quot;showdata&quot;).count do while not rs.eof sselected = &quot;&quot; If (CSTR(rs.fields(&quot;show_i&quot;))=...
  8. neerajam

    combo box multiple selection

    I am a newbie to ASP programming. I would like my multiple selections in a combo box to remain selected. I have a combo box that is populated with a do while not recordset.eof/Loop statement. I did give it a try with a for /next loop(from i = 1 to Request.Form(&quot;showdata&quot;).count. But I...
  9. neerajam

    Would like to use framesets

    I would like to create a page with 3 frames. The top frame (horizontal) a dropdown box populated with data from a database thru sql. When I click a city from the dropdown box I would like the data(names of customers from the city in the dropdoiwn box)to be presented in the left frame and all...
  10. neerajam

    Drop down box question

    I am new to Visual Interdev. I have a drop down box listing products. I was able to populate the box thru code but I am having trouble doing so using visual interdev. Would someone be kind enough to walk me thru this problem with a simple example. Appreciate the help.
  11. neerajam

    Export data to Excel question

    I am currently sending data to excel from my Access database. I also have filters set up on my database. My question is can I filter my database first prior to exporting it to excel. Can I also export the data to different worksheets within the same spreadsheet depending on the filter used...
  12. neerajam

    Help with visual basic controls and components

    I am new to visual basic and would like to learn fundamental control and component design thru examples/tutorials. I would very much appreciate some feedback. Thanks in advance.
  13. neerajam

    obtaining sum values in an order form

    I put in the defalut value of 0 in the table for all the cost fields. Yet I do not get a figure in the total field. I tried doing the same on the form field property and yet the same result. I wonder what else could be happening. Please let me know. I realize it is a very simple problem and yet...
  14. neerajam

    obtaining sum values in an order form

    ...3. diskettepocketcost 4. hbcost (hb is hard bind or something to that effect) 5. quantity total price = (base price + cover + diskette + hbcost)*quantity I do not have problem when all 4 items are required and the sum total is ok. However, when only the base is ordered and I have the base...
  15. neerajam

    Can I import selected excel data into Access

    I am working on a project where all the data is in excel. Working on creating an access database using this data. Depending on the table, I would like to import only selected data. Is it possible to do this. I know the other way is to import the whole file and then delete unwanted portions. Thanks.
  16. neerajam

    combobox question for an order entry form

    I am currently working on an order entry form. Currently, I have set up orderid, customer, productdescription, quantity, price, discount, orderdate, discount, totalcost, and netcost as fields. Therefore, when a customer places an order for a single item, say product A, I do not have any problem...
  17. neerajam

    automatically add discount % to combo box based on date difference

    I am creating an order entry form. My customer gets a discount based on the following: 2 year program discount: year 1 = 2% year 2 = 4% 3 year program discount: year 1 = 2% year 2 = 4% year 3 = 6% 4 year program discount...
  18. neerajam

    Combo box question

    I have designed a database for my boss to keep track of his employees projects. For example this form contains a combo box for projects and the underlying table contains projectid, areaid, and projectdescription as fields. Right now I have pop-up forms being used to enter new data into the...
  19. neerajam

    need help with an inventory database

    ...to join the 2 tables on compoundid and obtain the qty of ingredient required for each compound, each ingredient by multiplying amountinformulation * batchweight * noofbts. I did this as query but the error message I got an error message not updatebable. Any one got any suggestions on how to...
  20. neerajam

    Wish to export selected data from an access database to excel. Can I

    I have a production database with all production related data. I would only like to export selected data from the entire database such as date, scrap, production, type of complaint to excel. I am not interested in sending the entire database. Right now, with the Docmd.Transferspreadsheet...

Part and Inventory Search

Back
Top