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

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

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

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

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

Hi, I am trying modify my forms so that I can display data like a tree view. I have a mainform and a subform. The source of the subform is a datasheet view of a query which has children linked to it. I have attached a snapshot view to this post. How do I access a field in the child in the...

Hi, I am having trouble in implementing the TreeCtrl structure. I have a simple database for testing purpose and I am not able to make it work. There appears to be a problem with the bookmark property and I get an error message: "can't Add child:Arguments are of wrong Type, are out of...

Hi, I am really sad that all my previous posts have gone..didn't ever think this could happen. Anyway, I did get my Access to SQL server conversion done. All "Yes/No" fields have been converted to a byte. This has got rid of the "-" in the "-1" field which corresponds to "Yes" in Access. My DB...

Hi, May be a silly question...I need to be able to run some initial processes (table load etc) when the user first opens the database. Subsequent users need not do this processing. How do I accomplish this within the form open module in Access :confused: ? Thanks, Priya

I am in the process of upgrading Access b/e to SQL b/e using .mdb and linked table as the front end ( as given as the best solution in many of the posts). I remember reading in this forum ( Comment made by Pat Hartman) that forms should be based on queries rather than using a filter criteria...

Hi, I have scanned through the forum but have not found an answer for the above.. How do I do a requery only for the combo box of a particular record in a continuous form? To be brief...the user has to select the pimary sector for a project . After, this, I want the next field to show up all...

I have a query set up which needs to have different criteria at run time depending on values selected by the user. If no option is specified, I need to pick up all records with 'Nulls' in them else, if date is specified by user, I need to pick up all records with date > than specified date. The...

Is it possible to alter the values displayed in a combo-box dropdown at run time. I tried using the following bit of code in a listbox's 'After Update' event , but it does not alter the combo-box's value list. dim strSponProjStatus as string dim StrNonSponProjStatus as string strSponProjStatus...

Hi, The front end of the system that I have implemented recently gets corrupted frequently when the back end remains fine. I am new to Access and I am not able to understand why this should happen. The front end has reports, forms, queries, linked tables from the back end and related VBA code...

Hi, I am having problems opening a form in a standalone second access DB using the the following code - I am able to open the second access DB but get an error indicating that ' The command or Action OpenForm isn't available now' - Run time error 2046. Private Sub Command21_Click() Dim...

Hi, :confused: I am having problems opening a form in a standalone access DB using the the following code - I am able to open the second access DB but get an error indicating that ' The command or Action OpenForm isn't available now' - Run time error 2046. Private Sub Command21_Click()...

Hi, Is there a good way of providing help to users ? Books recommend the use of 'Windows Help Workshop' - any suggestions? Thanks, Priya :confused:

I am having problems in exporting report data to Excel. The detail section of the report gets exported, but the report footer section andd group footer section do not. The command that I am using to do this is DoCmd.OutputTo acOutputReport, stDocName, acFormatXLS, , -1, "" Is there some way...