Recent content by katoc

Madonnac, THANK YOU SO MUCH!!! that is exactly what I needed and it worked perfectly. i added a few more criteria (in addition to checking for 'EG') and it's just perfection. Thanks!!! I really owe you one!

i've been avoiding having to add a column to Info. Is there no other way?

Hello. I am trying to do a count and a vlookup at the same time in Excel. I have a worksheet (info): ID Date Server Leader 1 1/8/2010 EG Leader 3 1/8/2010 EG Leader 1 1/9/2010 GoM Leader 1 1/10/2010 GoM Leader 2 1/11/2010 EG Leader 4 1/12/2010 EG There is another worksheet...

It was just an example. [expiration date]-30 will get me 1/2/2013, which is fine. I just need it to be able to allow this. And Renewal Date is a calculated field set to type Date.

Hello. I have a sharepoint list where I have created a column called 'Expiration Date'. I created a calculated Date column (Calculated based on other columns) that takes Expiration Date minus 30 days called Renewal Date. So if Expiration date is 2/1/2013, the Renewal Date will have 1/1/2013...

I have been working with a database for quite a while, updating forms, queries, tables and reports. This was a Access 2000 database that I opened and edited in Access 2007. It's been working great so far, but today I hit 'Design' on one of my forms and it gives me a Microsoft Visual Basic...

I did and received the same results. Same rows. Itseems only inserting the results to a table gives me the correct result.

There is a table on the Oracle server that I link to using ODBC, OrderDetails, and another table in my Access Database that I'm using in a query together, Order. i've built this as a Query and as a recordset in my VBA code and it should return different 37 rows but it returns 37 rows that look...

Is there a way to set the Label Type in the OI file. a <labeltype> tag or something? We create many different labels and it would be nice if the physical item already knew its own label type so the user doesn't have to always select from a list. thanks!

Thanks! it turns out that I was using the wrong MediaType code.

I have created a new Physical item, called 'Video' which is not a container. The nickname (media type) is 12345 What is the correct syntax for this type of object? <node type="physicalitem" action="create"> ... <mediatype>12345</mediatype> </node> does not work.

Hello. I have a form for data entry. When a user hits 'new' but then decides to close the form before any data entry is done, I get the error "Index or Primary key cannot contain a null value". There is one value in the form that is automatically populated in the form_current function. Which...

Yes, most definitely!! Adding the me.requery (since I'm not using subforms) fixed the issue. So this means even if the sql table has been updated, the form in MS Access needs to be updated as well and the me.requery does the job. I used the bookmark property to bring the focus back to the...

I've created a form that only uses fields from this linked table. No fancy filtering. I can edit any other field (dates, strings, title, etc...), but this memo/text field is the one causing problems. I can enter data into it and next 'next record'. If I come back to it and try to edit the...

It's a SQL Server table. I previously stated it was Oracle. I was mistaken. I tried entering the data in SQL Server with no errors. The field is of type 'text'. Does that make a difference? Even if I don't insert a timestamp programmatically, it still gives me that error when I click on the...