Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Ray1127

    SQL Server across Domains

    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?
  2. Ray1127

    Access 2010 Navigation Form Question

    Ok never mind I figured it out. [forms]![Navigation Form]![NavigationSubform].[Form]![cbotype] That worked.
  3. Ray1127

    Access 2010 Navigation Form Question

    Did some more checking and the problem in in the Query that populates that combo box. The Criteria had the following forms!frm_Data_Entry!cbotype It's when this query runs that the error comes up. I'm assuming that this is because the form is now a subform of the navigation form so the...
  4. Ray1127

    Access 2010 Navigation Form Question

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

    Counting filtered Records on a form using VBA

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

    ReplicationID

    kjv1611 Sql Server has a datatype called Unique Identifier. When linking from Access to SQL Server that field is defined as Numeric with Replication ID in the Fieldsize. Not sure what Newid() does. Have to look that up. but did get it to work by making it a string. Thanks for that.
  7. Ray1127

    Prevent Subform from Moving to New Record

    Yes, in the Lost Focus Event of the last field on the subform set the focus to the main form. It's been awhile since I've done this so I don't remember the exact syntax but you should be able to figure this out. Last time I did this was in Access 2000 so if you have a different version there...
  8. Ray1127

    ReplicationID

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

    SQL 2008r2 Database useable with SQL 2005?

    Why? SQL Server is designed to be located on a Server with each user having their own access. Why use 2 different SQL Servers? If the 2nd user truly needs a copy of the database. Copy it within the same SQL Server and give that user access to the copy. It wouldn't make much sense to do that...
  10. Ray1127

    VBA Behind a Report Problem

    Thanks Duane hadn't thought of that the report runs fine just can't add VBA to the report. Never thought about possible corruption. I did a partial fix in that I put check boxes on a form that calls the report and set the Query to look at those checkboxes to limit the data appropriately. It...
  11. Ray1127

    VBA Behind a Report Problem

    Yes I have other reports in the same DB that have code and work fine. Yes, I want every section to have a colored background. The users will only look at this particular report on screen and their request is that it be visually obvious which record is of those types. I did bind those 2...
  12. Ray1127

    VBA Behind a Report Problem

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

    Crosstab Report Question

    Thanks Duane but I figured it out this AM. The Date Range we were using was too recent This is a medical Group and we don't receive all of the data for a period of time Usually the end of the previous month but not always it can be up to 3 months later and the time period we were using was too...
  14. Ray1127

    Crosstab Report Question

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

    Pivot Table Range

    Thanks skip. Since the data was already there in the 2 detail spreadsheets I was trying to use what was there. By combining the 2 it was simple. I guess that's why they include the Stupid when they say keep it simple. Too many people (especially me) try to complicate the hell out of it...
  16. Ray1127

    Pivot Table Range

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

    Parameter Passing question

    Added it to the parameters of the first query and runs perfectly I'll have to remember that. Thanks.
  18. Ray1127

    Parameter Passing question

    No I entered it into the criteria of the first query that's the only place it's used. If I run the first query works perfectly. run the second query again works perfectly run the third query it errors. I'll add it to the Parameters of the first query and test it. Let you know what happens.
  19. Ray1127

    Parameter Passing question

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

    Previous Record

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

Part and Inventory Search

Back
Top