Search results

  1. 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
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. Y

    run time error '6'

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

    limit text box to digits

    how can i limit an unbounded textbox so only digits from 0-9 will be entered
  8. 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.
  9. 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...
  10. Y

    transfering to excel

    i am exporting some table to excel file, but the problem is that not all data are being exported. all text or numeric is transfering completely but all the ole objects are not, for example: picures, files( all the ole object i made it LINK)....so if it is a link why cant it being trasfer, what...
  11. Y

    dont understand what this error mean?

    i have this error: Run-Time Error '3265' Item not found in this colliction
  12. Y

    make tabctl visible

    i am trying to make my tab control visible, after i did it visible=false in the open form event. the problem is that the button that supposed to open the tab control is locates in a form and the tab control is located as a sub form. it doesnt recognize any version of writing that i am trying...
  13. Y

    picure as a btn

    i have a pictures that i want it to behave like a btn. when i click on it i want to see it pressing down and up - like a btn
  14. Y

    orders calendar

    i am trying to find a code that will present me some orders calendar of rooms. i a trying to build some calendar that will show me the order date and the end date of the roon, rent by te customer, somehow that i will see that all the dates between these two date are occupied, like an outlook...
  15. Y

    status query

    i am trying to make a cross tab query that will give me the status of the unavalble rooms in my hotel somthing like that: romm num today today+1 today+1 today+2 today+3 today+4 and so on... 1 X X 2...
  16. Y

    hyperlink label to a tab control

    i dont know how to make it work. simple, clicking on label in tabcontrol1 will bring you to tabcontrol2
  17. Y

    dimming labels

    how can i dim label that i wtn it to be disable...but visible. i know i can do it with command button but i dont know how can i do it with label.
  18. Y

    two questions- (two frames and html form)

    First quetion how can i make some form to be with two frames, one is the navugation tree and the second one is a frame that is changing akk the time, which means the navigation tree is not changing ever. i am trying to build somthing like asp with two frames and a record set and i dont know how...
  19. Y

    two questions- (two frames and html form)

    First quetion how can i make some form to be with two frames, one is the navugation tree and the second one is a frame that is changing akk the time, which means the navigation tree is not changing ever. i am trying to build somthing like asp with two frames and a record set and i dont know how...
  20. Y

    import linked files

    i execute an import with the "Transfer Spreadsheet" mothod, all of the data has passed to the excel spreadsheet but all the files that were linked as a OLE object is gone, nothing was passed to the new file. the files is linked and not an attachment so i have no idea why doesnt it passed to the...
Back
Top Bottom