Search results

  1. Y

    Unique field for table with foriegn key?!

    If Field C of Table 2 is the Primary key then yes. The Primary Key in field 1 of table 1 will correspond with Field B of Table 2, however Field C of table 2 can not have duplicates
  2. Y

    Query return the same record many times over.

    Okay, now that I've had my morning jolt, reverse what I said earlier. When I run the same queries I get only one record with an INNER JOIN. Like so... SELECT Piping.Comp_ID, Query1.Comp_ID FROM Piping INNER JOIN Query1 ON Piping.Comp_ID = Query1.Comp_ID; With a left join i get multiple...
  3. Y

    Form not saving back to table

    No worries. In the design view of your form, when you look at the text part of your field, Does it say Unbound? In other words, is the data you want to show in your table, linked back to your table?
  4. Y

    Need Help! Generate query based on columns

    You can make import the spreadsheet to a table, then make a table using a query for the first week, then append to the same table for each subsequent week like so First Week Query: SELECT Table1.PartNo, "Wk1" AS Week, [Table1]![Wk1] AS QTY INTO NewTable FROM Table1; Second Week Query...
  5. Y

    Form not saving back to table

    Do you have unbound fields in your form that are making calculations? This could be why the data is not reaching your tables
  6. Y

    Query return the same record many times over.

    Can you also post the query sql?
  7. Y

    Query return the same record many times over.

    Sounds like you are looping through each occurrence of the same value to the outside table. Check your sql statement for which JOIN you are using; and I have a feeling you will find an INNER instead of a LEFT or RIGHT
  8. Y

    Can't Navigate Records On Linked Form

    In the design tab of the main form, you can select the subform name in the property sheet. Once the subform property sheet is selected, you can find the Link Master Field and Link Child Field properties under the Data Tab. Enter the Patient ID Carrier fields properly here. In VBA set...
  9. Y

    Can't Navigate Records On Linked Form

    Can you explain more, please? Is this a form to subform situation? Are you trying to query the recordsource from one to another?
  10. Y

    How can I find the 2nd Business Day of the Month?

    Not sure if you are trying to search the current date or you just want to find the correct day of a given month Here is what works for me. Hope it helps you in some way. Private Sub SecondBusinessDayOfTheMonth_Click() Dim PretendMonth, WhatDayIsIt As Integer Dim PretendYear As Long Dim...
  11. Y

    Printing Report/Sub Report

    Hi all. I have read from this site many times and am very thankful for the many well written responses to various questions. Okay, I have a head scratcher. I have a form and a sub-form, linked by EmployeeID, where the sub-form contains multiple records for each employee, for example multiple...
Back
Top Bottom