Search results

  1. O

    result from a query to specify string to use

    The reason for not wanting to store the values is purely as I didn't need to store any data as I am writing a textfile and once that is written I am done so everything was in memory, and it keeps things simple and quick. I wanted to hold the backup field option in a table so that unskilled users...
  2. O

    result from a query to specify string to use

    Sorry for any confusion. Yes there is only 1 backup option per customer, and no the backup option could be the same for multiple customers. I have looked at the dlookup examples you have given me and incorporated that into my function and this works as expected as it does return the correct...
  3. O

    result from a query to specify string to use

    Hi vbaInet, The dlookup will only return 1 backup option but the criteria is needed to filter down to that 1 record. using the above function as an example this would be my table: mytable [customer], [Backup Option] cust1 backup_option1 cust2 backup_option3 The dlookup from my example will...
  4. O

    result from a query to specify string to use

    ok this should be a really simple bit of vba to show what I am trying to do. apologies for the generic term code. Function myfunction() customer = "cust1" original_choice = "" backup_option1 = "ABC" backup_option2 = "123" backup_option3 = "XYZ" If original_choice = "" Then...
  5. O

    result from a query to specify string to use

    ........ code code code ........... backup_option1 = "ABC" backup_option2 = "123" backup_option3 = "XYZ" ........... more code more code........ If original_choice = "" Then my_backup_option = DLookup("[Backup Option]", "mytable", "[Partner ID] = '" & customer & "'") MyResult = '//here i...
  6. O

    result from a query to specify string to use

    Thank you to you both. I am indeed using this value in code. But the value I seek is not in the table but is in the code. I am reading through some text files and storing data in strings and if a string is empty then I am wanting to use a backup string for the data. But the backup string I use...
  7. O

    result from a query to specify string to use

    I have a query that returns the string to use but I am not sure how I can actually use the returned value to do what I want. e.g. my table: Partner ID Backup Field 5023949 UPC 501354 GTIN my query will return 1 [backup field] value from the table above, and I then want to use that value to...
  8. O

    Is this form layout possible any easier?

    that did the trick. Thank you very much DCrake that code is soo much simpler and looks a million times better. Thank you again
  9. O

    Is this form layout possible any easier?

    that did the trick (for extracting)
  10. O

    Is this form layout possible any easier?

    i tried opening with xp and get a corrupt message? what os was used to compress? maybe an xp/vista compatability issue?
  11. O

    Is this form layout possible any easier?

    thank you dcrake but the download says its corrupt? or empty?
  12. O

    Is this form layout possible any easier?

    yes, there is a table that has a list of users and each of their status's (i.e. in or out)
  13. O

    Is this form layout possible any easier?

    i have created a small db that shows the status of a user (if they are in the office or not for the receptionist) but the way i have created the form is very very long winded using 60 queries at least and lots of messing about. see here for the db -...
Back
Top Bottom