Recent content by darkhat01

Ok I tried that and it did not work.... Here is the SQL for that... "EOY Closed Report SC&A and Risk Assements" is the Unioin Query that I created. When I run this it looks the same as when I run it in the Union Query.... SELECT [EOY Closed Report SC&A and Risk Assements].IDCount, [EOY...

This does not work. It does not only show the records where the Close Date is less then or equal to The Target Date. Would you happen to have any other ideas?

I would like to count only dates where the Close Date is less than or equal to the Target Date. Here is what I have done, but it does not work. any ideas how I might get this to work? SELECT A.[SCA_Open Issue Tbl.ID] AS [IDCount], A.[Criticality of Risk] AS [Criticality of Risk]...

Thanks, that worked....

I created a union query, that shows all the Highs and Mediums. My question is if a table does not have a field that is in all the other table how do you create field and set it to High. This Union query runs, but ask me to set the value for [Criticality of Risk] on the Open AF Issues Query...

I am getting an error because the focus is set to txtExceptionName. This is an id key that is auto generated for a new recored, but I need to lock this field out so no one can change the id once it has been created. but I need a new ID created only if there is a new record being created. Any...

That worked thanks....

How do i open a website with VAB code in Access? I have played with a few ideas and noting is working. Thanks, Darkhat01

First off I would like to thank everyone that responded to this thread. Everything you all suggested got me closer to figuring it out what was going on. The resolution: It was the code. The person that added the ABC field did not add any code in for it. As I am, she was new to Access. Thank...

NEW Update: I'm getting an error message on the checkbox that I never noticed before in Access that states "control can't be edited; it's bound to unknown field 'ABC1'." Now this Field does exist, and there is no space before or after the ABC1. So this is why it is grayed out, because the...

Ok it is going to the right record, but I am still getting a "null" as it is called. Question: If the record is blank, this would be null right? 1 is on 0 is off nothing is null... There is a check mark in this record... What would cause this problem with null?

I have a checkbox that has a grayed out box inside of it. What causes this/ what is it? I looked up the record and there should be a checkmark in the box. In the table it is set to have one. I know that if the prefeances of Enables is set to No then all of the check box and the text label box...