Search results for query: *

thru sub-forms. Access 2000 on SQL SERVER 2000 using ADP. Have a main form and 7 subforms. After users put in data on main form, which is required,and use tabs to go look at the other forms, Access saves the record even tho there is no data to save. This generates many records that have no data...

Environment: Access 200 on Sql Server and using an ADP front end. I copied check box's on a form and they look greyed out but the user can still check them, and the original box is white. This means that some check box's are grey and some are white, it isn't right. I looked at all th eproperties...

I have 20 forms(based on 20 tables) that I have been asked to bhe able to create reports for. Users need to take an electronic version the the application with them when they interview clients and then when they return to cut and paste them into the app. They don't have access to network...

Not usre if this is an ADP issuue or not. Running Access 2000 on SQL Server. There are 8 forms that users would like to have the capability of printing to take with them. They can do screen printouts but they want to be able to have an electronic version of the form to be able to enter data in...

Using Access 2000 and upsized to SQL Server so this ocde was working fine in the MDB. Got a set of forms that use a query to retrieve the data/ The query is Select.... WHERE (((ADtbl.MRN)=[Forms]![PatientFrm]![MRN])); The PatientFrm.MRN is the data search criteria with the user not being asked...

Using Access 2000 and upsized to SQL Server so this ocde was working fine in the MDB. Got a set of forms that use a query to retrieve the data/ The query is Select.... WHERE (((ADtbl.MRN)=[Forms]![PatientFrm]![MRN])); The PatientFrm.MRN is the data search criteria with the user not being asked...

Using Access 2000 and upsized to SQL Server so this ocde was working fine in the MDB. Got a set of forms that use a query to retrieve the data/ The query is Select.... WHERE (((ADtbl.MRN)=[Forms]![PatientFrm]![MRN])); The PatientFrm.MRN is the data search criteria with the user not being asked...

I've writtema macro that executes a stored procedure as well as writing the stored procedure. Here's the SP in my VBA DoCmd.OpenStoredProcedure "dbo.change_mrn_alltables_sp" the procedure is : Alter PROCEDURE dbo.Change_MRN_AllTables_SP @OLD_MRN_TO_BE_CHANGED varchar(25) , @NEW_MRN varchar(25)...

I've writtema macro that executes a stored procedure as well as writing the stored procedure. Here's the SP in my VBA DoCmd.OpenStoredProcedure "dbo.change_mrn_alltables_sp" the procedure is : Alter PROCEDURE dbo.Change_MRN_AllTables_SP @OLD_MRN_TO_BE_CHANGED varchar(25) , @NEW_MRN varchar(25)...

Frustrating but the solution is simple (I Think). Running Access 2000 on Sql Server and using an ADP. Have a drop down on form, call it type - with 5 types, and when the type changes I want to insert into the table the current date into the specific typedate field. The TypeDate is not on the...

Scene: Using Access 2000 upsized to SQL Server from MDB. HAve text box's on form that when single clicked put todays date in, when double clicked sets date to null(clears out the date). Works fine in mdb version. After upsizing the first two text box's work fine in SQL server but the rest of...

Access 2002 can 'read' Access 2000 ADP ok(as long as it hasn't been converted to Access2002, according to Microsoft documentation), but if I further develop application of adp using Access 2002 - will access 2000 users be able to use it ? Probably would be best to get a copy of Access 2000 and...

Access 2000, using ADP and SQL Server. Others have developed a form with subforms using a 'tab' appearance style. When moving from one form or 'tab' to another data is saved and causing errors because of nulls in primary key field, when I haven't put any data into field but just navigating from...

Back-end is SQL Server 2000. Over 30 users want to access Access 2000 application. At work they will use ADP Front-end (Access 2000). Can they do this from home(internet) or outside of network. Can they do this without having .adp on their desktop ? How can they and also use Access ? If they...

There are over 30 users that want to access an Access 2000 Sql Server project over the company intranet as well as from their home pc's via the internet. How would they do this if they don't have Access on their home pc's ?

I cannot find where Access 2000 using ADP as the front end and SQL Server as back end has settings to allow more than one user at a time. When using MDB there is an option in Tools but not when using Project, can anybody help? I get a msg that the db will open in READ mode only when two users...