Search results for 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...

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

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

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

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

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

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 =...

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

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

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

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

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

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

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

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

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

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 =...

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

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

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