Search results for query: *

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!

I'm populating a database field and text box on an Access form with a url address. I can cut and paste it into the address line in the browser and it works. But double-clicking on it in the Access form doesn't. Should that work? Thanks.

I've put STOP on the On Click event of a command button in order to step through the code. When I click on the button, I'm not stepping into the code. I haven't worked with Access 2007. Is something different? Thanks.

I just can't see a way to do it from the blog. The fields sort: First First First Middle Middle Middle Last Last Last instead of First Middle Last first Middle Last First Middle Last

If I have spreadsheet with data: FirstName Middle Name Last Name Mary Anne Smith John J. Brown is there a way to export it to text as FirstName Mary MiddleName Anne LastName Smith FirstName John MiddleName Jay LastName Brown Thanks.

Sorry, I never thought of doing a union, so I didn't envision the datatype problem. As far as the sequence, I did put that in my first post. I think that's all I need... Thanks.