Search results

Hi: I have created a query which contains a parameter. The field in the query where I entered the parameter can have 2 values--Active or Retired. Based on this query I created a report. When the user opens the report the parameter dialog box pops up and he can enter Active or Retired. So far...

Hi All: I have created a report that has 3 subreports. I wanna do 2 things: 1. One of the subreport has a date field. I want that the user should be able to enter the a date range and the subreport would display only the records within that date range. In the query on which my subreport is...

Hello Everyone: Happy New Year I have a form that has a field Opportunity type. This field is a combo box and has 2 values-- Active and Retired. Right now I just have one form, which contains all the records, i.e. both Active and Retired. What I want to do is to create 2 more forms. One form...

ok thanx I will try it.

I opened the db. You said to select the name from the combo but its empty right now. If I type in the name of the contact already in my contacts list and click on the button it says.." You can't carry out this action at the present time". What does that mean?

Thx again Autoeng I will try it and let you know. I would appreciate it if you could send the sample db. Thx a lot for your help. Ekta

Hi Autoeng Thx for your reply. I understood what you said. But I already have my form set up. I want a button next to the contact field where the user will enter contacts name and when he clicks on that button it should take him to outlook and display that particular contacts full information...

Hi Everyone I want to know if there is a way to connect the contacts stored in outlook with Access database. I have a form that has a field named Contacts Name. Now the user wants that he should be able to click on a button or on that field that would take him to Outlook and display the...

Thx Hay That's exactly what I wanted. Ekta

I have to make a report based on 3 tables. 1. tblBusinessOpportunity (OpportunityName, BusinessLead) 2. tblActionItem (ActionItem, ActionItem_Date) 3. tblNotes (Notes, Note_Date) Table Business Opportunity has a one-to-many relationship with both tblActionItem and tblNotes table. To create this...

Hi Thanx so much for the code. It works but I have one problem. In my combo box I do not display the OpportunityID because for the user it makes no sense. Instead I display opportunity name. After adding the code which you gave me I see the combo box only when I add a new record, which is...

Hi, I have a subform which has a combo box (Opportunity_ID). When the user selects a field from the combo box the rest of the fields in the subform are populated automatically. My question is. Is there a way that when the user opens a form and sees the subform, the combo box should be visible...

Hello Sara It works beautifully. Thanx a lot. Ekta

Hello Sara This is exactly what I have been looking for. I was going crazy searching for this topic in the forums. Tried all the different keywords. I will try it and let you know how it goes. Thanx so much Ekta

I have 3 tables in my database. Potential Partners Pk CompanyID CompanyName Contacts Name ... BusinessOpportunities Pk OpportunityID OpportunityName Description BusinessLead ... OpportunityTeam Pk OpportunityTeam_ID CompanyID OpportunityID ... As you can tell, Potential Partners and...

Hi I have 3 tables in my database. Potential Partners Pk CompanyID ... BusinessOpportunities Pk OpportunityID ... OpportunityTeam Pk (CompanyID, OpportunityID) ... As you can tell, Potential Partners and BusinessOpportunities have a many to many relationship. I am confused on how to...

I kinda understand it but dont know exactly how to do it. I am not very proficient in VB

Hello Everyone I have a question. I have a form which has about 15 fields including 2 subforms. Now I want to create another form where the user can do multiple keyword search based on the form I mentioned above. The user can type anything in the text field and get the result. Please advise me...

It's on the parent form. I have a combo box on the parent form. When a user selects a value in the combo box all the records related to that value are displayed in the subform.

I created a subform and I want that when the user selects a record within a subform and clicks on the command button which is on the same form it should take the user to that particular record which he/she selected in the subform. I know how to connect the command button to the form but I want...