Search results

Is there a way to assign a subroutine (which I have written already) to an unbound text box? I need that textbox to display a number of different things as determined by other fields in the report. I know this is not very descriptive but I just need to know I am not trying to do the...

Enjoy!

You are correct as well as lucky as hell. Enjoy the sunset. It took me awhile to recreate everything ( as well as the one to many relationship between Patients and Transactions) but now everything is working properly. Thank you all for your help. CJ which beach are you on?

Sorry if I have confused the issue. My client is a friend of a friend of mine. I do not do this professionally as you must have figured out by now. The tables are Patients, Transactions, Services. Patients is related one to many with the Transactions table via the Patient Number field...

Actually, what is needed is that there are Patients who are described for Insurance purposes as a certain code (service code). But these service codes also includes various other things like "no payments", "lost checks" etc etc. So most of the time the transaction is just the service code...

I promise I will keep my hands off the stove. Building the query was easy. I think I did not "build it wrong" Thanks for your comments.

I know it is against the laws of dbs to store data in two different tables. I have been told this for a number of years. But the person who asked me to do this for him is a doctor, not a db pro. He wants a transaction table where he can look up the various people who have come to his office...

Maybe I should have been asking "How do you populate more than one field from a combo box on a form". I had been using the combobox to display 3 fields, only one of which is stored in the table after choosing it via the down arrow on the CBO. The other two fields I had wanted to store in their...

Form Allow additions - Yes Form Allow edits - Yes I have tried the control source for each of the fields in both these ways Control Source Lastname Or Control Source =[Lastname] Form is not base on a query Just a table (Transactions) No input masks. Do not see a Recordsource property...

I just stepped through the code in the debugger and got the "unable to assign a value to this object" there. Didn't paste it into the immediate window. Thanks.

Can I paste the code into the immediate window and step through it there? Tried that and got a "You cant assign a value to this object" Runtime Error 2448

That is the only code I have. Did not include any error handling code (would not know how to write it) Will see what the debug line shows and report back. Thanks.

Both of the values are blank on the form. Nothing is displayed on either Lastname or Firstname.

Nope, Same Null values in both.

Will try it. Thanks.

I have a combo box on a form which displays Id, Last and First names. I want the CBO to save the Id and fill in the Last and First names in their respective fields on the form. This is the code placed in the On Change event of the CBO. Private Sub cboPatient_Number_Change()...

Thanks everyone. This is new information to me. I will remember the [tablename].[fieldname] vs [tablename.fieldname] info.

That worked. Wow. Why? I thought it is necessary to reference the table + field to properly point the source where it needs to be. Guess not. Thanks alot for your help.

I used the expression builder and chose each field from within it. Didn't spell it out longhand at all.

Trying to create a report in which I concatenate a First Name and Last Name. Should be textbook simple. This is the code =[Patients]![Firstname]+" "+[Patients]![LastName] which I put in the Control Source field for the text box . Tried it with & and +. What happens is when I change from...