Search results for query: *

I'll send you a t-shirt if you can draw me a map to that 'safe place' where i left my brain...

Yuppers. It's an oracle 10g db and i know that when i report using crystal i have to discretely deal with nulls in formulas. So a little bit of panic and uncertainty set in because i have data processes running, i went back and started checking and realize that most of what i do is based on...

First Duane and PHV, I have seen your names all over this website :)and want to thank you for responding to my query on queries and in addition to your responses to other questions people have posed. I appreciate your contributions very much. Now, before when? Before Access 2007. However -...

this is my original query. so when i look at you and duane recommended it should be (pt_s_lit.STATUS_CD) &"" <>"Approved" ? i guess my fundamental question is why do i need to do this now and haven't had to do it before? is there a setting that i have inadvertently set that makes this...

Thank you for responding and i am still having issue. so if i find a setting within access 2007 to convert all nulls to zero length i should be able to use the <> syntax? hmmm... below is a screen shot of the area i am talking about. this is just using their simple querry that i use for quick...

What have I done? And what do I need to do to go back to my simple syntax in a simple query? I enter <>'Approved' and it returns an empty set when I know that 25 out of about 200 records have that value. If I enter Is Null in the field I get the values that are essentially not approved. It is...

One of our admins runs processes from access dbs. Yesterday she opened a database and there were no macros or modules. Thought it was a fluke and requested a restore from back up. This morning she was checking on another database and found the same thing. Two days in a row, two different...

I have an access database. I can have it loaded onto a Citrix server so folks in three time zones in the US as well as London and Australia can access it. There won’t be many users at one time – but there will be updates by multiple people at the same time. All the other db’s I have done have...

Okay - last update. I have been able to get it to work without closing the form. I don't know why when I closed the form it didn't free up the table, but I believe that was the issue. I had the records locked on the form - and even though I closed everything it held the table in the backend...

Another update. I changed the form to lock on the edited record and it didn't give me an error. so now i can access the table. Will try to untangle the spaghetti to get something cleaner. Also - i closed the adminMain form from my question above. and found that even with all the forms...

I will add something else, because it does seem unusual that the table won't allow me to edit when I have closed everything. In the database I also have a 'dashboard' if you will of the different items that need to be reviewed. It is a series of labels formatted to look like hyperlinks (I know...

Thanks ZiggyS1 and Fretwalker for your responses. Sorry for the delay getting back as i actually took the weekend off. Miracle of miracles. The original form for review is locked. However I am closing that form when the user clicks the update button and pulling up table 2 in a form that is...

Thanks so much for your response. I need to have the second table as we are comparing old values with new values. Some background: we have a magic number of 25 defects that can be addressed in a bi-monthly rollout. There will always be 25 Active defects that are being worked on and 25 open...

I have searched the forum for information and I have tried events on multiple forms to the point that I have confused myself inside out. I know it has to be easier than what I have been doing which is sub forms, on load events, on open events, closing the main form and opening a duplicate temp...