Recent content by kitty77

  1. K

    form to form value

    Perfect!!!
  2. K

    form to form value

    I have a form (main) that has a command button that opens (bulk) another form (specific record) based on field [IDnumber]. How can I double click on a field on the bulk form and have it populate a field with that value on the main form? I can make it work if it's on the same form but not to...
  3. K

    Event Next Record

    Got it. Thanks.
  4. K

    Event Next Record

    What event would I use if I wanted something (empty an unbound field) if I go to the next record?
  5. K

    combine fields with return

    I actually put it in a command button onclick. Works just as I need. Thanks again...
  6. K

    combine fields with return

    Perfect!
  7. K

    combine fields with return

    I see. I will try another way then. Thanks.
  8. K

    combine fields with return

    How do I break this line into two lines. I tried _ with shift enter but I get an error. ="Username: " & [Username] & Chr(13) & Chr(10) & "Password: " & [password]
  9. K

    combine fields with return

    Ahhh. Thanks!!
  10. K

    combine fields with return

    I would like to combine four fields (path, password, username, name) into a unbound text box. But I would like them to be stacked. So, need a return after each field. I tried Chr(10) Should look like this... path password username name
  11. K

    Multiple Dates

    Null. Thanks!
  12. K

    Multiple Dates

    I'm using the following code in a query but can't seem to get what I need... Date: IIf(Not IsNull([Manalysisdate1]),[Manalysisdate1],IIf(Not IsNull([Manalysisdate2]),[Manalysisdate2],IIf(Not IsNull([Manalysisdate3]),[Manalysisdate3],IIf(Not IsNull([Manalysisdate4]),[Manalysisdate4]))))...
  13. K

    less than date

    Damn, thought I tried that. Thanks!
  14. K

    less than date

    I'm working with a datesent field in a query. I do not want records from today and less than 14 days. So, I don't want to see records from 3/18/22 to 4/1/22 Not Date()-14 like this?
  15. K

    lngLookup in multiple fields

    Well, the code I'm using now works perfectly. When a user inputs a value in that field and it already exists, I get a message. I'm not looking to redesign, just to want to know if I can make it look at the value in the other fields too.
Top Bottom