Search results

  1. A

    sqlstr in a loop

    thanks, i'll download that and have a look at it. This is just a first prototype of the database. theres more bits and pieces been and yet to be done. i think this way is long winded, yet clever. probably not the most efficient but still like you say, whatever works. you never know, your...
  2. A

    sqlstr in a loop

    oh totally. but for some reason the block technique wasn't working it crashed the form several times over amongst other things, and i can honestly say there was nothing wrong with the string itself as it was checked over and over by a number of people including myself. i was told by my manager...
  3. A

    sqlstr in a loop

    it works right across... bit of a development of my own code and what was provided... this is how i've done it (i'm sure there are way better ways to do this) Private Sub Save_Click() Dim fieldname(48) As String Dim strSQL As String Dim NameOfField As Variant DoCmd.SetWarnings False 'just fill...
  4. A

    sqlstr in a loop

    i have woken up this morning and i have managed to get it to work with one field. i'm not going to attempt it with all the fields to see how i get on.
  5. A

    sqlstr in a loop

    oh i've only put one variable in cause i didn't want to spend ages putting them all in to find it didn't work
  6. A

    sqlstr in a loop

    this is what i've got... when i have managed to get it to run it hasn't updated anything Dim fieldname(50) As String Dim strSQL As String Dim NameOfField As Variant fieldname(0) = "CallHandler" For i = 0 To 50 NameOfField = fieldname(i) Debug.Print NameOfField If i = 0 Then strSQL = "UPDATE...
  7. A

    sqlstr in a loop

    ha... just to add... so would i :P
  8. A

    sqlstr in a loop

    it keeps coming up with expected array warning and i don't know why
  9. A

    sqlstr in a loop

    yeah i didn't think the SQL string would like the use of an array name for some reason. I'll give it a go let you know how i get on.
  10. A

    sqlstr in a loop

    oh. the form has 50 fields with apparently more wanting to be used if the use of a tab function is authorised for part of the form.
  11. A

    sqlstr in a loop

    basically i was presented with the database and told to edit a form so it is in a snapshot. The form itself is unbound to control sources. The fieldnames hold the same names as forms from a table but it is unbound. Some fields reference different tables using record sources but not the one the...
  12. A

    sqlstr in a loop

    i cannot. Mainly because i've left the version i was editing at work quite stupidly. I can assure you there was no syntax errors, because it got to the stage where i was adding field values in one at a time checking them for errors one by one. At one point a comma caused a bit of trouble before...
  13. A

    sqlstr in a loop

    no it is a blank form for people to enter details in. It is a snapshot of the table rather than a dynaset. i'm talking alot. The problem is that whenever the sql string runs with all the fields going at the same time it seems to either throw out an error or in the worst case crash the database...
  14. A

    sqlstr in a loop

    I've been given a theory to work with over this weekend in office 2003 i have a form with alot of fields. Its been a pain. its crashed the form etc etc basically all the field names in the form are the same as the table and what i was wondering if rather than having them all in a massive SQL...
  15. A

    Validation rule first three letters + 8 number

    i need a validation rule i have a field that needs to get the first three letters from another fields value + 8 numbers for example Product = Funtime Frank ShortCode = Fun12345678 the colours are just there to demonstrate what i mean this is my validation rule like Select Left...
  16. A

    remove a single item from a combobox

    Cheers, i got it working in the end. just changed the way things will work. makes it more simplistic. i now have another problem i shall post
  17. A

    remove a single item from a combobox

    i have a combobox with brings up 4 values. The combobox rowsourcetype is table/query. so for example say i have in this combo box values 1,2,3 and 4. I then have a pop up box saying 'is the record you want to create value 4?' If yes then type 4 successfully is slotted into the combobox, which...
  18. A

    Coloured fields, access rights, open forms depending on subform

    I actually have the first and third parts done. the second part i think i have the answers for as well. I'll let you know over the next week, one way or another. I was making things alot more coplicated than need be. thanks all the same though
  19. A

    Coloured fields, access rights, open forms depending on subform

    i've been issued with a new problem now and i was wondering if you could help me. Firstly apologies if i am breaking any forum rules, or if this can be done without VBA. I've got a form. The form is a searcher. It uses 2 drop boxes and a set of radio buttons to pull up fields in a subform...
  20. A

    populate array with a loop

    I'm pretty certain i did this in VB.Net in university, i know VB is a bit different but is it possible to populate an array using a loop?
Back
Top Bottom