Recent content by kensaffer

Thanks you for the reply. The user is not typing anything into the form BUT because it is a subform and there is an identifyer for each record, Access assumes that since the user is on that form and exiting the form, that it must save data. The only thing saved is the identifyer, all the other...

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

Thank you for the tip BUT nothing happened. Actually the sam ething happened as before where no data was retrieved and when I ran it in Query, I was not prompted for an MRN. So this didn't work

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

Thank you for the reply and help. What would the code be to ask the user to enter the @OLD_MRN_TO_BE_CHANGED ( a parameter)? or to use your example, to ask the user for a date when executing a stored procedure without a form ?

I ran the code you rpovided to see if it workls and I get a type mismatch on thios line: Set param1 = cmd.CreateParameter(, adDBDate, adParamInput, , "10/1/2001")

I ran the code you rpovided to see if it workls and I get a type mismatch on thios line: Set param1 = cmd.CreateParameter(, adDBDate, adParamInput, , "10/1/2001")

Thank you for the reply and help. What would the code be to ask the user to enter the @OLD_MRN_TO_BE_CHANGED ( a parameter)?

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