Search results

Just another quick (I hope:)) question... I'm importing some information into a contact list from an old table, and I just realized that the names in the old table are stored as one string, while in the new one I need them in two seperate strings. I'm using an append query to bring over some...

I have a 'Contacts' table, which holds contact names and numbers for a bunch of companies and i'm brining this info over from a number of different tables. I need to allow the same name to appear more than once, but not associated with the same company. I'm using a (relatively) simple append...

Is there a way to turn off the confirmation boxes when I run query? You know, the ones that say 'You are about to update/delete/whatever to blah blah blah.." with the OK buttons.. I'm making a bunch of automated querys run, and its really annoying to have to click through all those damn 'OK'...

I set it up like you suggested, except I used a Right Join instead of a left join.. And everything seems to be working fine.. I can't beleive that I forgot about the different types of join AGAIN! Its starting to become a bad habit with me.... Thanks for all the help guys, you're the best...

Worked like a charm :) Thanks alot.

Okay.. I think I got this sorted out.. I had to add a new entry into the 'NAICS Codes' table though.. I added a code for '0' and set its entries to be something like 'Unknown'.. Then I ran a query to update all the null values in my 'Company Information' table to 0.. So It lists all the...

Okay... I setup the form so its source was a join query and based the form off of that, but I've run into another little snag, some of the companies dont have NAICS information filled in, and now they aren't accessable.. Is there a way to tell it you want to show all records even if some of the...

I've got a list of companies, and a form to edit their information. But I also have a list of communications with each company (with name of contact, date, etc..) in a seperate table. I'm trying to figure out how to create a button on my form that will bring up another form to add a new contact...

Heya all, just had a quick question (at least I hope its quick)... I've got a database I'm working on here that holds some information about companies, names, sales, etc... There's a specific field that holds a classification number (NAICS #). The NAICS Sectors (General Categories) and...

Yeay!!! It worked :) Thanks a lot.. I really appreciate it....

Hello.. I'm just getting a handle on all this Access stuff (thanks mostly to these kickass forums :) )... And I've run across a little problem... I'm updating a database that stores information on various companies, and the table that stores the company info has a field called [Company Sector]...