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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Update table using report group section print event
I'm trying to update a table (DEPARTMENT) with data calculated in an unbound control in a report grouping/summary section (TOTAL USABLE SQUARE FEET). I've read numerous topics which hint at the following solution. The code would be placed in the group section print event: Dim qdf As QueryDef...- lizzbizz
- Thread
- Replies: 1
- Forum: Microsoft: Access Reports
-
Totalling 2 subform fields on main form
I have an application that tracks office space (measured in sq ft.) requirements for PT and FT employees by Department. I am trying to generate a form that shows the Department info. on the main form and then the PT employees and FT employees on 2 subforms. I want to add the total square foot...- lizzbizz
- Thread
- Replies: 0
- Forum: Microsoft: Access Forms
-
strSQL Where statement
Why won't this VB code work? I only want Jobs where the Job is not empty or not equal to an asterisk *. It crashes where I try to insert the second part of the Where statement. strSQL = "Select Job, Category, Sum(Area) as SumOfArea, ([SumOfArea])*[Forms]![Form1]![Cost] as Price "...- lizzbizz
- Thread
- Replies: 1
- Forum: Microsoft: Access Other topics
-
Variable Table Name in SQL From Statement
The following code gives me a Query Definition already exists error. How can I make it temporary (Name = "") and still run the OpenQuery command? Dim dbs As Database, qdf As QueryDef, strSQL As String Set dbs = CurrentDb strSQL = "SELECT * FROM " & Forms!Form1!MonthYear &...- lizzbizz
- Post #4
- Forum: Microsoft: Access Other topics
-
Variable Table Name in SQL From Statement
I'm new to VB programming so I want to stick with the simplest method for now. I am the user so I'll trust that I can enter the table name correctly in the text box. What code would precede the SQL statement "SELECT * FROM " & Me.Textbox1 ";" ? Thanks.- lizzbizz
- Post #3
- Forum: Microsoft: Access Other topics
-
Variable Table Name in SQL From Statement
How can I write an SQL statement where the From table name changes based on user's input into a form's textbox?- lizzbizz
- Thread
- Replies: 4
- Forum: Microsoft: Access Other topics
