Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
How can I sort a n embedded structure
Hi, I have the following array and embedded structure : <pre> <cfscript> changedPracticeAreas = arrayNew(1); </cfscript> <cfloop from="1" to="#ArrayLen(SortedPA)#" index="Item"> <cfset changedPracticeAreas[Item] = structNew()> <cfset... -
Find current user in access/sql
Hi, I am having trouble assigning the current user to a control. I am using access front end and sql backend. I want to have a control do something based on who the user is. In access I can use currentuser(). This usually gives me Admin. I can also insert the current sql server user into a...- duns
- Thread
- Replies: 3
- Forum: Microsoft: Access Queries and JET SQL
-
Two users updating info
Hi, I was wondering if anyone knew how I could set up security so that it would record in a table the name of the user making changes. I have an access front end and a sql server backend.- duns
- Thread
- Replies: 3
- Forum: Microsoft: Access Queries and JET SQL
-
Subform Queries
Hi Everyone, I have a subform in a form and I have linked the child and master fields with the same field. Now what I want to do is reference the child field in a SQL query i.e. SELECT * From students where students.familyid = subform.familyid but I can't seemt to get the system to do it. I...- duns
- Thread
- Replies: 1
- Forum: Microsoft: Access Queries and JET SQL
-
How do you move data from one table to another without using a form
I have two tables each of the same format. I need them to be sseparate as they deal with forms at different stages of their life cycle. <br><br>Now I want to be able to move data from one table to another<br><br>Any ideas??
