Recent content by shauntck

Does anyone know how I might be able to capture a screenshot in VBScript. A snippet of code would be very helpful. If its not possible then how would one do it in Visual Basic Thank you in advance! -Shaunt

Hey guys, i'm looking to write an a client/server application and I need a little help deciding what technology to use. Basically the application has to take screen shots of a PC and send it to a database on a server. Any ideas how I should approach this? I'd like it to run as an icon on the...

yes, that is something i had considered. I didn't realize that there was a solution like that. So what, you add a record to the database for the username and then compare username upon change or something like that? or is there a standard way that takes care of it easier? -Shaunt

scratch that last question, it does work. The problem is i don't need the windows username necessarily. I need the name that I logged into Access using (which is hard coded in the shortcut to the database) Thanks for all your help so far. It is much appreciated! -SHaunt

Patrick, quick question... i'm trying to get the username of the person logged in to the access database in a form. This statement should get me the username i thought however, it is not working correctly. Do you know of another way to do this? sUser = VBA.Environ("USERNAME") Thanks, -Shaunt

Patrick, I think that will work for creating a shortcut to the database however, i need to have shortcuts to the specific forms in the database. Is there a way to create the shortcut to the form itself and still give it the security argument? I also need it to load the form and if possible leave...

Hey guys, i have an access database on a network and need to set up restrictions. I have done this and on my PC everything works fine however, when I go to another computer and attempt it complains the user doesn't have access. Any ideas how I can solve this? Thanks for your help! -Shaunt

Thanks man, you are very good at your SQL =) -Shaunt

yep thats exactly right! Thanks a lot. Now I'm trying to get the distinct equipments and salesords to display also. i was thinking this: SELECT distinct a.equipment, b.salesord FROM zeqld where a.equipment in (SELECT b.equipment FROM zeqld b GROUP BY equipment HAVING...

Hey guys, i've got a table zeqld(key, equipment, salesord, material). There are duplicate equipments and salesords. I need to do what seems to be a simple thing although I'm not familiar with how exactly do it. I need to get all equipments that have more then 1 salesord. In essence, here is an...

Hey guys, i've got basically 5 tables for this query. Basically I want all records from Table A and if Tables B, C, D, E have the corresponding key i want those records also. However, sometimes I will have records in B but not C, and vice versa ..or C and D...etc. So i think I want Table A...

Hey guys, I want to run a query and select a record from that query and have it load a form i created with the data populated(according to that record). I know I need a 2 forms (1 of them with the query in it and the other taking in a record as a parameter. Does anyone know how to pass a...

i don't think you are understanding my question. I want to see a list of rows by executing a query. And some how select one of the rows which would load a form will all that selected row's contents so that I could modify it. How does one go about doing this?

can you be a little more specific as to how to set this up? i'm a little new to access.

Hey guys, I'm looking for a way to query a bunch of records and some how double click (or select and push a button) and have that pull up the corresponding record in a form i created. Anyone have any good ideas as to how I should do that? As far as I know you can't have queries load forms -...