Thanks for the quick response, NeoPa,
No, it's not alternate ones. The report is about 80 pages long and it can go 10 pages without the shading. And almost exclusively it's because of a duplicate social security number. Thanks again!
Accrj19
Last Activity: Jul 16 '15, 03:28 AM
Joined: Jul 27 '10
Location:
-
Access 2010 Some Lines On a Report Are Shaded but I can't tell Why
Hi All,
I have inherited an Access 2010 Database at work and I need to change some of the reports.
I'm stumped. Some of the entire lines in the detail sections of the reports are shaded but I cannot find the code that makes it happen. There is no Conditional Formatting for any of the fields and there is no code in the "On Format" event for the detail sections. And there are no class modules.
... -
Hi, zmbd,
The database was originally written in Access 97 and upgraded to 2010 (I had no part in either process). I made some major changes to the database and fear that I decompiled incorrectly.
All users are using 2010.
Thanks for replying!...Leave a comment:
-
Rabbit,
Thank you so much for responding. Sorry I haven't responded sooner but I have been away from my job for the last week.
But your answer got me to think simply. I check for a null value and the beginning of the function, and exit if null. It seems to work.
I'm still perplexed as to why the functions are not executing in the same order but I have so much on my plate at work, I can't spend too much...Leave a comment:
-
MS Access Invalid use of null error
I inherited a database at work and everything was working fine for about 4 months. All of a sudden, I started getting an "Invalid use of null" error when I tried to open an unbound main form that contains a bound subform. The subform has a query as its data source.
After many hours of analysis, it turns out that on the subform there is a text box whose control source property is a function. This function is being called... -
Why use autonumber as a primary key
Could someone help me understand why using an autonumber field as a primary key is a good idea?
If you use an autonumber as the PK, won't that allow the possibility of duplicate data being entered into the database? For example, if I have an Orders table, an order could be entered twice and each of these records in the Orders table would have a different autonumber but it would be the same order.
I hope this makes... -
Accrj19 started a topic Users Have Different Versions of MS Access for a multi-user database applicationin AccessUsers Have Different Versions of MS Access for a multi-user database application
I have a multi-user database application in Access 2003. Where I work, some users have Access 2003 and some have Access 2007. When users with 2007 open the 2003 database and someone with Access 2003 is in it, the 2007 user receives an error message. Currently the database is not split. It is one .mdb file on our network.
My question is, is it possible (and recommended) to have a back-end Access 2003 database where multiple users... -
In the criteria box (assuming you're in query design view) try <> "Standing Order" Or Is NullLeave a comment:
-
I'm not sure I understand what you are asking, but you can create a form with the RecordSource = table you want to update.
Then you can create textboxes on the form where the Control Source = field in the table you want to update.
Then you can type in the values in the texbox(es) on the form and it should update the table.
Hope that helps.
BobLeave a comment:
No activity results to display
Leave a comment: