Recent content by 0110

But my issue is that I have a Quark Document that is 1 meg, when I send it to the ColorPass Printer, and look at it through the dialog box, its 10 megs and it rips one kilobyte at a time, which takes it forever to print out. Is there some kind of setting that needs to set. I'm now looking to...

I use 4.1 and 5.0 and my OS is XP. Every time a send a Quark File to the Cannon ColorPass z-40 printer, it takes forever to rip. A Document that is 11 megs, turns out to be 45 megs when ripping to the printer. Is there a reason why adding photos increases the file size so dramatically, even when...

OffID and LocID is not always the same, majority of the time it is, But out off 300 employees, about 10 work in a differnt location. Here is the example Employees FirstName LastName JobTitle OffID LocID Peter Jones Manager 3 5 John Smith Supervisor 1 1 Mary...

Thanks Jim, But the OffID is different than LocID. What do I need to do now? You are a great help Thanks again.

I really appreciate all that you are trying to do! This database is huge, too many tables to list, so here are the ones that I use. Again, I'm a beginner at this so I hope this is what you meant for me to post. SELECT FirstName, LastName, PX1, JobTitle, OffID, LocID FROM dbo.Employees WHERE...

That is a good idea, but I wouldn't know how to do that, but even if I could, the database does have a table that named Offices and fields OFFID and OfficeName, but I need the field LocID, which is not part of that table. How do you do the IF statements? Carrie

Will this update the database? I don't want to change the database, I'm trying to create a database driven website that will show the employees Name, Title, Extension, and where they are located. For some reason our company uses numbers to label our offices, I want to be able to change that...

I have a problem, my company created a database that lists employees and what office they are from. Well they used an OfficeID number. How do I convert that number to state which office they are from. Example If OffID = 1 then I want it to print "Celina" Is there a way to do this in...