Search results

  1. 2

    WinForm WebBrowser control

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

    Shipping Price

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

    link table to outlook contacts problem!

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

    select @@firstIDENTITY

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

    must trick to backColor textbox

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

    open form in another DB

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

    open the internet explorer from access

    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!
  8. 2

    missing refernces

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

    indert data to option group by code

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

    send mail automateclly

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

    Insert... ; Select @@identity

    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!
  12. 2

    export to excel memo filed

    in the excel there is just 255 length how and where I can fix it?
  13. 2

    list view

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

    update access db by HTML page

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

    write vertical in forms / report

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

    print string by access

    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!
  17. 2

    call fuction from query code

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

    bookmarks delete BySelf

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

    open "Print Layout" in word by code

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

    access and word' work together???

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