Recent content by kbsudhir

Ok.. wil try that too :)

I have two tables 1. Master Personnel Table 2. Certification Details We have to four certifications. I am generating 4 queries one for each certification. This provides me the list of people who have certified in each of them from certification details table. Now I want to create a query...

Hi All 1. I have created a parameter query in access 2010. This parameter is on only one field. 2. I have created a multi-select list box in a form so that users can select one of more items. I want to pass the selected items as parameters to the save access query. Requesting guidance on how...

Hi All, I am trying to map certifications done by colleagues in my department. There are 4 certifications and I have which I have pulled out from the Certifications tables using individual query for each certification. Now, I want to add "Certification-Name_Certified" col which will have...

Its done guys. The right code is: DTPicker_EventDate.Value = rst!Event_Date I was getting that error because my DTP was set in Visible = No mode as I was changing the mode after setting the default date. Now I changed it to visible before setting its default date. Regards Sudhir

Hi All, I am trying to set default date in the DateTimePicker using VBA in access 2007 on Win 7. But I am getting the below error: Run-time error '2763' DTPicker returned the error: An error occurred in a call to the Windows Date and Time Picker control I am able to get the date sucessfully...

Thanks Pat, idea is to use data from Group By queries to generate the graphs, for that I have to use VBA ... but it seems thats not possible.. ??? :-(

Hi All, I want to design a Access 2010 database, Which will be accessed by 10 users from different locations. Required data for a user (who is currently logged in) will be displayed in a form using graphs. I will be using a macro to get this done. I will be using a lot of "Group By" query...

Hi, Thanks pr2-eugin & nanscombe. But, I am not getting Runcode option in the list of macros. Please guide. Regards Sudhir

Hi All, I have created a web database in Access 2010. I have published the same on the SharePoint 2010. I have create a Group BY query but aggregate option itself is not available in Access 2010. Please let me know how to create a query with "Group By" clause. Please guide. Regards Sudhir

Hi All, I have create procedure called "Test" in Access 2010. I want to call this procedure in a button click & also when the form loads. But the problem is Access 2010 is only allowing me to select from the existing list of macros which is available by default. :mad::mad: I have created a...

Thanks guys.

I recreated those fields. That solved the issue.

Hi All, I was able to resolve the above issues by recreating the columns which are bound to the master tables by using "Modify Lookup" feature of Access 2010. But now, only the below issue with the web compatibility remains. Property Name: Data Type Issue Type: Error Issue Type ID...

Hi All, I was able to resolve the above issues by recreating the columns which are bound to the master tables by using "Modify Lookup" feature of Access 2010. But now, only the below issue with the web compatibility remains. Property Name: Data Type Issue Type: Error Issue Type: ID...