Search results for query: *

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

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

Can anyone give me more detail instruction?

Can anyone help?

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

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

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

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

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

Thanks for your reply, but I have one more question which is I do not want people scroll to see the records he 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

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

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

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

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

thanks a lot! I got it!

can anyone help? thanks

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

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

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