Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. jefferyzhong

    Can I email different material to different people

    PHV, I am new with VBA, would you please help me with these code? would you mind to post the code in this thread? thanks
  2. jefferyzhong

    Can I email different material to different people

    PHV Thanks for the help. I know how to send to multiple email address now, but how can I put different data ( due to query) to different person. thanks a lot Jeffrey
  3. jefferyzhong

    Can I email different material to different people

    Can anyone give me more detail instruction?
  4. jefferyzhong

    Can I email different material to different people

    Can anyone help?
  5. jefferyzhong

    Can I email different material to different people

    I have a Quality control database, I record the information like this: department, manager, employee, errors... I suppose to email out the employee errors to his manager every week, which means different manager only receive the employees errors under him. Supply I have the Query name"...
  6. jefferyzhong

    How to set primarykey to a field by VBA or Marco?

    for example, I want the table of "TblEmployee", the field of "EmployeeID" to be the PrimaryKey. just by clicking the command button. not by setup through design view of the table because I do not want everybody to touch the structure of the database. Thanks
  7. jefferyzhong

    How to set primarykey to a field by VBA or Marco?

    Could anyone tell me how to set primarykey to a field by VBA or Marco? I need to update a table once a week, and I need Primarykey for that table. Thanks
  8. jefferyzhong

    Report one record in one page

    hi, Could anyone help me solve my problem. I have a report which shows the performance of the employee, I want the page seperated by each employee, how can I setup that, please advise! thanks in advance Jeffrey
  9. jefferyzhong

    Open form for new record input

    I mean, for example, he input 5 records in one time, I do not want he can review the records he input also, because sometimes, some other people will input some data after him! thanks
  10. jefferyzhong

    Open form for new record input

    Thanks for your reply, but I have one more question which is I do not want people scroll to see the records he input!
  11. jefferyzhong

    Open form for new record input

    I have a question about my database I have a data input form, I want that, when I open form, it will show a blank record for input. and I do not want the input person can review history data, I tried to setup the navigation button unable, but some mouse can scroll back! appreciate for your help
  12. jefferyzhong

    Use form to open report

    hi, I have a form, which has begindate, enddate, customer and report type... I have several reports can be opened by this form. before, the "customer" is a combo box which means I only can select one of them, I set the report!Rptsales![Customer]=forms!Frmreport![Customer],it works well, there...
  13. jefferyzhong

    unprotecting/protecting a spreadsheet with VB

    when I add below codes, there is worksheet class error. Activesheet.protect("abc") or Activesheet.protect() password:="abc"
  14. jefferyzhong

    unprotecting/protecting a spreadsheet with VB

    I have a worksheet which is updated when I press a button. I have the code in the click event of that button. However if the worksheet is protected, the code cannot update the cells. I think I have to unprotect the sheet when I press the button and protect it again after the update. I need...
  15. jefferyzhong

    How to Setup Username and password

    hi, I have a problem with setting username and password. I use the Access Security user and group account, it applied to all of the access file, but when I use another computer, I can open file without asking username and password! so can anyone tell me how to setup username and password with...
  16. jefferyzhong

    two subform link problem

    thanks a lot! I got it!
  17. jefferyzhong

    How to use Macro to control the chart?

    can anyone help? thanks
  18. jefferyzhong

    two subform link problem

    thanks for quickly reponse but could you please explain more detail? thanks
  19. jefferyzhong

    two subform link problem

    I have a form which contains two subforms subform1 link with main form by ORDERID subform2 link with subform1 by CUSTOMERID subform1 works well when ORDERID changes but subform2 only list the data according to the first data of subform1, when I change subform1 sorting from ascending to...
  20. jefferyzhong

    how to dlookup a value

    For example, table 1 has the following info PO ProductName Price ..... table 2 has the following info ProductID ProductName Price I want table 1 "Price" Could be "dlookup" from Table 2, according to the same "ProductName". I know how to do it by Query, but I need it in the table as a input...

Part and Inventory Search

Back
Top