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 Rhinorhino 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: TCARPENTER
  • Content: Threads
  • Order by date
  1. TCARPENTER

    Populating Tables with a Query

    Can't seem to find what I'm looking for - I could easily have missed it or just plain not searched for the right thing - it's been a while since I used Access... I think I'm close, but I can't quite seem to get there - but I have two tables, one is basically a lookup table (Table1), the other...
  2. TCARPENTER

    Un-Crosstab Query

    I have a table with the following fields: ModelID ArmStyle CushionCount ComponentLoc GradeA GradeB GradeC GradeD GradeE CP C 1 A 0 27 52 79 104 What I need to do is convert this to: ModelID ArmStyle CushionCount ComponentLoc Grade Value CP C 1 A A 0 CP C...
  3. TCARPENTER

    Ranking Query Almost Works

    I've pouring over everything I can find regarding ranking on scores but ties are still giving me grief. Here's my query: SELECT quniAAScores.School, quniAAScores.GymnastID, quniAAScores.Gymnast, quniAAScores.Event, quniAAScores.Score, (SELECT 1+ Count(*) FROM quniAAScores AS S WHERE S.Score >...
  4. TCARPENTER

    Summing Top Values from a SubForm on a Main Form

    I have a sub form which displays as a data sheet and in the form footer, I have an unbound text box with the sum I need, and then on my main form, I have another unbound text box with it's source set to the text box on my sub form. Then I realized I need to sum the top 4 values - not all of...
  5. TCARPENTER

    Form Changing Records on its own??

    Okay - I know I've done something stupid, I just can't figure out what... My Main form (DB Attached) has a couple of buttons on it to edit either the schools or view the scores results. When I press the "Edit Schools" button, and then return to the form Main, all seems well. If I close and...
  6. TCARPENTER

    Summing Top 4 Scores

    I have two tables, one with the school name and the other with the events, athletes, and their scores. The top 4 scores are the ones that count towards the total. What's wrong with my query - it's not returning correct number: SELECT Schools.Name, Sum(Scores.Bars) AS TopOfBars...
  7. TCARPENTER

    Select Top 1 Not Returning Correct Data

    Sorry if this a noob question, or has been covered, but I haven't seen quite what I'm after - or I'm asking the wrong thing. If I structure my query like this: SELECT TOP 1 (SELECT TOP 1 BDCComponentAttributes.Value FROM BDCComponentAttributes WHERE ComponentAttributeName =...
  8. TCARPENTER

    What's wrong with my logic?

    I'm so close on this one it's driving me crazy. I have a directory of thumbnail images I'm importing to a Power Point sheet. What I'm trying to do is build a simple grid of images based on the sheet size, image size and spacing. I'm just a tad off (especially between the first and second...
  9. TCARPENTER

    List control question

    I'm using a list control in a form with the list style set to fmListStyleOption. It works fine, except each item is being created with a dotted border around each list element. Anybody know how to stop that? It's petty I know but it's bugging me I can't seem to get rid of it...
  10. TCARPENTER

    Double precision issue

    Why does this line of code: Dim x as Double Dim y as Double Dim Rise As Double Dim Span As Double For x = -1 * Span To Span Step 0.05 y = x * x Debug.Print x; y Next x Produce: -3 9 -2.95 8.7025 -2.9 8.41 -2.85 8.1225 -2.8 7.84 -2.75 7.56250000000001 -2.7 7.29000000000001...
  11. TCARPENTER

    Monthly running total

    I hope I'm in the right spot for this... I have a small table: Account_Activity AA_Recnum - PK Tenant_Name - FK AA_TDate - Date - Transaction date AA_TAmount - Currency - Tennant amount AA_SAmount - Currency - Subsidy amount I need to create a summary query by month, showing whether...
  12. TCARPENTER

    ADO sort won't?

    I have a disconnected recordset created from entity coordinates I'm trying to sort using the sort property of the recordset. My problem is the first column is sorted, but second is left alone. Anyone else seen this before? I'm VB6 with all the latestest service packs and ADO 2.8 (I think with...
  13. TCARPENTER

    Is this possible?

    I have two tables, each with one field: Cooridinates: Field1 Order: Field1 The contents are small: Cooridinates: X Y Z Order: Ascending Descending N/A I was trying to determine all the possible combinations of XYZ coordinate sorting and I was hoping Access would create all the...
  14. TCARPENTER

    Query Question - Crosstab?

    Hi All, I've searched this over and I'm sure I'm not asking the right question. Ultimately, I want this be in a report but I thnk it belongs here...? For each file, there are 4 different flavors: Grid1x2-XY, Grid1x2-X-notY, Grid1x2-notX-Y, and Grid1x2-notX-notY. I want to place them in a...
  15. TCARPENTER

    Text box default value in a continuous form

    Ok I'm stumped. I have a subfrom displayed as datasheet with three fields I need to populate; Name, Prompt and Type. For this exercise, Name and prompt are going to be identical so I set the DefaultValue property of the txtPrompt text box =[txtNAME]. I get nothing. I tried Roy Vidar's...
  16. TCARPENTER

    Form linking question...

    Hi All, I have a main form A with a sub form B, and B has a subform C sort of like this: ________________________________________________ | A | | ____________________________________________ | | | B...
  17. TCARPENTER

    Why doesn't this work?

    I have a simple form with a combo box, and in the after update event I have this chunk of code: Private Sub cboTables_AfterUpdate() Dim rs As New ADODB.Recordset Dim cn As New ADODB.Connection Dim strTableName As String strTableName = Me.cboTables.Value Set cn =...
  18. TCARPENTER

    Side by side subforms help

    I have a form containing two sub-forms which I need linked to each other (side by side) and they are based on the following tables: ProjectTable: Project_Recnum - Autonumber - PK Project_Descr - Text Milestone_Table: Milestone_Recnum - Autonumber - Unique Identifier Milestone_Descr - Text - PK...
  19. TCARPENTER

    Percentange of Database Population (complete)?

    Hi all, I have a strange request to fulfill, the boss wants to know what percentage of the database has been populated. My first thought was to count the total number of fields, and compare the non-null fields to the total fields and just use this, but I'm wondering if anyone else has had to...
  20. TCARPENTER

    Form sub-form error: The current field must ...

    I'm having a problem with a form and subform, that I have actually been using for a while. In a subform, if I try to add a record, I'm getting the following error: The current field must match the join key 'Tools_Table.Tools_Recnum' in the table that serves as the 'one' side of the ont-to-many...

Part and Inventory Search

Back
Top