Search results

  1. S

    Subform not displaying until Click

    I've got a form with 2 subforms in it. The fact that there 2 subforms isn't really the problem, its moreso the fact that the form does not display any data (doesn't initiate ON LOAD) until you CLICK IN it. It litterally just appears blank, then you click in it and it initiates onload (where I...
  2. S

    SQL Query Results in a variable

    I've got such a simple SQL query, but it won't output the friggin results of the query! I put the query in a "Query" in access, run it... and it outputs me a integer value. I'm running the following VBA code in "Form Load" Private Sub Form_Load() Dim strSQL As String strSQL = "SELECT...
  3. S

    Invalid Use of Null

    Hi there I'm currently running into an issue on a combo box selector form being naughty, so to speak. The purpose of the form is to be able to select a customer or a facility, that is filtered by customers (Customers and Facilities are a 1 - many with 1 customer to many facilities) When you...
  4. S

    Data Validation IF Statement

    Hi there everyone, I've got a little issue with a form that is able to be closed without it prompting me that it can't close it without required information! What I have is a many to many relationship between the following tables Contacts (TableName) ContactID (PK) Name Title Phone Extension...
  5. S

    Form based on Form

    Hi all, I've got a form that I need to be based on a table, but also based on the results of the previous form. I'll outline some tables below so you have a picture of how it works: Customers: CustomerID (PK AutoNumber) Customer_Number Customer_Name Address City State Zip Facilities...
  6. S

    Query by Contact

    Hi all, I've written a query in SQL View. To be honest, its my first SQL Query EVER and I'm very happy that it works for half of what I need to do. I'll paste the query here: SELECT DISTINCT Abs(Avg([Handoff Tracking].[Internal Kickoff?])) AS [Avg Of Internal Kickoff?], Abs(Avg([Handoff...
  7. S

    Report - Summing up Yes/No Datatype

    Hey Guys, I've got a DB that I've pretty much completed. It's a VERY basic DB with about 10 YES/NO fields. I've got a relationship between 2 tables. Table1: Contacts Table2: Handoff Form Contacts just has peoples information and that is attached to the handoff form. As you're in the...
Top Bottom