Search results

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

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

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

Hi All, I want to create a database & publish the same on to the sharepoint 2010. I have five master tables which provides input data for the Main_Table. List of data is linked to particular columns in Main_Table using a query using the lookup option. To make all the tables web...

Hi All, I have set of dates in a column & I want to find the number of financial year/s between the first & last date in that column :banghead:. The financial year starts from April & end in march next year. Please guide me on how to get this done. Regards Sudhir

Hello, I am want to validate the data in a table column as per the data in a corresponding column in teh same table. Ex. I have a table with column "Frequency" of datatype Text. And other 12column are in the name of the months. i.e. Jan, Feb etc of datatype "Yes/No" in checkbox format. Default...