Search results for query: *

I have attached a screen shot showing the immediate window in excel, the clipboard pasted into notepad and also pasted into the attachmate window. http://files.engineering.com/getfile.aspx?folder=446638ed-0882-471f-ba38-811e5b7a99c9&file=Capture.JPG

Yes. And when i paste the info into attachmate it does not work. The first line is cut properly but the second line does not cut at the 69th character like the first.

Thank you for that code...It's in the right direction. This is the string of text i am getting in the debug window: EFF DATE: 12/14/2015 CALLER NAME: John Doe POLICY TYPE: Connections N OTES: This is an example of a note that needs to be copied into Attachmate. Currently the VBA copies each...

You are correct. If i were to just allow it to count the 1035 characters it would not work because attachmate would just cut everything after the 69th character. Is there a way to to this in VB rather than concantenating on another sheet?

Although it happens, it is not often that a note would completely fill up the space of 1,035 characters. It happens often enough that i am not worried about solving for this scenario at the moment. I have uploaded an additional screen shot of the format i would prefer the output to be in the...

When the VBA runs it pulls the information in rows 4 - 9 and row 65. In this case, yes. The code does not know to add a new line to continue with the note due to the limitations in the Attachmate window. What i may need to do is copy the text without the "VBNewline" and have a function that...

Hi Skip, The following are the links for two screen shots. The first is the Attachmate screen and second is the excel from the excel doc. http://files.engineering.com/getfile.aspx?folder=10f3b721-61df-4c96-b0b6-784a4174a5cb&file=Attachmate_PUUC_Ex1.JPG...

Hi Skip, thank you for the reply. We use EXTRA! X-treme as our mainframe system. The page that the note needs to be pasted to does not have field names. It is just a free form section for notes. I have attached a screenshot of the Attachmate screen. I added the numbers in green to show the...

Good Morning, My apologies for placing this in the incorrect forum. I will attempt to make my request more clear. If need be please move the thread to the proper thread. An excel document has been created in which a user inputs information throughout a call with a customer. Once completed...

Hello and happy Friday! I have an excel document that the user inputs information. The information will ultimately be pasted into a dos based system that keeps records of all notes for each person. The dos system note size is limited to 1,035 characters or 69 spaces left to right and 15 lines...

Ahhh Ok... I understand. That's a great idea! Thank you! Rob

Thanks dhookom for the reply. When i placed the iif in the criteria field i removed the quotations around between and other fields. I had tried using an unbound textbox on the form that included the iif statement and filled the text box with text depending on the option group selection...

Good afternoon, I have searched high an low and tried as many workarounds that i can think of... I am still in the same place as i was at 8 Am yesterday morning. I am attempting to run a query that is filtered by dates. I have a form that i have created with an option group to provide options...

Thank you all for your help. I was able to get the code to work by reworking the order i had the insert into fields. See the working code: DB.Execute " INSERT INTO tblFetchTimer (LANID,PolNum,FetchTime,TS)" _ & " SELECT '" & UsName & "', '" & Me.txtPolNum & "', '" &...

Thanks SkipVought... I will review that. Andrzajek, the first option the error is get is: Run-Time erro '3075': Syntax error (Missing Operator) in query expression 'LAST T'. Debug.Print = INSERT INTO [tblFetchTimer] VALUES ((SELECT LAST TS FROM tblPolNum WHERE tblPolNum.LANID='rlh745' AND...

Hello and happy holiday weekend for us in the US. I'm having an issue with some SQL code formatting. I am attempting to insert into a table where one of the values would be selected from another table and the remainders are set earlier in the SUB. TSsql = "INSERT INTO...

Worked like a charm MajP... Thank you!

So i have added the code MajP and it looks like this: Sub copytoVehChgtoCCP() Dim db As DAO.Database Dim rs As DAO.Recordset Dim qDef As DAO.TableDef Dim fld As DAO.Field Dim RowData As String Dim x As Integer Set db = CurrentDb() Set qDef = db.TableDefs("tblvehchgT") Set rs =...

Thanks dhookom... It was not compiling and the parenthesis are what i was missing. But i think MajP's way is going to work much better. Thanks also to MajP! I was trying to loop it but could not quite get the code to work. I will test it and report back!

Hi Skip, Thanks for the note. I'll keep that in mind. The VBA difference between excel and access are just enough to be frustrating. BTW... The solution was as simple as completely removing all the excel specific coding and replacing it with what access needs. Pretty basic stuff really but...