Search results for query: *

Try this, =IIf(IsNull([Customer PO]) or [Customer PO] = ""),"NEED PO",[Customer PO]) Have you tried to see if this statement works in a regular query? Or if the query that the report is built upon is pulling the correct information (I know probably dumb questions, but it doesn't hurt to ask! :))

Have you checked to see if you have any zero length fields that to the naked eye would appear to be NULL?

Thank you! that worked wonderfully!!

I have a report where I have 'due dates' for projects, and I want to order by date asc. Some of the rows do not have a date provided. I want to have the report show all the itetms with dates first, then the ones with no date at the end. Anyone have an idea of how to make this happen. Many...

I'm very new to java script. But I figure I have to learn somehow. What I'm trying to do is take the inputed values from a form and print out the calcuated value. I would guess it's something similar to an order form. eg of what I'm trying to do? <FORM> <P> <table> <tr><td...

there is no lock file. That was the first thing I looked for, I should have mentioned that in my earlier post. I can see what I can do to have the admin restart the server. But I was hoping there was another way around that.

We have a database that sits on a shared directory on our server. As of last night we keep getting the following error message. Could not use H:\projects\projects.mdb file already in use. Noone is in the database. Please help! :) Thanks from all of us here trying to use the db! :)

I think my post was not clear enough. I have a emp table with a PK of empID and a manager table with mgrID with the emp_mgr table handling the many to many relationship. What I'm asking is..... when using a form to assign the relationship how would I check to see if there is already an existing...

I'm trying to assign a manager to an employee using combo boxes in a form. I have an emp_mgr table that contains the empID and mgrID. I'd like to show an error message to anyone who tries to duplicate the emp/mgr relationship if it already exists in the database. How could I do this. Please be...

Can a windows admin snoop my ssh session?

Thanks humble! I used radio buttons instead, but your post was very helpful (I was in the middle of posting my reply when you must have submitted yours! ) :)

I figured out how to do what I wanted to do. Is there a way to delete unwanted posts? :) Thanks!

Hi! I'm trying to have check boxes 'checked' or unchecked based off of values in one of my tables. I have 4 check boxes: Yes No Pending Information not in file The values in the table: 1=Yes 2=No 3=Pending 4=Information not in file How do I get the apprpriate box checked for each customer...

When I export from sql server 7.0 into Access 2000 I lose all of my primary keys and relationships? Is there a way to keep my primary keys along with the relationships so I don't have to recreate them each time? Thanks!

I did what jkurtz suggested and it worked like a charm! Thanks for your assistance!

Does anyone know why the margin settings and page layout changes every once in a while for my access reports? How can I get the settings to stay put? Thanks! Lori

I have a column that contains both last name and first name seperated by a comma. I was wondering if there was an 'easy' way to parse that column to put it into two seperate columns. thanks!

Anyone know if you can make your columns 'wrap' like how a newspaper is laid out? I have a long list of names that I'd rather have all one one page. :) Thanks!

Yep, that's exactly what I want to do.

How would you go about rounding to the thousands place in access? eg. 3600 -> 4000. Thanks for your suggestions!