Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by HelloWorldGuy

  1. HelloWorldGuy

    Text import works manually but not with VBA script

    [shocked]and to be clear, my table IS called tblSN137 and my tDoCmd.TransferText acImportFixed does reflect the correct names of tables/import specifications.I was just going to post general code and neglected to change those "tblSN137"s [sadeyes]
  2. HelloWorldGuy

    Text import works manually but not with VBA script

    I am beyond confused. When I do a manual import of this data into a new table I have no serious issues. Only when I use transfer text I get numerous erros and a mostly blank table. I am using the saved import specification of the manual import. Also, I am clearing out the table with VBA to do a...
  3. HelloWorldGuy

    import .txt file parse via new table?

    No it is spaced.
  4. HelloWorldGuy

    Adding a dash to existing table field?

    This is all around handy. I could use this often in the future. I'm still new to SQL so this really helps. Thank you Golom!
  5. HelloWorldGuy

    import .txt file parse via new table?

    I feel that the best way to explain this is with a little background. I was tasked with importing some .txt files into an Access database. The method I chose was to import the stripped data into a new .txt file and then into the database via DoCmd.transfer. This works great and I have no issues...
  6. HelloWorldGuy

    Adding a dash to existing table field?

    Ah, yes. That is exactly what is happeneing. Best solution, new import specification?
  7. HelloWorldGuy

    Adding a dash to existing table field?

    after some consideration I have one issue and am not sure what's causing it. with: UPDATE tblSnapshotMASTER SET ITEM_NUMBER = Mid(ITEM_NUMBER,7,3) & "-" & Left(ITEM_NUMBER,6) WHERE Len(ITEM_NUMBER) = 12; where my output: R51-[highlight #FCE94F][/highlight] T5820 why is the space there I...
  8. HelloWorldGuy

    Adding a dash to existing table field?

    Great eyes, Golom. Thank you PHV! You guys are awesome. Everything is running great! Going to do some data validation just to be safe but it looks awesome!
  9. HelloWorldGuy

    Adding a dash to existing table field?

    No worries, I started using copies.
  10. HelloWorldGuy

    Adding a dash to existing table field?

    The result is the table view of MyTable with a field Expr1000 where cell A1 has a 0. My process is to create a new Query, go to SQL design, enter statement, then run.
  11. HelloWorldGuy

    Adding a dash to existing table field?

    Not sure why but it says it's updating 0 rows...
  12. HelloWorldGuy

    Adding a dash to existing table field?

    So it would be like this? UPDATE MyTable SET ITEM_NUMBER = Format(Mid(ITEM_NUMBER,6,3) & "-" & Left(ITEM_NUMBER,5) WHERE Len(ITEM_NUMBER) = 11 Implementation should just be ? 1. New query 2. Design view 3. input statement Would you advise trying it on a copy tbl?
  13. HelloWorldGuy

    VBA text manipulation

    Amazing! Thank you!
  14. HelloWorldGuy

    Adding a dash to existing table field?

    That syntax was corret, however I was wrong about functionality. What I am actually looking for is a SQL query statement that will Before CS220061000 T5325204000 14W47163000 TBR20131000 05226R52000 After: 061-CS220 204-T5325 163-14W47 131-TBR20 R52-05226 After a search I'm not seeing...
  15. HelloWorldGuy

    Adding a dash to existing table field?

    Hello, I'm pretty new to Access and am trying out some new things. I want to add a dash to a table field data like : Before: CS220061000 T5325204000 14W47163000 TBR20131000 After: CS2-20061000 T53-25204000 14W-47163000 TBR-20131000 the field name is ITEM_NUMBER I'm thinking about a Query...
See more

Part and Inventory Search

Back
Top