Search results for query: *

Hi I am new to SQL programming and I am trying to learn the language. Someone gave me some code to use that had to be modified but I need to understand what the code is doing could someone break it down for me. What does the '" stand for and why all the brackets strSQL = AddWhere(strSQL...

I was giving some code to use for an ASP page to use a where statement on a function called Before SQL load The code is strSQL = AddWhere(strSQL, "[CareCoordinators]='" & session("UserID") & "'") I need to also have it filter by the current month to display all records by the carecordinators...

I have 2 fields both are combo boxes. I need some example code that if one combo box is null no data in it then it will set the other combo box to a default value. One combo box is populated with usernames and the other is populated with status codes like active unassigned, etc. If there is...

I have 2 fields both are combo boxes. I need some example code that if one combo box is null no data in it then it will set the other combo box to a default value. One combo box is populated with usernames and the other is populated with status codes like active unassigned, etc. If there is...

I have an access database and it also is used for some asp pages. There is a login page that was auto generated that create a session variable based on the login, again all set auto generated by the program. I want to create a reports page for users but have it pass their user id in the SQL...

I have several ASP pages that I have created from an access database. in access the database I have one form with several sub forms that are linked via master/child relationships. The form has several tabs which each tab is a sub form of the master. If you select a person in the master form and...

Hello I have an access 2003 database which I am trying to create a few access pages from a couple of queries. I can create a page through the wizard with one of the queries, however I have 2 other queries that display data that I would like to add to the page that was created by the first...

Hello I have an access 2003 database which I am trying to create a few access pages from a couple of queries. I can create a page through the wizard with one of the queries, however I have 2 other queries that display data that I would like to add to the page that was created by the first...

I have an excel worksheet that has about 10 rows of data I need to populate from several access queries. I can assign a query through the wizard for the first row and it works. But I don't have the option to assign a new query to the same column in a new row. all it allows me to do is edit the...

I have an access 2003 database we are using. What I want to do is there are reports where sometimes they want to sort by county, or country, or last name, etc and have it come up as a report they can print. I would like there to be a dropdown list where they can select the queries I created. SO...

I have a sonic wall PRO 4060. I would like to setup a DMZ. When I try to assign a static external (internet) IP address I get an error that says Subnet on this interface overlaps with another interface. When creating a DMZ do you give it an external or private IP address? Thanks

I have a question on configuring a SonicWALL to connect to a Cisco PIX I have read all the documentation on configuring the SonicWALL 4060 with enhanced os version 3.1.0.7-4e Here is my issue We have an old SonicWALL 330 and we just purchased a SonicWALL 4060. I am trying to match the...

I have a question on configuring a SonicWALL to connect to a Cisco PIX I have read all the documentation on configuring the SonicWALL 4060 with enhanced os version 3.1.0.7-4e Here is my issue We have an old SonicWALL 330 and we just purchased a SonicWALL 4060. I am trying to match the...

Looking for a example script to set ntfs folder and file permissions based on excel or csv file Thanks for any help

I need to find a way to set NTFS permissions on folders Here is what I have There is a root folder named departments; and underneath that folder are all the department folders. HR,IT,Finance etc I want to set top level folder permissions for each department. Example: HR group would have Full...

I am trying to create a security group in AD, the code below will create the group at the top OU level which is the domain, but I need the code to go 2 Ous deeper. We have an Ou called departments under the domain OU, and then under departments we have the actual departments like HR for example...

I have tried to create a script to create department folders based on a .csv file;that part works fine. I also need the script to create 3 folders under each department folder named full, read, and shared. Any ideas on how to do this Thanks Here is the code Set objFSO =...

I have some code that will create an Active Directory OU underneedth the parent OU, however I need it to go one level deeper. My directory structure is setup with the following OUs Domain OU Department OU and then the departments(this is where I need the new OU to be created Example...

I have been given this script to modify and use in my environment, however I don’t know to make it work I have 2 OUs in Active Directory called Finance and HR. The purpose is to have a form that HR can use to create new users when they are hired and place them in the department for which they...

I have had no luck with this I need to create a form or script for the HR department that will allow them to do the following when a new employee starts Create a new user account in AD (First name Last name, Username) or have the code auto create the username from the values from the first and...