Search results

Hi, Is it possible to set a calendar invite in outlook 2010 with dates entered in an access 2010table ? The user can add the recipients to the invite invite but is it possible to just create this calendar invite and not send it based on dates eneterd by the user? We are planning to migrate...

Thanks Bob...Seems to be complex but will have a go.

Thanks John..in this case it is stopping further processing - even running the queries. Is there any other solution?

Hi John, I did add this code from this website- what it does its that it disables the key when it is pressed but the processing does not continue. Tx, Priya

Hi, I have gone through the posts and found out how to trap the escape key (By using the Keydown event). However, I want to be able to disable escape key when processing . The process includes the following: Update status fields in the form --> Compose and send email --> Write audit trail -->...

I am using linked tables to Access front end . That's why I am using the # character.

Hi, The records are not picked up as expected...the < and > signs do not seem to be doing their tasks. Thanks, P

Hi There, I have been struggling to make this bit of code work...is there something wrong in it?: rst.Open ("Select * from tblusers where (tblusers.fromdate <= #" & Date & "#) AND (tblusers.toddate >= #" & Date & "#)") I want to be able to select records which have from date < current date...

I have computed fields on the mainform which are to be recalculated. There are command buttons on the mainform which do some processing and they are based on the computed field. So the user needs to update the subform and press the command button on the mainform . Hence the calculation requery...

Hi , I am having a problem when I try to do a refresh of the parent form (Got calculations), when I update the subform, the control of the subform goes to the first record. I want it to stay in the same record on the subform (SUb form is a single form attached to the parent form which is also a...

Can some one help? Is it possible to have MS groups from the Core tabs in add-ins? Thanks, Priya

Hi All, Thanks for this information...this will prevent me going down the wrong track!. We will be moving to Sharepoint within the next six months - probably would try then. Thanks again, PH:D

Hi, I have a few sensitive applications that I am trying to move across to Access 2007. I want to re-establish the security and in the process I want the users not to be able to access a few options in the ribbon (Create table, create forms, create queries and reports, also not allow them...

Hi, One of my clients want to be able to view Access and Gantt chart features of MS -Project.I was exploring the possibility of using MS-Project for the entire thing instead. One basic question that came to me is this - can one project file be accessed by multi-users at the same time? (like...

Hi Russ, I did get rid of the ribbon by deselecting the following checkboxes in the 'Current Database ' tab under the Office links as you mentioned: Allow full menus Allow default shortcut menus Allow built in tool bars. Once disabled, how do I enable it back? Can this be done...

Thanks Bob..will try. Priya

Hi, I have a couple of databases set up with shift key bypass and DB window hide and a couple of menu bar commands hidden (All code taken from this great forum :) ). Recently my company decided to upgrade Access 2000 to Access 2007 and they have given me a test environment and a time frame to...

Thank you...this really saved time! Thank you...this really saved time!

Hi, You could have an union query feeding into the report or have sub reports in the main report if they can be linked .

Hi, I am also stuck with the same problem. I guess the mail merge cannot handle one to many relationship. If it is possible to create one table with all the fields, then it would be possible. This can be done by VBA but I guess you may have to limit the number of fields you can have. I am going...