Search results

  1. S

    Renewed concatenation issue

    Bob, I just emailed to you. PS - I see you play several instruments. I play guitar. Elecric and acoustics blues is a passion. --Steve
  2. S

    Renewed concatenation issue

    The FE alone is 1.3MB.
  3. S

    Renewed concatenation issue

    Yes, I did C&R first.
  4. S

    Renewed concatenation issue

    Both zipped together.
  5. S

    Renewed concatenation issue

    My zip file is about 1.5 MB.
  6. S

    Renewed concatenation issue

    I can zip it (FE and BE) and post. But I'll have to also write a long explanation of what I am trying to do. Is that ok?
  7. S

    Renewed concatenation issue

    Yes. I did.
  8. S

    Renewed concatenation issue

    My f8 key does nothing.
  9. S

    Renewed concatenation issue

    But I'm sorry... I do not know how to do this.
  10. S

    Renewed concatenation issue

    Rich, I only did it because I thought the original topic was getting confusing. I am able to get this concatenation to work as I stated above with an onclick event of the field. But oncurrent of the form still does not work.
  11. S

    Renewed concatenation issue

    For whatever reason I cannot get debugging to work. But let me say this... if I put the following code in an onclick event of the field, "txtCombinedCbxRecordInfo", which is the field I am trying to populate with the oncurrent event of the form, IT WORKS!!! Here is the code that is workig on...
  12. S

    How concatenate into one field?

    I do not know how to do what you are suggesting. Sorry. Can you assist?
  13. S

    How concatenate into one field?

    I have tried everything I can think of. So, one more time... here my my entire code block from the on current event. Could there be a conflict of some sort between the first block of code which I've had all along and this new block of code to attempt to accomplish the current desired result...
  14. S

    How concatenate into one field?

    When I select a record in the form, frmJobCards, nothing is being filled in in the field on the form named "txtCombinedCbxRecordInfo". Secondly, I wish I knew more about breakpoints, stepping into, etc. I don't even know where to begin.
  15. S

    How concatenate into one field?

    Ok. Here again is what I have so far but still isn't working... Dim rst As dao.Recordset Dim txt As String If Not Me.NewRecord Then 'open a recordset on the child records of the current record in Me Set rst = CurrentDb.OpenRecordset( _ "SELECT [Core Sand Type] " & _...
  16. S

    How concatenate into one field?

    Here is my code so far but it isn't working. Can you spot what I am doing wrong? (copy and pasted below) Dim rst As dao.Recordset Dim txt As String If Not Me.NewRecord Then 'open a recordset on the child records of the current record in Me Set rst = CurrentDb.OpenRecordset( _...
  17. S

    How concatenate into one field?

    I have a form named "frmJobCards" which is bound to a table named "tblPartsMasters" On the form is a listbox named "List1". This listbox is bound to a table named "tblCbxNumberData". Each record in the table named "tblPartsMasters" can have more than one associated record in...
  18. S

    Checkbox to let user know if photos exist in a folder

    Actually, the --- " & Me.txtPartN & " --- part of the code is the folder name. Then within the folder the --- *.jpg --- part indicates the files in the folder. So I do need the *, correct? (I did try to remove it and it still didn't work.
  19. S

    Checkbox to let user know if photos exist in a folder

    I am trying to make a checkbox on a form check (be true) if a certain folder on the C drive of the user's computer exists and if any jpg files are in that folder. The following is my code of the on current event of the form. But it is not checking the checkbox when jpg files do exists in the...
  20. S

    Filter records using selection from a combo box

    I have a form and the form's control source is "tblProjects". By default the records are shown in ascending order by "ProjectID" from the table. But I'd like to add a combo box to the form which when the user clicks the drop down arrow, "ProjectOwner" from the table appears. I know how to...
Back
Top Bottom