yes, it is a newline character. The problem is that if i do a search and replace, i will be replacing the newline at the end of the line for the row that was exported and i don't want that. i just want to remove the newline character inside the string in the column. I am considering just doing a perl script for this.
Thanks.
ofilha
Last Activity: Aug 21 '10, 01:33 PM
Joined: Jul 2 '07
Location:
-
-
remove newline character from field in exported table
I am trying to export the resultset of a query to a character delimited file. I am using the wizard for this. However, one of the fields is 512 characters long and it accepts from form address. It looks like the field contains newlines, but when i look at the resultset in DB2 i don't see any newline characters, only after i copy it and then paste it to notepad or textpad. When i export the table, this field contains several newline characters.... -
how to pass a form as parameter
I am trying to pass a form as a parameter in a function. How can i do that?
I have tried function( frm as Form) then on the calling routing i try to use
private sub callingRoutine( )
Dim frm1 as Form
set frm = Me
callFunction(fr m)
end sub
This fails either on the calling routine or when i get into the function that needs to use the form. I get various errors depending on how... -
Well, Right you are. I finally realized that and have now just created a bunch of controls i need and just turn them on and off (visible) as i wish. I found a solution in this site for my problem of moving the labels to the required positions on the fly. But what i was hoping to do was to create a variable but limited number of text boxes depending on the requirements. Thanks.Leave a comment:
-
I am trying this:
for each c in me.controls
if typeOf C is textbox then
me.controls(c.t ag).visible = true
me.controls(c.t ag).setfocus //it crashes
Me.lblMoneyOrde r.top = me.txppay1.top
endif
next
I get the run-time error 2478 indicating that the application does not allow you to use this method in the current view.
I am trying to load data to the text boxes based on some...Leave a comment:
-
Thanks. I will look at those posts.Leave a comment:
-
creating controls:text boxes, labels on a report on the fly, runtime.
I have created a report in design mode. However, some of the fields i need are dynamic. That is, i have a series of fields text boxes mostly that must show up only as needed. I also have some labels that also should dynamic depending on the text boxes. I first tried createReportcon trol during the OnOpen event for the report,and when i tried to run it, it would give me an error 2147, that i must be in design view in order to create or delete... -
Thanks to all who offered suggestions. I may not be able to get back to you until this weekend,as it is not my main project. As soon as i get to work on it i will let you folks know my results.Leave a comment:
-
format a column in excel from Access using VB
I need to format a column in excel but would like to do it from Access using VB. I have hacked around and found a few ways to get to the workbook but have a problem getting to the sheet i want. But, how do i format a cell in excel from Access using VB? I have most of my vb code in access but i am running into some formatting difficulties on the excel side and want to keep all my code under Access. Thanks. -
I will give it a try. Regarding your question, i am not sure. I actually need to perform the operation on one table. I merely put the records i wanted to get the data from in another table. But what i want is to update one column in one row from another column in another row based on the content of three rows which either match or partially match each other. I hope this makes sense. The table i am working on is not indexed and has no keys....Leave a comment:
-
Error Message in Update Query.
I am getting the following error: "Operation must use an updatable query"
I am trying to update a table that has no keys. I need to update one field in one row based on three fields in another row. To make it easier i copied the rows i need to compare to another table called newtable. Then i created the following query.
...Code:update table1 set field1 = ( select newtable.acom from newtable, table1 where ( newtable.somecode="TCP"+mid(newtable.somecode,4,15)
No activity results to display
Leave a comment: