Recent content by Palmyra

Thank you!

I have a class with many fields in it. I renamed all of the fields using the 'edit properties' for each field. It's a derived table. Now I need to add a new field and can't see a way to add that field to the class. I don't want to drag the whole class over again because I'll need to rename...

Table is updateable. Thanks.

It's a SQL table and it has it's identity seed, int, length of 4.

The below code opened a form and displayed the next sequential number on the form. The form is based on a table with an identity seed. If bolTest Then DoCmd.OpenForm "frmVoucher", acNormal, , , acFormAdd, acWindowNormal It worked in Windows XP, but is not displaying the next id in...

Perfect sense! - I'll take your advice about the coalesce. Thanks.

If there is no location in the Records table that matches a location in Records_Locations, how do I make a message display to indicate that? I though below would work, but obviously I'm off. SELECT DISTINCT Records_Locations.Location_Code, Records.opendate, Records.tkloc, CASE...

I'm upsizing this access db to SQL and migrating the site code to work with it. do you know of a way to convert queries to stored procedures automatically?

I'm upsizing this access db to SQL and migrating the site code to work with it. do you know of a way to convert queries to stored procedures automatically?

I'm upsizing this access db to SQL and migrating the site code to work with it. do you know of a way to convert queries to stored procedures automatically?

Thanks, that makes sense. But in this case, I don't have another field to ouse.

Anyone have experience using Fuzzy Lookup in SQL Server 2005 Integration Services? Is there a standard to use to return reasonable matches? I'm wading through 250,000 rows, the great majority of which are too 'fuzzy'. I've got a lot of partial word matches, of, inc., and, the... What about...

Thank you both for responding and for the info. I'll take your advice!

I want to learn to program using Java. I did some online tutorials just writing code in Notepad. Am also reading a book. I'm trying to get my home computer set up and am having a hard time even knowing what to download. There's so much information that it's overwhelming. I can't even tell...

Thank You!