Recent content by yoavchen

  1. Y

    attach file in one click

    clarifications well, i have a feeling that you think i am an expert... :) so i am not, so i will need help in the below level...sorry. i have a form, in this form,i have to buttons. the buttons is doind now a simple action. when i click on button A, a text is written in the mail body. when i...
  2. Y

    attach file in one click

    i want to write in the code, that if you click on A button,the path will be:c:\aaa.txt and if you click on B button,the path will be:c:\bbb.txt i just dont know how to write this in the code
  3. Y

    attach file in one click

    i am trying to attach a file, but i dont want to click and the browser will open, i want to click the send mail button and the file i want to attach will automatically attached and sent to the recipients
  4. Y

    Error at inserting new value

    hi, well, i have no idea what you just sais to me, can you please clarify? thanks
  5. Y

    Error at inserting new value

    attached is file with the error
  6. Y

    Error at inserting new value

    i got the atached message when i am trying to insert a new value, the wierd thing is when i do okayu, the value is being insrted...
  7. Y

    ADP Files

    i wanted to convert my MDB file to ADP. the convertion went well except from on important issue, it didnt convert all mu queries to the new file, i tried another way but nothing. please help. all the forms and tables an d everythoing else are in the new file, although, the forms are based on...
  8. Y

    do not display the email

    Where? in what field?
  9. Y

    do not display the email

    i have this code. i want to send the mail and NOT display it, i put only the send and still it send it okay, but also display it. please advice. Function DoMail() Dim oOutlook As Outlook.Application Dim oNameSpace As Outlook.NameSpace Dim oMailItem As Outlook.MailItem Set oOutlook = New...
  10. Y

    Automatic Mail Tamplate

    i would like to send mails with a tamplate in the subgect and the free text body. i have this code that allow me to open the mail and fill the "to" with two email adresses. Private Sub cmdEmail_Click() On Error GoTo Err_cmdEmail_Click Me.cmdEmail.HyperlinkAddress = "mailto:" & Me.ManagerEmail...
  11. Y

    run time error '6'

    run time error '6' Overflow what is it????
  12. Y

    limit text box to digits

    how can i limit an unbounded textbox so only digits from 0-9 will be entered
  13. Y

    count in query

    almost.... you made me a counter. i need to count the rows - "4" in this case. i need this number for some if i am trying to execute i am trying to do if: if NumofRows<5 then txt1.visible=false end if
  14. Y

    count in query

    how can i count the number of rows in a query. i have a query that return me number of rows. i want to count the rows. when i try to count it, it gave me a column that count only her column. which mean in every row it counts me '1'. i want to count all the rows.
  15. Y

    problem with code

    i am trying to execute a query that give me a list of companies. in the query i put parameter with the operator like. i am trying to limit the company names that i get into 5, which mean, if the form is opened with more then 5 records, i want to hide this field. i did a simple code: Private...
See more
Back
Top Bottom