Search results

Hi, Is there any formula to get the last date of the previous quarter. I need to display the aging value and need to compare with this date. Any help please?

The Status field contains other values(not only Completed). I need the Closed Date value to be entered as there are some reports and stats based on the date.

I had tried inputting the below vlaidation in the validation rule. However it didnt work(though didnt error also) ([Status]="Completed") Or ([Closed Date] Is Not Null) I want to user to enter the Closed Date field...mandatorily if they chose the Status as Completed. Since this was not...

I am currently calling the code from the AfterUpdate event of the form and is passing the focus on the control. However my problem is that the user can goto the next record by clicking OK to the message I have dispalyed. Is there any way to mandate that the user enter the value of the field...

Hi, I have created a valdiation rule in VB to validate one field based on the value of anotehr field. The code works fine and I am displaying a message also to the user to enter the value. Now this is the issue........the user can click Ok on the message I display and go to the next record...

Hi, Currently I have a VB code which sends emails from access 2007 on the click of a button. For this I am reading the email adress from a filed which the suer have to enter. Could anyone help with with a code which will connect to the Outlook and get the email address based on the...

Thanks a lot for the help...I sent the frontend file to all users using (after splitting the database). The errror is not coming.

So is there a way that I can avoid this message being shown, even after splitting the database?

I have split the database still the same error is coming...please help.

No the database is not split

Hi, I am currently using a access 2007 database. When multiple users are accessing the file and trying to make changes to different records in the database, the below error message is coming. "Microsoft access cant save design changes or save to a new database object because another user has...

Thanks a lot...that works. You are just rocking. I changed what you said to the below. It is assigning the name of the tab to the textfield and I am then sending the text field value to my query Forms!OpeningForm!mytextbox = Forms!OpeningForm!TabCtl0.Pages(Forms!OpeningForm!TabCtl0).Name...

I have a combo box on each tab that I want to sync based on name of the tab. I just though either of the below methods can be used.(please correct me if I am wrong) 1) To assign the name of the tab clicked to a text box on the main form.So that I can then use then pass the text box value to the...

I think I didnt explain my issue clearly. I have the main form (Opening form), which has multiple tabs in it (Tabs are name say A1, A2, A3..). When I click on each tab there is a drop down displayed(I have the drop down value retrieving value based on a query). Now what I want is that when a...

Thanks for the reply. I tried using the below as a arugument to the query. Here OpeningForm is my form name, TabCtl0 is my control tab name where different tabs are defined. In my query if a field value is equal to the below value return values to the drop down list is what I have done...

Hi, I am new in Access 2007. I have created a form which has multiple tabs created. I one of the tab I have created a button, when clicked it executs a report, based on the value of a field in the tab.(currently I have put a default value for this field, which I want to parameterise). Now...