Recent content by VPK_Access

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, Thanks a lot for the update. I did some debug on the program and it seems that this error happens when I try to enter a large size of data from a string to a memo field. I have attached the code as mentioned below. When the Length of the string(after Msg '3') shows beyond 1700-1800 length...

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, Thanks a lot for the udpates. I feel that it is the way I pass the string that is giving the issue. I have posted 2 query for explaining my issue. In Query1 when I input the value "A" Or "B" Or "C", it gives me the output. However if in my code if I put...

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 have resolved the issue. I included "Microsoft 12.0 Object Library" in the reference. And another thing I have done was that I was reading from a word template. In the word template, in the Table-> Cell-> Shading-> I made the Patter to 'Clear' value. It was previously coming as...

Hi, Thanks for the reply. Just to give a background I had used the code in the access only. I have a button in my form, clicking on which I create a word document with tables in it. I wanted a certian cell to have a color based on the value it has. I took your suggestion and included the below...

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

I am sorry I didnt get you. How would I be getting the old value of the field?

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.

When I gave the validation in the Before upadte event of the form, the validation works.....however the validation message pops up even when the user clciks on the field. For eg: If there is a validation for field A, B , C....after the user enters the value for A, when he clicks on B, the...

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

How do I make a a copy of the file and work from my local machine? (kind of a UAT environment).

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