Recent content by 24sharon

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

try again.... :confused:

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 know my english not good, but I success do it. I did conditional formatting with expression [AssighmentId]=[text39] and in the page load I wrote: If Not IsNull(Me.OpenArgs) Then Me.Text39 = Me.OpenArgs End If that work great. thanks!

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

I found this code, but this code open the database, I want to open form in an opened database, what need I change? Dim appAccess As Access.Application Set appAccess = CreateObject("Access.Application") appAccess.visible = true appAccess.OpenCurrentDatabase "C:\Michal\xx.mdb"...

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!

thanks! first I need it by code no by link second i found this code Private Sub Command17_Click() Dim strUrl As String strUrl = "http://www.google.com" Call Shell("explorer.exe " & strUrl, 5) End Sub my problem now is that the internet explorer open minimize I want to open it maximize and...

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

and to see the example here http://www.access-programmers.co.uk/forums/showthread.php?t=54244&highlight=KeyPress

I Try Do This Code But my problem is with space for example if I write "hello " (with space) the space delete how can I fix it? thanks!

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