I am entering (typing) data in a form that I see in the table but not in the report. All the other fields (Datepicker, yes/no check marks, combo boxes and fields lists are showing. What happening here? Thanks.
I am entering (typing) data in a form that I see in the table but not in the report. All the other fields (Datepicker, yes/no check marks, combo boxes and fields lists are showing. What happening here? Thanks.
Is your report based on a Named Saved Query Object? Open the query in DS view and look for the data there? If the field is there and the data is not, consider criteria and JOINs used in the query. If the field is not in the query, add it.
Fields and data are in the query. The join is working because I am getting the yes/no, combo boxes, dales from the date picker, and list box.
If you want to provide db for analysis, follow instructions at bottom of my post.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Zip file attached
I can't run either report because missing table 'Absences'.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Sorry. Here is the DB with absences.
Neither of the queries that the two reports are based will run. There are fields described in their SQL statements that are not available to the query.
Why do you have comboboxes in your reports?
Thanks for the SQL heads up. The combo box is on in the table, query, form; how else will I get it on the report?
I am not quite sure. I do not use lookup fields. The value stored in the table should be the index of the lookup field. So if your second option in the field is "Car" the value would be 1, I believe.
When I print reports, I use controls like text boxes and labels. I do not use combos, option groups, and listboxes. Maybe a select case statement in the format section where a textbox control resides.
Select Case Me!LookupField
Case 0
Me.UnboundControl = "Truck"
Case 1
Me.UnboundControl = "Car"
Case 2
Me.UnboundControl = "Van"
Case Else
Me.UnboundControl = ""
end select
The combo and list boxes on report are correctly showing data for each record?
Are these combo and list boxes RowSource based on ValueList or Table/Query?
I have never used combo or list boxes on report. I do not use lookups in table either, especially if the lookup involves alias.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
They are RowSource based on ValueLists.The combo and list boxes on report are correctly showing data for each record?
Are these combo and list boxes RowSource based on ValueList or Table/Query?
I have never used combo or list boxes on report. I do not use lookups in table either, especially if the lookup involves alias.
If I have combo and list boxes in my talble and need to print that data on a report, how might I do that?
Not sure what you are telling me, but I will play with this. Thanks.
Now I am having another problem. Whenever I drag a check box to my report it shows as a text box, but in the table, query and form it shows as a check box. In the table the format is True/False, Default Value = 0, Indexed = No, Text Align = General, Display Control = Check Box. Why is this happening?
Don't know why issue. I just tested and checkboxes show on my report just fine. Since can't open your objects (except in design view) because of missing tables and forms, can't analyze.
If the comboboxes are ValueLists and therefore saving text descriptor values, just use a textbox on report.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.