Search results for query: *

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

Paul, Thanks for the additional tip, I'm not running a stored procedure but just the update statement in the code. When I do need to do this would it be just me.requery ? Is there any other commands to the code ? How about with the controlname.requery ? By the way is that the syntax controlname...

Paul, one quick last question. how can I put the code on two lines so it can be viewed easier ? Does it end with some character ?

None of the fields are required at the table level, they are optional at this point. If I'm working on an existing record and usingthe code you provided - it doesn't work. I need to save the record to have it work.BUT I did find what seems to be working, using the code you provided I added it to...

Paul, I tried what you wrote and now I'm getting "write Conflict messages" and Im asked to save or drop or copy to clipboard. This is happening before I finish entering the data on the form. The Type is not the last field on the form.

When the form opens we are either adding a new record or could be updating an existing record.If it's new then the accountstbl won't have it until we leave the form(so it seems). Whenever the Type field changes we want to insert into the accountstbl the current date. This way we can track the...