Search results

I've encountered a strange problem with one of my forms. The form contains a subform in datasheet view, listing all active patients in the database. There is a yes/no field, "ActivePatient", on the subform and is displayed as a checkbox control. I have not placed any enable/lock restrictions...

Here's what I'd like to do: I want to put a list box on my form that lists a variety of commonly used "comments". The user would then select a comment, presumably click some sort of button, and the comment would be pasted into a memo field named "Comments". In an ideal version, the user could...

In the After Update event of your date field text box put this code: Me![Date].Tag = Me![Date].Value Then, in the On Enter event of the the date field text box put htis code: If Not (IsNull(Me![Date].Tag) Or Me![Date].Tag = "") Then Me![Date].Value = me![Department].Tag End If Make sure you...

What is the syntax for referencing a field on a subform? I know that for forms it is: Forms![myForm]![myControl] Would it be something like: Forms![myForm]!Subforms![mySubform]![myControl] Anyone who knows how to do this properly, your help is very much appreciated!

I can't use the Print Current Record wizard button because that causes my form to print and not my report to print...and my form does not fit on a single page...I get 8 pages with little cut-off sections of my form. Instead, I've now put a command button on my subform and it has the following...

Maybe try using the ForceNewPage property before and after each subreport (set it to yes on the section's property window). That would cause each subreport to be printed on its own page...and I assume they would then retain their 8.5"x11" size. Just a thought! Hope it helps.

Ok. This might sound a little confusing but I really need some help! I have a form containing personal info (ie. Name, DOB, address, etc.) and a subform linked by PatientID that contains a record for each visit to the clinic. The two forms are each based on a table (main form = tblPatientInfo...

Rich -- thanks!!!! It works like a charm now! Can't believe it was something that simple!

I'm trying to get the fields (text and boolean) on my form to autofill when a new record is opened. I would like each field to retain whatever value was in the previous record until the user decides to change the value. I've been trying to use the following code but keep getting error...

how do i get the where condition to recognize two different fields (Health_Care_No and Visit_No) as the criteria to open the report? This is what I have right now: DoCmd.OpenReport (rptVisitSummary,acViewNormal,,[Health_Care_No]=Forms![Clinical assessment]![Health_Care_No] AND...

I've read all the previous posts on this topic but they don't seem to work for me. Here's my problem: I have a form set up that has PatientInfo in a main form and ClinicalInfo in a subform. I also have a report that has the PatientInfo as the main report and ClinicalInfo as a subreport. I...

Excellent!!! Everything works perfectly now. Thanks for everything, Charity!

I made the change (adding & "'")and now I get an error message saying: Syntax error in string in query expression '[Last_Name]=Jones". Jones being the name that I doubleclicked on. The form I am trying to open is based on a table but only displays select fields from that table. It then has a...

D-Fresh: Thanks but I tried it and it still doesn't work. Do you think the problem is strictly with the data types? Or does having this function on a subform maybe cause some problem with recognition of stuff?

Thanks, Charity! Unfortunately, I did enter my field name properly so I don't think that's the problem ... My field name is "Last_Name" and here is the code I have entered. It matches what you suggested, doesn't it? I'm still getting those "parameter value" message boxes. Is there something...

Thanks Philip! That almost does the trick. One more thing yet! Now when I double click on the name, I get a message box asking me to "Enter Parameter Value", and displays the name I just clicked on as the message. It works if I then type in the exact same name as the one displayed. Is there...

Thanks Pat! I looked it up in help but I still have another question. The help doesn't say much about the OpenArgs section. What exactly am I supposed to put there? This is what I have so far...It doesn't run as is...it says there is a "Compile Error: Expected: ="...

Here's what I have right now. It came from the MS help article Q210236. The form I am trying to use this on is also embedded as a subform within another form. Does that make any difference? ------------------------------- Option Compare Database Option Explicit Function AutoFillNewRecord(F...

I have a subform that displays a list of records based on a query. I'd like to double-click the "Name" field and have that result in the opening of a different form, "frmPhysician", but to that specific record. Basically, I want: double-click --> open frmPhysician --> goto [Name] record What...

Thanks for the suggestion. Unfortunately, it doesn't seem to make any difference. I'm still getting a "type mismatch" error message. Any other thoughts?