Search results

thank you very much

thanks Bob

Any help will be highly apprecited. i found a security demo databse on this forum and it is excellent but i need help with the codes to put on forms as they load. 1.Admin.acts as the over all adminstrator for the database. Has full controll over all data and objects contained in the database...

Any help will be highly apprecited. i found a security demo databse on this forum and it is excellent but i need help with the codes to put on forms as they load. 1.Admin.acts as the over all adminstrator for the database. Has full controll over all data and objects contained in the database...

i have been searching on this forum on conditional formatting but i can seem to get my problem solved. i have due dates that i would like to change colors when they are 15 days before due date and red for 30. i have tried some examples but they are all not working. expr DATE()+15= (red font)...

i have searched this forum but i havent found anything that am looking for. i have five dates that i would like to pop up 30 days before the actual date and below is the code that am using Between Format(DateAdd("d",-7,Date()),"mm/dd/YY") And Format(DateAdd("d",+30,Date()),"mm/dd/YY") the...

thanks , thats what i did and it worked.

[DoCmd.OpenForm "staff" using employee id] left something out in the code thanks

I Have a form that has a subform and i would like to open the form using the employee id. The main form shows records of employees in the subform. i also have a form which has more info for the employees which i would like to open by clicking the command button on the main form when the employee...

we use moodle for training our staff . one of the option in moodle isto download results in excel format. we have about twenty different quizes and the results show first, last names, time taken, and percentage of the grade. i would ilke to import this information to access but my question how...

Re: VBA /Automatically populating a field DK I received help from you and i cannot forget you; well, maybe i did not ask my question correctly. i tried the codes above but did not work. when i click on tenant id to add a new entry they all show zeros. Explanation TABLE A: Rent Amount entries...

thanks DK let try what you have said. by the way DK you are the one that helped me with the ealier problem i had. it worked using conditional formatting. thanks

hi all, i have a running database and after i met the users , they all expressed the need for to me change one thing in the system. i have a form built on a query which get its data from two tables. we charge our tenant rent . the rent figure is based on one's income. what i would to...

Hi all, i have this code on this forum it works on a single form but wont work on continous form. PLease helpPrivate Sub Form_Current() If Me.Payee = "Jona" Then Me.Payee.BackColor = vbBlue Else Me.Payee.BackColor = vbRed Me.Payee.BackColor = vbRed End If

why it is prompting me to enter amt of ddb and ddc when i run the query? [ddb ] +[ddc ] is what is showing in the DOD. Thanks

Thanks you DC for your quick response. i will igore the color issue as advised.i dont know if am using the right formula for this or not. the Dod is like Rent payement which consist of ddb and ddc Out of which ,we have two types of payees (Tenant )type one makes one payment which is ddc to...

:confused: i have some feilds in the table as follows: DDB AMT, DDC AMT, DOD AMT, and Payee DDB Plus DDC = DOD if payee name is John Co DDC= DOD if payee is Happy Co What am try to achieve is that if John Co send his one che DDB the DOD should be blue in color or zero and if John send all his...

thank you James.

is it possible in access 2003 to print records that have been entered in a space of time and not days/month. For example if i enter six entries between 10am and 12pm,can i print just those entries. if yes ,how can i do that. thanks

Thank you for your response.i will now try that.