Search results

hi may you split the db into Front and backent. In back end you can keep all the tables and in front end you may use different controls like froms, reports etc based on privilage to want to assign and can have read only access.

hi better send the table structure or db itself for better answer as it is not clear from the details

hi try by making making a new accde / mde from mdb itself in the pc you want to use. i thonk this will solve the issue

hi, actualy I am not clear about your requirement. whether you want to check all 4 textboxes or either anyone them. I dont have any idea about structure and data of the of the table. however, i would suggest you to send the DB along with your clear requirement to suggest right a solution

hi, I think at table level this is the only solution available. if any other solution availabe, let me also know

hi, make userid and date as primary key in tblDailyReport. this will fix your problem enjoy

hi in the property of combo, select column count as 2 and column widths as 0";2"(desired width). this enable to add code to the table while display will be only description enjoy

hi, it will be better to create an another table in which u can store category and range and use this date for Combobox instead text box and update the desired table with a sqlstatement on afterupdate event this combobox enjoy!!!!!!!!!!

hi, it is not cleare that all the 4 field u r reffering is used making the subform visible or not. however, in the afterupdate event of the field, take the value into memory varial and use dlookup function to find the value in the DODAAC table. use if condition to make form visible if found...

hi, you may try "select case" method. case1 - 1 st conditionm case2 - 2nd condition, case3 - 3rd condition. end select

hi very simple. if these 3 tables are linked , create a view and place the filelds in the form which will enable to update all the three tables at a time

hi, link your manin form with all 4 four subforms by your common id like shop order number

hi philben thank you very much

hi vbainet thank you very much

hi uncle gizmo thanks --------------------------- Microsoft Office Access --------------------------- >>>UPDATE TblEmpSch INNER JOIN tnassign ON TblEmpSch.EMPNO = tnassign.token SET TblEmpSch.'week1' = [TNASSIGN].['wk1'] WHERE (((Tnassign.'wk1')!= 'na' )); now i changed the code to...

Hi all, I have a small prob which i am not able to fix. while executing this code the following error message is give Private Sub Command5_Click() Dim asql As String DoCmd.SetWarnings (off) DoCmd.OpenQuery ("aqryEmpsch") DoCmd.OpenQuery ("aqrynassign") DoCmd.OpenQuery ("aqryleaveadd") Dim...

Hi all, It is nice to be a part of this forum. i have a small problem for which help is required. I have a db and through which a query, a multi line, is generated where i have current and next assignments placed under each date(week) Colum. for look ahead plan and decision making process...