Search results for query: *

Our Company has 2 Separate Domains 1 for Corporate and 1 for the Local Group. We have SQL Server installed in both Domains. Is it possible to Manage both from within 1 SQL Server Management Console on 1 domain?

I have an Access Database originally designed in Access 2003. There is a form that was used as the startup form. I've rebuilt the database in Access 2010. Importing the original Data, Queries, Forms, reports from the access 2003 Database. The startup form had a short delay in the form load...

I have a Form in MS Access 2010 The form has a number of fields but my concern is with 2 combo boxes The items in the 2nd combobox are subtypes of the items in the 1st combo box. When an item in the first combo box is selected the form filters the data to match the existing records. Then when...

How do I Dim the ReplicationID from a linked SQL Server Table in MS Access VBA?

I have several Access 2010 Reports. All have some Code behind the report for various reasons. One Report is give me a problem. I'm trying to set the backcolor of the Detail section depending on the results from 2 boolean fields. There are only 3 results that mean anything though. If 1 is...

I have an access 2010 Report based on a Crosstab Query. The report is called from a Form that allows the user to select which report and the date range and Preview or Print the report. the crosstab groups by Line of Business (Commercial and Senior) The problem is that some of the time periods...

I have an Excel 2010 worksheet with 3 Detail Worksheets 1 for Urgent care, 1 for Emergency Room and 1 for Inpatients. I have 4 Summary Worksheets each with a Pivot Table Summarizing the data by Month. Again 1 for Urgent Care 1 for Er and 1 for Inpatients. All work well. The 4th is giving me...

I have a form in a MS Access 2010 Database that has 2 text boxes set up to input start and end dates for a report. The report is based on a series of 2 queries. 1. Preliminary Pulls the data from the various tables and groups and counts those records. 2. Report Source is a crosstab of the...

I have a query that returns 4 fields. PatientID, Service_Start_Date,Service_End_Date,Service_Type. Service_Type can be 1 of 3 values (Inpatient, ER, Urgent care. Heres a sample Patient ID, Admit, Disch, Type, ER/Admit 1 3/10/2011 3/10/2011, ER False 1...

I have an Excel 2003 Workbook with 4 worksheets. All 4 worksheets have the same data elements for 4 different people. Everytime I try to print the worksheet I specify to use both sides of the paper so I should get 4 pages each worksheet prints 2 pages. The first 2 worksheets do exactly that...

I have an Access 2010 Database with 2 forms 1 of the forms is used to allow the user to select specific criteria elements for a Report. When the user clicks on the preview report or print report buttons the report opens and the SQL for the report is built in a module. The SQL uses the...

Is it possible to modify the Recordsource of an existing report via VBA in a form? I have a Report in MS Access 2010 that has a number of different variations. The data elements on the report are the same the differences are in the Where clause of the SQL. I have a form so the user can select...

I have a form in Microsoft access 2010 on the Form is a textbox control with the Control Source set to a text field in the table. Field size is 255 characters. Most of the records the Field contains < 50 characters but a few are > 150. For those I have the text box Can Grow set to Yes. But...

I have a form in Access 2003 the Primary key for the data table is a GUID Field. The Source of the form is a query to get all members that termed the previous month. Making sure to eliminate any members that have re-enrolled. For Example Sam Smith Terms May 20, 2011 and re-enrolled June 3...

I have an Excel Spreadsheet with 4 Columns for a bowling league. The spreadsheet tracks the Bowlers By Average Ranking them 1st to last. Heres the structure Name Average Rank Pins behind Tom 178 1 - Sam 173 2 4 Bill 173...

I have a form in an Access 2003 Database. The form has a tab control only 1 tab is currently used but more will be added later. Each tab will have a subform for data entry for each program type. The main form has the member information. Each member could be in 1 or more Programs. I had some...

I have a Subroutine in an Access 2000 Module the Subroutine contains an ADODB Recordset. The SQL that the recordset is based on always returns an empty recordset however if I take that SQL and paste it into a the Query Designer and run it without modification it works perfectly returning all of...

I have a combo box in a Form in Access 2000. The combo box Record source is a query that grabs data from 3 Linked SQL Server tables. There are 4 data elements in the combo box: ID, lastname,firstname,DOB. The ID is saved to the Table the Form is based on. This works well as long as the user...

We have an MS Access Database Originally designed in Access 2000. There are 7 Reports Each a page in a Board of Directors Report. The reports are run in a macro to generate all of the reports and then they are each printed to PDF. The 7 PDF's are then Merged into 1 Report. Is there any way...

I have a report in MS Access 2003. The query that the report is based on has a numeric field. The requirement is that if that numeric field exceeds the value 9.9 the value should be bolded. In the Format event of the Detail Section I have the following line of code. If me.txtclinicalvalue >...