Search results

  1. S

    Add a letter to the beginning of field

    When I run a query I want to preceed the result of one of the fields with the letter V. ie. the field reads GH567Y and I want it to read VGH567Y Thanks
  2. S

    Select a row from a listbox

    Could someone please help me do the following. When I open my main form I would like the focus set on a listbox and the first row being selected. I can get the focus set Me.List39.SetFocus but how do I select the first row?
  3. S

    Refering to a particular column in a list box

    I want to be able to use the different columns from a list box. ie. I wand to creat a calculation based upon the data in column 2 for one feild then use the dat from column 3 for a differnt calculation. I can use the bound field for one but the how do I refer to a different one? I have a...
  4. S

    How do you remove the first character

    Not working Just tried it and does not seem to work perhaps you could tell me the complete syntax. the field of the original data is PartNumber and the data is in different lenghts the new field needs to be called new thanks
  5. S

    How do you remove the first character

    Hi, can anyone tell me how to remove the first character of a field when viewing data in a querry. ie original data- V00366L2336 new data - 00366L2336
Back
Top Bottom