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!

Register Log in
  • Congratulations gkittelson 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: *

  1. lizzbizz

    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...
  2. lizzbizz

    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...
  3. lizzbizz

    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 &quot...
  4. lizzbizz

    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 &...
  5. lizzbizz

    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.
  6. lizzbizz

    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?

Part and Inventory Search

Back
Top