Database is making a strange mistake

[NFF]

I am running an Access database created by a friend and we're stumped. When I enter a horse's name and birthdate, everything looks great until I produce a pedigree for a horse.rptPedigree.pdf. Hopefully the pedigree attached. If you open it, you will see Sun's Delight D. and his birthdate is highlighted in yellow. When I generate the pedigree report, the birthdate has been changed. He was actually born in 1959. No matter which horse I try to generate a pedigree for, that same "cell" comes up with the wrong date. I'm somewhat computer illiterate and have no clue how to fix this. Would appreciate simple to understand step by step instructions.

[ranman256]

The report is interesting, knowing how Access prints reports.
We would need to see the design of the report.
I would think something is hard coded.

Are the records put into a 'report ' table?

[NFF]

Wish I knew how it was built. I have no idea and can't seem to find where this is generated. I tried to print out several other pedigrees and it's always that same "cell" of the pedigree that gets messed up.

[ranman256]

you cant look at the design?
the source query?

[NFF]

Like I said, I'm fairly computer illiterate. I can populate the cells once the program is built but I don't know where to look to be able to fix the mistakes.

[ranman256]

we can only help if you provide the design, or the actual database.

[NFF]

I really don't want to post the whole database here. Looked at messaging you and there isn't a provision for attachments in messaging that I can see

[isladogs]

Unfortunately, you can't attach files to private messages - forum software restriction

The report design is unusual & would be interesting to look at.
Open the report in Access (not the PDF version); right click on a blank area on your report and select Design view

Then take a screenshot by pressing the PrtSc button on your keyboard.
This saves the screen to the clipboard
Next open Word or similar & paste in the saved image, save & upload the file here

[NFF]

[ATTACH]31866

I hope this works

[isladogs]

That's a good screenshot of your FORM but it's the REPORT we want to see
Now click the button & open your report - then go into design view for that ....

However, we'll probably also need to see the underlying data to make any sense of your question

EDIT - sorry didn't see pg2 of your PDF - you should be able to get to design view by right clicking
If not it can be done from the navigation pane

BUT the data is going to be needed as I said before

[ranman256]

right click on the report, design.
then see what your field is connected to.

[NFF]

I tried to do that and the program won't let me see the design. When I right click on the pedigree, I get a + or - to make the print larger or smaller, that's all.

[SierraJuliet]

Just a few ideas here (#3 first):

1. Check your table Field Properties for both General and Lookup (located at bottom of tables). Of course that is if the data is correct up until you attempt to print the report then move on to next step.

2. Open your report in Design View and look at Property Sheet under Event tab for [Event Procedures] so you can evaluate a possible coding issue in the VBA (if any) and then look under the Data tab > Control Source and Input Mask. Lastly if your report is based on something in one of your forms then repeat the same process but for the form related to the report that is generating the anomaly.

3. "Convert Report's Macros to Visual Basic" and I would honestly do this step first ()because I have had MANY / ALL issues where my forms would go bonkers and it was a macro issue that was resolved when I converted them all for every form and report. When you convert the macros they are automatically added into the VBA Editor for each form and report but you have to open each form and report and manually hit the convert button (Ribbon Bar: DESIGN > Convert Report's Macros to Visual Basic [all the way to the right]). Also, you may need to edit the converted macros as some of them are disasters, just FYI.

[SierraJuliet]

I tried to do that and the program won't let me see the design. When I right click on the pedigree, I get a + or - to make the print larger or smaller, that's all.

If you cannot see / select Design View by right clicking on the top of report (i.e. bar area containing minimize/close) and selecting it (or like the image below) after opening the report then see Method #1 below:



Method #1. DESIGN > Property Sheet > All
*ensure you have report open in at least Layout View using the same methods described before. If unable to do so then skip to Method #2*



Method #2. File > Options > Customize Ribbon



Now repeat the aforementioned steps.