Recent content by Ray1127

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?

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

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

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

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.

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

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

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

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

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

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

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

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

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