I have a form with the WebBrowser1 control
I add the HTML source using this code:
WebBrowser1.DocumentText = HtmlString
its work good out of the images
How can I add to the HTML file the images that exist in the project?
Thanks!
I want to make stored Procedure that get sum total of the order and return the ship price
my table schema attach :
in my procedure I want to get the order subTotal and return the ship price
For example if the subTotal is 60$ than return 300$
etc,
my problem is that if the "toPrice" = 0...
my custom have a big table in the outlook, in the contacts.
in the outlook table that possible to insert also the birthday.
my custom want to send mail day-before the birthday to wish.
I want to do it with access, to link the table to the contcts and send mail if the birthday is tomorrow...
is it possible?
I have a query
insert into myTbl (col1, col2)
select myFirstCol, mySecondCol from myTable2 where....
I want to find the first identity that insert.
if I write select @@identity, I got the last and I want the first.
is it possible
I open form and get parameter in the openArgs
I have a tabular Form
and I want change the color if the ID is aqual.
for example:
I open the form like this:
DoCmd.OpenForm "frmMessageShow", , , "fID=" & Me.fID, , , Me.AssighmentId
[the Me.AssighmentId is the openArgs]
I want in the second...
how can I open form that in another file.
I have 2 access files (*.mdb) opened, I want when I click on one I open form in the secend file.
how can I do it?
thanks!
I want to open the internet explorer from access
but with url
for example
dim strUrl as string
strUrl = "http://www.google.com"
'here I want to open the explorer with the strUrl
thanks!
I send mail from access with cdo
like http://www.mcse.ms/archive164-2004-4-611940.html
work great in my computer
when I try to send the file to my customer
its not work because of missing references.
(ans its not in the references list)
can I copy the file from my computer and send it to my...
insert data to option group by code
add value to option group by code.
I have a form with option group,
but I want to take the data from the database
I have a table: survey
surveyID surveyName
1 yellow
2 green
3 red
I have a form I...
I send mail massage with the code
DoCmd.SendObject , , , strToField, , , strSubject, strMessage, False
and the access ask me the file attach
how can I send automateclly with no msgbox
I work with project access (*.adp)
I want to know if it possible to take the last ID after the sql INSERT QUERY
my code:
strSQL = "INSERT INTO missionFather ....."
DoCmd.RunSQL strSQL
thanks!
I have a list view in my form
I add new rows in the list view by code
here is my code:
ListView.HideColumnHeaders = True
With ListView.ListItems
.Add , , name_book, , 1
.Add , , name_pupil, , 3
.Add , , MAX_DATE, , 4
.Add , , KAT, , 5
.Add ...
first i'm sorry on my english.
I have in my work some computers with network.
I want to send mail to one computer, the mail is like form in HTML
have 3 things:
1. textbox
1 select
1 submit
is it possible to get the mail and to write in the mail and send it (by submit button) then to...
I know about the option write vertical.
my problem that I cant to work with it.
for example I want write in the verical filed JUN 2005
and in all the other filed write Horizontal
is it possible?
if some one can printscreen of a report that seems to what I look for
it will help me alot...
I have string
I want to print the string and no by report
for example:
dim s as string
s = "hi" & vbcrlf & vbcrlf
s = s & "my name is sharon"
now I want to print the string in the printer
with default font and default size.
is it possible?
thanks!
i have a sample function
Function GetPercent(n As Integer) As Integer
Select Case n
Case 1: GetPercent = 100
Case 2: GetPercent = 50
Case 3: GetPercent = 0
End Select
End Function
I have a table like this
a | b | c | d | e | f | percent...
I did a word document in word with many bookmarks (like 900)
and the access insert the value to the document.
I give it to my customer and many bookmarks was missing
I dont know what can be the problem.
maybe that I have office 2003, and the customer 2000
all help will be thanks!
(sorry if...
In the menu in word there is some option to view the documents
1. Normal
2. Print Layout
3….
I open the word’s document from the access
I insert value from the access into word.
I asked here some question in last week and I helped so much.
My question now is:
In the document in the word I...
I have an application on access that export the data to word.
I did a query and the data export to word
my code is:
Dim db, rst
Dim strSQL As String
Set db = CurrentDb
'÷éùåø åôúéçú ååøã, åäöâúå áöåøä îåñøú
Dim objWord 'As Word.Application
'Set word as an application and make it...