Search results

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

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

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

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

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

First and foremost,Happy new year!!! i have searched the forum and cannot to get my problem fixed. i have a database that is currently running and i wanted to add something to it. By the way i got most of my help from this forum to build it. Thank you very much. We would like to add a biling...

Hi i have searched this forum and received some help from Bob but am still getting the same error on my database. i have one of the form that send appointment to Outlook calendar. the appointments will show just fine when the database is not split but when i split the database, i get Compile...

Hi all, below is my codes i have used ,but i keep getting the same error. please note my database is split. Any help will be appreciated. The database works just fine when it is not split. rivate Sub cmdAddAppt_Click() On Error GoTo AddAppt_Err ' Save record first to be sure required...

Hi All Thanks in advance for any help i will get. i have a database that works just fine when it is not splinted. i have a form where we can send appointments to Outlook Application but when it is splinted its gives a message (compile error- user-defined type not defined) Private sub cmd...

Hi All, i need help with designing a small database. This is what we do. we receive reports on people in our eight different locations . we then enter all that data in our old database but we have no way of knowing if the data we are entering has been entered already. The people that send us...

Hi all i have been working with access for sometime now. A friend told me about oracles software for database. what is the difference between the two. thanks for all help

Hi All I have searched the forum and i hasnt found what im looking for. i would like for my form(datasheetview) to show information only for the current month. for example ,may it should show may 2008 only. how can i do that any help will be greatly appreciated Thanks

Hi can i put a password for a backend database without affecting the front end? i have in the past put the backend database on some secured drives and i had problem with the front end. My main concern is to protect the backend which sits on a drive that has no security with it at all. Any...

Hi all i have spliitted my database on the network. i have two forms that are password protected and when i try to open them i get error message error 3219. i have searched microsoft site and found this the below info Public Function testLink() Dim myDb As DATABASE, rstCustomers As...

Hi All I have a form built on query called Current Med. its have medications info for the people and we have situations where the med get discontined for some reasons. i would like to have the discontinued med info to put be into another form for discontinued meds automically but i do know how...