Search results for query: *

I am trying to create a report of activities grouped by a Company and Month/Year but there are some month where we won't have any activites with a company and for that month it should display 0. I know crystal reports can't create a group unless there is data but I was wondering if there is a...

I have a inherited a fox pro 9.0 database where the developer instead of creating Contact Last Name and Contact First Name fields they created only Contact Name. Is there function that I can use where it searches for the blank space in order to split the contact name? Can I then add a replace...

I have a main form called Companies and two subforms in a Tabcontrol TAB1 - SubformActive, RecordSource: qryActive, Criteria: Status = "Active" TAB2 - SubfromInactive RecordSource: qryInactive, Criteria: Status = "Inactive" When I change the combo box from active to inactive on the forms then...

I have a main form called Companies and two subforms in a Tabcontrol TAB1 - SubformActive, RecordSource: qryActive, Criteria: Status = "Active" TAB2 - SubfromInactive RecordSource: qryInactive, Criteria: Status = "Inactive" When I change the combo box from active to inactive on the forms then...

I am currently using an access ADP project connecting to SQL. I have a combo boxes called LeadID to filter a form. When I select a lead number higher than 1000 I get the follwoing error: Run-time error '2001' You canceled the previous operation. I click debug and the code stops at "If Not...

I have a one to many relationship table and I would like to display the many relationship data in a report separated by a coma instead of a column. Any suggestions... Example This is what it displays now LeadID CountyName 102 Orange 102 Lake 104 Orange 104...

I created a unbound combo box using the access wizard in order to filter a form based on what is selected in the combo box. The rowsource of the combobox is SELECT LeadID, CompanyName FROM tbl_Leads_Main ORDER BY CompanyName. I want the combo box to display only the CompanyName. The problem is...

I created a unbound combo box using the access wizard in order to filter a form based on what is selected in the combo box. The rowsource of the combobox is SELECT LeadID, CompanyName FROM tbl_Leads_Main ORDER BY CompanyName. I want the combo box to display only the CompanyName. The problem is...

I am trying to create a button on a form that would simple copy the data of a query to excel and automtically saves the file to the c drive as qrylabels then execute the following code using the qrylabel excel file as the datasource for a mailmerge in word. Private Sub bttnWord_Click() Dim...

I have created a "Create New Contact Form" that I would like to add code to the load event in order make sure that it opens in add new record only. I will have a save button that when users click on it will save the record and close the form. But I want to make sure that they can only enter one...

I have a main form with a subform. User selects the state and the suform displays the contacts for that state. I would like to add a button to the main form called "Mail Merge". When users click on this button it will then create a new mail merge with the filtered list of the subform with...

I have a main form with a subform. User selects the state and the suform displays the contacts for that state. I would like to add a button to the main form called "Mail Merge". When users click on this button it will then create a new mail merge with microsoft word to create labels. I read...

I am trying to filter a query based on what the user selects in a combo box. Example User clicks button from swithboard called view list. This opens a pop up form with just a combo box called Select State. They select the state and then click on a button called "View List Based on Selection"...

I have a form by Primary Companies and a subform with the many locations of the Primary Company. These locations are by state. I added a unbound combo box that is using a state table. I would like the user to select the state and then filter the subform based on the state selected. If the...