Search results

Hi Guys I have to write piece of code to achieve the following: 1. When the Form gets opened then timer will start. 2. It will fire BtnClose_click event automatically after 10 minutes if there is no activity for 10 minutes. 3. Whenever BtnSave is clicked by the user then reset the timer. Can...

ok so can you please help me to display "registered to" information. So basically in my example I want to display "Friends Provident"

Please see attached:

Thanks Jdraw. Which function I need to use to just display "Registered to" information. Thanks

Like when we go to Start->My computer->View System Information then in General tab , there is "Registered To" so I want that value using VbA

Hi All I have data present in "Date" sheet of Workbook1. Now I have another workbook named "Workbook2" which is not open. I want VBA code in userform1 of workbook1 so that when a commandbutton is clicked then it will copy data from "Data" sheet to a copy of Workbook2 and send copy of workbook...

Hi All I want VBA code to get registry from my PC. So basically I want to put some conditions in the workbook like if registry=something then do this Else do something different. Any help would be much appreciated. Thanks

Well Paul, This is totally a new topic which I have never done before. These situations come in everybody's life and I am sure u also faced these issues when u just started working in Access/Excel . Anyway thanks for your help. I really wanted someone to guide me and not to do homework for me. :(

come on namliam. As I said I have no idea how to get this done so plssss help me to figure it out. Thanks

namlian, any other way to get my task done?? I mean clicking a button on Access form to display a chart in excel etc.

namliam, Please guide me in this as I never created Pivot charts before. See my first post to know what exactly I want. I want three bars in the chart to be Amber,Green and Red colour. so it should check for the last 7 dates from todays date, check if todays date is equal to Date then colour...

Is it possible to create this type of chart that will show three bars in Green,Amber and Red colour?

Hi namliam, Is there any way we can write down crosstab queries or Pivot charts to display the required data? Many Thanks

Thanks Paul. But can you elaborate how this can be done ? Any help would be much appreciated. Many Thanks

Thanks Paul, Can you please help me in creating Pivot Chart ? I want the chart to be displayed on the screen when the button on the form is clicked. Many Thanks

Hi Guys I have Access table tblupdate that stores following fields: Date,Username,To_Be_Updated,TargetDate Now I want to create a dashboard that will show data of last 7 days from todays dates in 3 charts : 1st chart with Red colour (That means if todays date is greater than TargetDate)...

Hello CJ_London, Can you please help me in this? How to put Update_ID as well in the table?? Thanks

Please have a look at the attachment as well. Now there are 3 tabs i.e Table1,Table2 and tblUpdate.

Its a made up value and its made every time update occurs. When Update button is clicked then the tblUpdate stores new Update details and then Table2 gets updated. in the tblupdate if ID=1 then Update_ID will be P1, if ID=2 then Update_ID will be P2. ID field has Autonumber data type. Update_ID...

The table tblUpdate will store UpDate_ID starting from P1,P2 and so on. so whenever Update button is clicked then first of all tblUpdate should store all the details when the update occurs like Date,Username and the Update_ID and then Table2 gets Updated and also at that time the same Update_ID...