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 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: lizzbizz
  • Content: Threads
  • Order by date
  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

    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