Search results

I have a table with a multi-field unique index: PatientID TestId TestDate Examiner The problem is, date and/or examiner can be blank until that information is updated. I want those null values to be understood as actual values so that multiple instances of that "waiting to be updated" record...

I have several tables of test scores(Test1, Test2, etc.). I want the report to contain these scores as well as their percentile ranks and descriptions. I have created a table of all the possible scores and their corresponding percentiles and descriptions(NormsTable). I have been having...

Also, now I am occasionally getting the following error message when I try to view the report: The instruction at "0x77fcc37c" referenced memory at "0xfffffff8." The memory could not be "read." Click Ok to terminate the program. I click Ok and then this comes up: The instruction at...

They do... Wais and Wisc I have checked their names as controls on the form and as stand alone reports and they are different both times. Is there any other place a report name is stored where they might be the same?

I have a report with two subreports. The first one is ok, but the second subreport's source object changes to that of the first subreport when I save the main report. I change it and it changes back. My report is rejecting this source object like an organ of the wrong blood type. I must be...

That did it! Thank you!

I've tried the code in the main report and subreport OnOpen and OnActivate events. Same story.

Do not attempt to control visibility of subreport controls from the main report. Control subreport controls from the subreport itself. This is what I was doing the first time. When I do this and open the subreport on its own, it works beautifully. When I view it as part of the main report...

Object does not support this property or method. I get the following error and no results with or without using ".value": Object does not support this property or method. Any thoughts?

Trouble applying this to subreports I was able to use Pat's code to hide fields when there is no data and eliminate wasted space and it worked perfectly. Now, however, I want to use that report as a subreport. On it's own the visible/not visible issue still works, but when I open the mainform...

Does anyone know how to change a field FORMAT default? I am creating lots of tables with lots of number format fields. I don't, however, want a zero default value (or any default value for that matter) for all of these fields. I can go in and delete them manually, but that seems like a...

Thank you so much--that is so incredibly helpful!

Ok, my problem is most definitely that my update query isn't running as a result of my code. It runs fine when I double click the query manually. What is wrong with my code? Private Sub FullNameLink_AfterUpdate() Me.Form.Refresh DoCmd.OpenQuery "StudentFullNameQuery", acViewNormal, acEdit End...

I've been trying a few more things without any success. That latest thing I've tried without success is putting this code in the after update event of the unbound link control (=[StudentFirstName & " " & [StudentLastName]): Private Sub FullNameLink_AfterUpdate() DoCmd.RunCommand...

No, I didn't rename anything (but I will use that naming convention in the future). The query is an update query that creates a StudentFullName field from the first and last names. It is followed by an append query to add the student to other tables since the full name becomes the identifier...

Thank you--that is good advice for the naming convention. Sorry I am so lost with this stuff. I am struggling with getting my query to run with the new data before anymore forms are opened. I tried using this code in the open form command button code, but nothing happens--not even the form...

Ok, apparently I just needed to take out the "txt" and now the form opens. The problem is getting my StudentFullNameQuery to run after the record is saved but before the new forms are opened. At least I think this is the problem. Right now the new forms will open, but to a blank record...

Ok, this does sound less complicated than I was making it, but it's not quite working yet. I am unable to open the form and when I try to open it manually I get this error "Compile error: Method or data member not found" and this is highlighted: .txtStudentFirstName from the code you posted...

I originally was going to just have a message if the names were incomplete, but only because I got that working without pestering anyone, not because it's the best option. I tried preventing them from editing the name and the problem was, you could misspell a first name, start typing a last...

Almost there... Thank you for the reply Pat! I think I need to explain a little more about what goes on with this form and simply what I am trying to do a bit. The code didn't quite work and I can't figure out how to make it work. Each record has fields for first and last names and then a few...