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

Thank you soooo much. Couple of questions: Can I force the code to stop if let say the contactname field has Dr. Michael Smith Jr. and just leave lastname and firstname blank. What I am looking for is quick fix that will take care of 80% I can manually change the other 20% who knows how many...

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

Thank you for your suggestion which is definetely much easier. I will give it try. Thanks!

How do I control the pesky user that have absolutely no idea on how access works if I don't add buttons to the forms such as EDIT RECORD AND SAVE RECORD? When I did not have these button the first record was always being changed and other records were getting edited because of user's not paying...

Thank you for the reply! The code in the Save Button is Private Sub bttnSave_Click() On Error GoTo Err_bttnSave_Click DoCmd.RunCommand acCmdSaveRecord Me.aCons_frm_Consultant_Companies_Subform.Locked = True Me.Cons_frm_Main_Sub_Contacts_Active.Locked = True...

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

Thank you for your help djj55 rs.movelast and rs.movefist did not work but you got me thinking on the right path. I added in the load event of the form DoCmd.ShowAllRecords and voila it worked. Thanks! :-)

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

OMG!!! I feel like a total.... The only way you can actually see the columns is if you view the report in the Print Preview!!!! I was always in Report View. Office 2007 has Report View, Print Preview, Layout View and Design View. The only one that truly displays the end result of the report...

Running the subreport stand alone does not give me the columns. What do you mean by "Your have this in the header on the grouping, Yes?

Yep that is how I have it set up. My problem is with the sub-report/column setup that I can't get it to display in columns. This is what I have in the PageSetup Number of Columns: 4 Row Spacing: 0.5" Column Spacing: 0.25 Column Size: Width 1.5 Height 0.1875 Column Layout: Across, then Down...

I can work with the multi-column but How do I create It? I have been trying to do that all day but no matter what I do I still get only one column ReferralID 102 Orange Lake 104 Orange Lake Polk Seminole

I am trying to apply this to a report not a query. I am currently using ADP with SQL. Where and how do I call the module. Do I call the module in the OnOpen Event of the report?

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

The combo box is working finally! I have been testing and testing for the last several hours. This is my conclusion. The problem I am having is with If Not rs.EOF Then Me.Bookmark = rs.Bookmark or with the ADP/SQL connection. After selecting several records is when I get the: Run-time error...

Same problem with the Me.Bookmark = rs.Bookmark

After selecting a couple of different records I am back to the errors of if I use: rs.EOF Run-time error '2001' You canceled the previous operation The code stops at the "Me.Bookmark = rs.Bookmark" If Not rs.EOF Then Me.Bookmark = rs.Bookmark rs.NoMatch Run-time error '438': Object...

The LeadID is a "int" autonumber primary field. The database is a ADP linking to SQL ComboBox586 Rowsource ComboBox:SELECT CodeCompanyName, LeadID FROM tbl_Leads_Main ORDER BY CodeCompanyName and the Rowsource Type: Table/View/StoredProc The record source of the form is tbl_Leads_Main and...