Search results

  1. G

    Help with #error - NZ, Iserror, isnull not working

    wow! thank you so much!! SELECT iif(Isnull([Forms]![frmMain]![txtStartPosition1]),Null,Mid([Field1],[Forms]![frmMain]![txtStartPosition1],[Forms]![frmMain]![txtLength])) AS [Password] FROM tblProduction; =]
  2. G

    Help with #error - NZ, Iserror, isnull not working

    Hello, I am stuck. I have been trying to figure out how to get rid of #error. I have uploaded the database. When I open up the frmMail and then the qryLayout, I get #error. I know the reason why (because the textboxes on the form are blank or null. How do I get the qrylayout to display a...
  3. G

    Using Textbox to change the Position and Length in Mid Function

    Thank you, ill give it a shot!
  4. G

    Using Textbox to change the Position and Length in Mid Function

    Hello, I made the provided example simple so it would be a little easier to explain myself. haha But in reality, the length of the file is anywhere from 1 to 5000. and it would look like this 0409809238498AddressCityState120348320948AccountInfo23094LastName I have the layout for the length...
  5. G

    Using Textbox to change the Position and Length in Mid Function

    Hello, The reason for this because the length and position of the .csv is not always the same. The LastName length and position would varies from files to files. Thanks
  6. G

    Using Textbox to change the Position and Length in Mid Function

    Hello, I have a .csv file where I need to parse out the information. I have imported the .csv file into access and all the data is in [Field1] Instead of using query design, I want to create a user interface [Form] where anyone can input in the textbox the position and length of a mid...
  7. G

    VBA Mid Function Textbox

    Hello, Is it possible to create a text box where it allows any users to input the starting position and the length and have it update in the query? For example, I have multiple tables, each has different starting for Last name. I want to create a textbox where the user can change the...
Back
Top Bottom