Search results

Hi, I have a Rich Textbox to which I would be writing a certain data. Is it possible that from the words I can color certain word only. eg: I need to color the word "Userid" when written into the richtext box to 'Red' color. I am able to do this manually as the popup comes in the rixhtext...

HI, I have a system developed in Access 2003. When I am updating some records it gives me the error "Could not update; currently locked by another session on this machine". This error comes only when I update data on some records in the database. While searching on the access programmer...

Hi, I have been struggling with the below code for many hours. Could anyone help me on this! In my form I have a dropdown, which shows values - "A and B and C" -"B"...

Hi, I am trying to use vb code to change the background color of a certain column in word. I have used the below code. Set mycell = objWord.ActiveDocument.Tables(1).Cell(3, 2) mycell.Shading.BackgroundPatternColor = wdColorLightBlue I do not get any error. However the background...

HI, In a form I have created a button against a drop down of users, clicking on it, all issues pertaining to the selected user (from drop down)will be be consolidated and created as an attachment to the email to be send to the user. This process works fine. Now my issue is when I am...

Hi, I have a reqirement to store the old value of a field and new value of a field in a table. I am able to store the new value.However I am lost on how to get the old value of a field and store it in a table. Could anyone help me out in this? Thanks in advance.

Hi, Currently in my access system, I have used validation on Table level for fields which needs to be entered mandatory.(Required=Yes). However when the user enters the data, the validation pops up after every field(if data is missed). How can I prompt the user for all validation only as the...

Hi, I have recently split the access 2003 database and have placed this in a server. Now I wanted to take a copy of the database into my local machine and work as a different instance. so I have taken a copy of the frontend and backend database file and copied on my local machine. Then I went...

Hi, I have recently developed a system in Access 2003. I have applied user/role for accessing the system. The performance of the database is getting slower by the day. When I created I didnt split the database. Now when I am trying to split the database. For this I created a blank database...

Hi, Is there any formula to get the last date of the previous quarter. I need to display the aging value and need to compare with this date. Any help please?

Hi, I have created a valdiation rule in VB to validate one field based on the value of anotehr field. The code works fine and I am displaying a message also to the user to enter the value. Now this is the issue........the user can click Ok on the message I display and go to the next record...

Hi, Currently I have a VB code which sends emails from access 2007 on the click of a button. For this I am reading the email adress from a filed which the suer have to enter. Could anyone help with with a code which will connect to the Outlook and get the email address based on the...

Hi, I am currently using a access 2007 database. When multiple users are accessing the file and trying to make changes to different records in the database, the below error message is coming. "Microsoft access cant save design changes or save to a new database object because another user has...

Hi, I am new in Access 2007. I have created a form which has multiple tabs created. I one of the tab I have created a button, when clicked it executs a report, based on the value of a field in the tab.(currently I have put a default value for this field, which I want to parameterise). Now...