Search results

thanks very much . it worked like magic

have no idea how to do that . any help can be greatly appreciated . thank you

please am developing this application and have a continuous form with these three textboxes namely procurement_id, request, and status. i want to be able to change the back color of status textbox to 1. red if it's value "PENDING" 2. green if it's value is "COMPLETED" 3. Yellow if it's...

some of the forms and tables were not suppose to be there . i forgot to delete them before uploading . the patient details and patient form both take their record source from consult query . when and information is entered into the the patient details form, and the patient gets to the doctor...

hi am new in access . am creating this system for an eye clinic and i want to be able to copy the values entered by the doctor and place it on the form assign .and once it is done and the search button is clicked, it should be able list all glasses having similar prescription in the system. can...

Dim Response As Integer Response = MsgBox("Do You want to save and procced to Bank Details ?", vbYesNo + vbInformation, "AUDIT SERVICE RETIREMENT MANAGEMENT SYSTEM") If Response = vbYes Then RunCommand acCmdSaveRecord DoCmd.GoToRecord , , acNewRec DoCmd.OpenForm "BANK FORM" DoCmd.Close...

am new to vba so am kind of getting confused

the second form ( Bank form ) only opens after the first form (personnel form) closes

i have a personnel form and a bank form . these two forms are both have a mandatory field called "Staff id" . is there a way i can pass the staff id on the personnel form to the bank form automatically once the user enters it in the personnel form . Can anyone please help me with the vba...

thanks guys. guess will have to restructure the tables again

hi i have five tables namely team a team b team c team d team e a staff can find himself in all the teams . is there a way that when i query the staff name , the system should be able to open a form showing that staff's name in all the team he is in . need help please . thanks

Want to create a POS system for a restaurant am opening. Please can anyone help me how to go about it . If anyone have a similar system can u please share with me . Want the system to be able give me my sales for the day abd for a month and year . Please need help

i just checked it . and i get it now . thank u very much. i really appreciate ur time .

it is working perfectly except for the fact that the audtype {edit from} picks the user name of the application and the audtype{editt to} uses the API CALL to call the system useer instead of the application user. can anything be done about that. is there anyway the audtype [edit to] pick the...

Have downloaded it . Will try it once I get access to a computer. Thank u very much . I will give u a feedback when am done .

When I try to save a record that has audit status as validated , I get "argument not optional" compile error . And module 1 opens up . Highlighting function auditeditbegins with yellow colour and Call logerror (err.number,err.description,conmod & ".auditeditbegns()", , false)

@ arnelgp have attached a new db file your code for the re-engagement and replacement works perfectly as long as some fields are empty . and it will show the 'not validated' auditor's status . but the moment all the required fields are filled and me.CAGD JOB TITLE.value <> RANK BEFORE...

Thanks man . I really appreciate it. It is working

@arnelgp i sent it to them to try it out only for them to come to me to and say there is another condition needed the condition is if application_type.value ="Replacement" or "Re-engagement" and CAGD JOB TITLE.value <> RANK BEFORE PROMOTION/UPGRADING/DELETION.value then the auditor's...

THANKS arnelgp. it worked perfectly .