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...
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...
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("showdata").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 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...
Guys,
Learning Access and thus pardon the question. I am well versed with Excel and can prepare graphs easily. Is it better to generate a graph in excel with all the flexibility it offers and then import it to access report or does Access have an equally versatile graphical capability. If so...
I have a combobox with different scenarios. For example, the combo box consists of different quality problems encountered with a raw material. I have three text boxes. Depending on the problem with the raw material, I would like the textboxes to be attached to different control sources present...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.