kcddoorman
Last Activity: Mar 6 '08, 06:49 PM
Joined: Nov 30 '06
Location: Indiana
-
I ended up storing the extra data in profile using Guthries method. -
Modifying and Using the Default aspnetdb Database
I have searched all over the internets for a solution to this problem and there are many ways to work around it but I'm wondering if there is a more simple solution.
I have asp.net 2.0 working with SQL Server 2005 Express and IIS 5.0. I made a page that contains the CreateUserWizar d so people can get access to rest of my applications. Using the default (asp:CreateUser Wizard) allows us to store data such as username, email address, and password... -
Content Based On User Logon Information
I have the IIS basic authentication working. I'm wondering how I can get a web page to realize who just logged on to it.
Say I have a user set up on the server named jdoe. When jdoe goes to a web page on the server that requires authentication he puts in his user name and password and the page comes up. I want the page that comes up to identify the user that just logged in (jdoe) and react...Leave a comment:
-
What is this for exactly cause I'm thinking you shouldn't do these types of things to peoples websites unless your name is googleLeave a comment:
-
Content Based On User Logon Informaion.
Environment:
Windows 2000 Server
IIS 5.0
Access 2003
IIS is set up for basic authentication. This means I can set rights for logged in users using NTFS file permissions. This all works well for simple protection of a few pages. I have several web pages that allow employees from different departments to enter order statuses, deliveries, schedules, etc. The web pages were developed using Access's data access pages.... -
DLOOKUP ! YAY
Code:=DLookUp("sku","employees","ID = [employee]")Leave a comment:
-
I tried making a query that gives me the needed data and using that as the record source for the sub form but a query doesn't allow you to add new records.Leave a comment:
-
SQL Query in a Form Control
This is a subquery sql statement.Code:expr1:(SELECT employees.sku from employees where employees.id = [employee];)
Can I get this to work in a text box control in a form?
Employees is a table.
Labor is a table that looks up data from the employee table with this lookup query;
The Labor table is being shown in a subform...Code:SELECT employees.ID, employees.name, employees.sku, employees.initials FROM employees;
-
What do most Access Developers use?Leave a comment:
-
ZOMG how did I get in here. Yes move me please.
Thanks
DAP should go in Access I guess. It may get better results in the VB or ASP section though because many of the concepts and code are similar.Leave a comment:
-
DAP Pet Peeve problem
I have a data access page that allows our dispatcher to schedule his deliveries. It is a simple page that shows the days deliveries. It shows multiple records filtered using the date field. It works great, I think, but the guy using it complains to me all the time about one thing. One days worth of deliveries is about 50 records. This makes you scroll up and down in the browser window to see all the records. When you add a new record it goes directly...Last edited by Killer42; Dec 20 '07, 01:55 AM. -
If I were to try the second method shown above using an If/Then statement to open a form to add new records how would I get that data into the field once it is filled out. I tried a afterupdate event that requeries the table but it would be better if the data popped right into the combo box.Leave a comment:
-
Very nice, Thanks a lot!
jamesLeave a comment:
-
Create new record in a drop down box.
I have a main order table that gets some of its information from several look up tables. A create a look up relationship between the two tables and that allows me to choose a record. I can create another form that allow me edit the individual lookup tables so I can enter new clients, job, employees, etc.
I'd like to add a some functionality to the drop down boxes. Can you have a "New" record in the drop down box that lets you enter... -
That's a relief. I've grown so accustom to using access and data access pages are so easy once you've used them some. I'm a linux guy though and setting up a SQL server would be fun for me.
Thanks McCarthy,
JamesLeave a comment:
-
When is a new system required?
I have developed a nice database system that controls almost all aspects of one manufacturing department. I am using microsoft Access as the database (Jet?) and I use forms to enter data. The front end is done all in data access pages hosted on an IIS 5.0 server. This allows all of the sales people to look at their orders. Everything works great, the sales people love it and my job is pretty easy. The problem is that our General Manager loves it... -
The built in filter and sort functions are great for forms. I use them everyday when looking for orders, but this function is done in a data access page. There is a record navigation control (in DAPs) that can do some of the things that the filter and sort can do (in forms). This page will be used by many people in our company, and some of them are not very computer literate like you and me. This page kind of resembles a search page they may have...Leave a comment:
-
Well, Duh. I like IF/Than/Else statements so much here I simply add this to the code and it works just fine.
...Code:If txtWorkOrder.value = "" Then myFilter = strCustomer & "AND"& strSalesPerson & "AND" & strJobName '& "AND" & strWorkOrder Else myFilter = strCustomer & "AND"& strSalesPerson & "AND" & strJobName &Leave a comment:
-
Match a Wildcard with the Number Data Type?
I'm trying to make a multi criteria server filter and everything works fine when filtering for strings. When I add a number field to the filterable set I run into problems. Here is the VBScript I'm using.
...Code:<SCRIPT language=vbscript> Function SetServerFilter() dim myFilter, strCustomer, strJobName, strSalesPerson, strWorkOrder If txtCustomer.value = "" Then strCustomer = "[Customer
-
Ok now how do you do it in a Data Access Page? Using multiple criteria to filter 1 record set.Leave a comment:
No activity results to display
Leave a comment: