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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: fredpeters555
- Content: Threads
- Order by date
-
DOCMD.GOTOCONTROL subform to form
I have: a mainform called fScoutTrees a subform called qt2000Info subform7. When a subform field Text9 Gets Focus I want to auto-go to cmdAdd in fScoutrees Using DOCMD.gotocontrol, I cant get it to find the control!! Help Just remember...they're only ones and zero's you're playing with. Fred- fredpeters555
- Thread
- Replies: 3
- Forum: Microsoft: Access Forms
-
Code to send Form data to Query
I have a radio group 'frView' on a form that a user selects the conditon of a field he wishes to filter, displays the results in textfield 'txtViewName1' for the user to view. The query then calls the results of 'txtViewName1'. Codes for both the form and query follow. Although I get the...- fredpeters555
- Thread
- Replies: 4
- Forum: Microsoft: Access Modules (VBA Coding)
-
Send Form Field toQuery
I have a radio group 'frView' on a form that a user selects the conditon of a field he wishes to filter, displays the results in textfield 'txtViewName1' for the user to view. The query then calls the results of 'txtViewName1'. Codes for both the form and query follow. Although I get the...- fredpeters555
- Thread
- Replies: 1
- Forum: Microsoft: Access Forms
-
Calculate Weekday Diff
AAAAACKK" says Bill the cat! I need to get the balance of work days left in the current month but I can't even get the number of weekdays beween two hard coded dates. It just wants to return weeks. <% var1 = "5/10/2004" var2 = "5/12/2004" Response.Write("var1 to var2 is " &...- fredpeters555
- Thread
- Replies: 5
- Forum: Microsoft: ASP (Active Server Pages)
-
Format numbers in a string
I have a data string inside a control that contains text as well as field data. I would like to format currency, % and dates within the string. It is as follows: =Sum([Expr1]) & " or " & ([text5]/[text6]) & " % " & "of Inventory has not moved since " &...- fredpeters555
- Thread
- Replies: 2
- Forum: Microsoft: Access Forms
-
Worksheet Renaming
When I rename a worksheet in an unprotected book, it autoinserts .xls in front of the new name and then returns a renaming error upon 'enter'- fredpeters555
- Thread
- Replies: 10
- Forum: Microsoft: Office
