Search results for query: *

Billsecond, How many records are you looking to Zip4? I'm in the Direct Mail industry and we regularly provide this type of service for customer data files we are going to presort and mail. However, this process(ACE) also alters Addr3(if exists), Addr2, Addr1, City, State, and Zip. Meaning...

ca8msm, I just tweaked a little code per the FAQ and things are working perfect. I'm so stinkin' pleased, your getting another star. If it weren't for the code sample you provided, this would not have worked for me. Thanks a million! David

Ca8msm, Terrific FAQ, Rated it a 10! As I'd mentioned earlier, I am a newbie to VB and greatly appreciate your time. You've earned a STAR! Hey Beef, I did search all of what you've suggested, but apparently not well enough. Thanks, David

Well, being such a newbie to VB I'd like to populate the datagrid with code. Would you be mind pointing me in the right direction, a jump start of sample code? Thanks for the reply. David

Hello, I'm not new to SQL Server, but definitely new to VB.NET and need assistance populating a DataGrid. I've constructed an app with a connection string and all works fine. I know this by purposely passing the same code I would using Query Analyzer to my app and having no errors, but...

yksvaan, I just happened to check this after many days. I've already tried all of what you suggested before my post, but nothing seems to work-I've given up! I'm just not sure it's actually possible without someone actually having done this. Thanks for the post. David

Hello, I did finally end up with the later of Vongrunt's suggestions. Identity insert was set to off (a cut and paste issue) but I appreciate the pointer. Had I not figured this out and neither of you posted, I'd be going mad about now. Thanks for both responses. Have a good weekend. -David

I belive you're looking for this: Update Items set itemshipper = b.custshipper from Items a inner join customer b on a.custid=b.custid Be sure to BACKUP before conducting any updates as a rule of thumb. Found that out the hard way! -David

I'm trying to write a trigger to insert TblB from TblA, but not if that record already exists in TblB. Each table has a different structure, but with some identical columns (those I'm looking to insert) having same datatypes. IDNum is an IDENTITY Column. It won't fire unless its a straight...

Wow! How flattering! I never had the need to insert multiple columns into one. I did concatenate the strings into a single column in another table. Are you saying my group by clause should stack the data in my one column table ? If so, I definitely could use some help with that part. D

EdwinGene, Having some trouble accomplish this, please help. David

That thought actually came to mind after your post and I thought you might say something along those lines. However, I'm just not quite sure how how to do it. Don't tell me, let me work on it and I'll post in a bit. Thanks, David

It's not in label format, that is the problem. It's standard data format. idnum carrier_route name company ,etc How do I get it to that format?

I've been trying to export a table with Carriage Return Line Feeds to output in Label Format. I tried adding the numeric equivalent of a CR LF, but won't alter data. It simply exports the file as usual. Data needs to appear like so to run on our inkjet machines in the production dept...

Nuts!!! I should have thought of that! I've been using virtually the same thing for one column. Greatly appreciated. David

Point taken, but would you mind giving me the update?

How can I update tbl1 from tbl2 (both having the exact same structure) all in one step? I can do it a column at a time, but can't quite seem to nail it down all at once. IDNum, Company, Contact, Addr2, Addr1, City, State, Zip, Zip4 on both with same datatypes. David

Wow!!!! Been swamped and just logged in. I new it was something fox2x. Tested with success. Thanks to all for your response. David

Hello all, My manager is stuck on Dbase III plus. That being said. . .Does anyone know what the command is? I'm exporting from SQL Server as dbase III, but it will not open using dbase. I can, however, open it with VFP? I'd appreciate your input. David

ciproectadina, I just searched on 'Disable Foreign Key Constraint' and came up with this thread, it may solve your problem: thread183-129511. I've not seen this person post before, but seems fairly knowledgeable. David