Search results for query: *

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

Thanks Eupher for the prompt and excellent reply.

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

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

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

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

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;))=...

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

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

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.

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

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.

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

I have been trying this out for some time before I gave up and called for help. I have the following fields: 1. baseprice 2. coverprice 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...

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.

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

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

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

tblingredients consists of the following fields: ingredientid: number ingredientdescription: text amountinformulation: number (%) compoundid: number I have another table called tblschedule. Consists of the following fields: compoundid: number noofbts: number batchweight: number...

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