Search results for query: *

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

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

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

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

hi, I have a question which is about the chart report my database requires optional report, for example, I need the report for certain department and certain shift, probably I need the report for all department and one shift. I can use Macro for data report. but it does not work for chart...

I want to start up with the instruction Form for my database, and when close it, I want the "Main switchboard" POP open. could anyone tell me how to set the code! thanks in advance! Jeffery

I try to populate some information from a combo box, but I can not find the combo box wizard, can anyone tell me how? and is there another way to populate data without wizard? thanks

hi, I have a question about the Query, For example, I have 3 field, field 1 : ID field 2: name field 3: sales my table is like this ID name sales 1 aa 100 2 bb 400 3 cc 300 1 200 2 200 in the record of 4 and 5, there is no name, but it is...

hi, I have a problem need help I want to group the data by the first day of the month and the first day of the quarter, grouped by the first day of month, such like: 03/15/05, 03/21/05, will be grouped as 03/01/05 grouped by the first day of quarter, such like: 01/15/05, 03/12/05, 02/19/05, will...

can anyone tell me the code! thanks in advance!

I have a question need help, I can group the data as weeks, but the title shows as "number", I want it shows like the first day of the week. for example: today is 05/24, yesterday is 05/23, the first day of this week is Sunday, 05/22. so when I group by week, today and yesterday will be grouped...