Search results

Computer Animation doesn't sound like a bad idea. I am looking forward to learning web design and creating flash animated sites in the future - tho im not sure what route to take to get me there.

Generally, I feel like i never learn until i actually fall flat on my face. Then i know not to go that route again. Can't be like that with everyone, can it? Or am i just stubborn cos even when the signs clearly state "do not trespass" is when Mslady loves to stroll into the forbidden ground...

Okay! I've had it! Why is crosstab query a nightmare in sql server :mad: This is absolutely ridiculous and i can't imagine why they left the feature out :rolleyes: Seeing as this is just a piece of cake in Access and it will run smoothly without pulling teeth but i am made to understand (by the...

Beloved Access gurus, I am wondering if it's possible to export specific columns into certain positions in the textfile? I haven't seen this done with Access before so i dont know. I have an access table that i would like exported periodically into a textfile (meaning, i have to do this with...

Thanks Doc_man, you absolutely rock. I was just looking for a quick and easy way like something btw: hiding the db window and workgroup security. I thought i could get away with the hassle and complication of implementing the workgroup security. On the topic of workgroup security: I have...

I'd like a code to lock a table in my access database so that it can not be mistakingly deleted by the user. It's a very basic database program i am using for basic reporting purpose. I'd like to lock the master table from the user. How can i achieve this? Any ideas?

whoah! i've seen the code and i can't understand jack! about what it's doing. i know there are different methods. but this is pretty new to me. any help in getting my Access pivot query to work in sqlserver 2000 will be greatly appreciated please :( pbaldy: thanks, i appreciate the leads. ok...

Can anyone help me convert this pivot query to work in sql server please? I'll love you forever if you help me please :pTRANSFORM Count(Employees.MaritalStatus) AS MaritalStatusCount SELECT Employees.MaritalStatus FROM Employees INNER JOIN Offices ON Employees.OfficeId = Offices.officeId WHERE...

oh waitaminute: this runs on access butnot on sqlserver...why? DELETE DISTINCTROW DOCSADM.SECURITY.* FROM DOCSADM.PROFILE INNER JOIN DOCSADM.SECURITY ON DOCSADM.PROFILE.SYSTEM_ID=DOCSADM.SECURITY.THING WHERE DOCSADM.PROFILE.AUTHOR=21941909 AND DOCSADM.SECURITY.PERSONORGROUP=4038 Line1...

you rock!! thanks :D

With this, i get the error message: "Specify the table you want to delete from".... please help. I only want to delete the corresponding records from the security table. DELETE DOCSADM_PROFILE.AUTHOR, DOCSADM_SECURITY.THING, DOCSADM_SECURITY.PERSONORGROUP, DOCSADM_SECURITY.ACCESSRIGHTS FROM...

This works perfectly. SELECT DOCSADM_PROFILE.SYSTEM_ID, DOCSADM_PROFILE.AUTHOR, DOCSADM_SECURITY.THING, DOCSADM_SECURITY.PERSONORGROUP, DOCSADM_SECURITY.ACCESSRIGHTS FROM DOCSADM_PROFILE INNER JOIN DOCSADM_SECURITY ON DOCSADM_PROFILE.SYSTEM_ID = DOCSADM_SECURITY.THING WHERE...

that's right. what can i do to make this happen? :)

This doesn't work either :eek: :mad: IF NOT EXISTS(select thing, personorgroup, accessrights from docsadm.security where docsadm.security.thing = '252600649' and docsadm.security.personorgroup = '4038') INSERT INTO docsadm.security (thing, personorgroup, accessrights) SELECT '252600649'...

why doesn't this work: INSERT INTO security (thing, personorgroup, accessrights) SELECT '252600649', '4020', '255' FROM PROFILE WHERE not exists(select * from security where security.thing = '252600649' and security.personorgroup = '4020'); But this works: INSERT INTO docsadm.security (thing...

tha's what it sounds like but when i run this, it works perfectly and does the insert! INSERT INTO docsadm.security (thing, personorgroup, accessrights) values ('252600649', '4020', '255') the above code works. Meaning i don't have the combination of those values. But what puzzles me is, why do...

The security table is made up of two primary keys: thing, personorgroup When i run this statement to insert into the security table INSERT INTO security (thing, personorgroup, accessrights) SELECT '252600649', '4020', '255' FROM PROFILE WHERE not exists(select * from security where...

wow...rural dude :D Long time!! i have missed you. I am currently a slave to asp.net, where i always pray for someone like you on those days when nothing seems to work :D Though i am faring along fine. Im hoping i'd be able to show off my application to u one of these days. I appreciate all...

There are those builtin bmp images in access e.g. delete, edit, select, filter, etc etc. I am trying to access the location of these small bitmap images and use them for a web application i am creating. Do you know where they are located? I am searched with no luck. Someone also sent me an...

.....anyone?