Search results

  1. I

    Using Variable problem

    Thanks pbaldy the fields are identical in each table and combining them with the extra field to show what type will solve many of my problems Thanks again i appreciate it
  2. I

    Using Variable problem

    Thanks pBaldy i appreciate you taking time to help I have another question in regards to your potential normalization comment I have 3 lists i want to populate with records from 3 seperate tables, 1 list for each table (tblWeapons, tblArmour and tblVehicles) i have one query to manipulate...
  3. I

    Using Variable problem

    Hi have tryed googling for answers and also looked for related topics on forum and this best ive come up with Dim mystr, myvar myvar = "Wep" mystr = [myvar] & "No1Label" Debug.Print mystr and that displays correct but when i put it in code like [myvar] & "No1Label".Caption =...
  4. I

    Using Variable problem

    Value is the variable and all instances 4 instances of it Dim Value Value = "Weapons" Me.ValueList.RowSource = "SELECT tblValue.Name FROM tblValue; ValueLabel.Caption = "Att"
  5. I

    Using Variable problem

    I have been trying to workout how to use a variable "Value" in the codes below but everything ive tried returns syntax error can someone show me correct syntax please Dim Value Value = "Weapons" Me.ValueList.RowSource = "SELECT tblValue.Name FROM tblValue; ValueLabel.Caption = "Att"
  6. I

    Sum problem

    Select Case solved the problem Do Until rs.EOF CountListHeight = CountListHeight + 1 total = total + rs("No") rs.Edit Select Case total Case Is < 500 rs("Include") = rs("No") rs.Update Case 500 rs("Include") = rs("No") rs.Update Exit Do Case Is > 500 total = total - 500 rs("Include") =...
  7. I

    Sum problem

    Above code has a bug in If statements If the last rs("no") read brings total to 500 then this If total <= 500 Then rs("Include") = rs("No") fires then so does this If total = 500 Then Exit Do but it exits do and doesnt update the rs Ive tryed changing things around but cant get it to...
  8. I

    Sum problem

    Here is the code and it works pretty good so far thanks to Jal I had to modify the If statement a little cause it kept updating the last recordset read on the table If anyone wants to look at db i wouldnt mind some suggestions on how i can reuse this code for my Armour table and Vehicle table...
  9. I

    Sum problem

    Thank you Jal Your help has steered me in the right direction i think and also helped me understand recordsets which till now i wasnt sure how to use. Your code is pretty close to what i was looking for and once i have it working how i hope it to i will post it Thanks again for your help
  10. I

    Sum problem

    Its for a combo box on a form qryArmour SELECT Armour.Name, Armour.Attack, Armour.Defence, Armour.[No] FROM Armour (table) ORDER BY Armour.Attack DESC; I only want the combo box to display the Armour with the highest attack values but limited to 500 total number of armours (confusing myself...
  11. I

    Sum problem

    If item3 was 11 i would end up with field1 field2 item1 17 item2 23 item3 11 item4 4 and item5 wouldnt show because i was only after 55 items
  12. I

    Sum problem

    Hello Im new to access and uptil now have only used the help files to find my way around but i havent been able to solve. Here is the query example hope it makes sence field1 field2 item1 17 item2 23 item3 12...
Back
Top Bottom