Recent content by zathrus777

I created an access query and the results are figures that do not add (i.e. give 0 totals). On analysing the file in a hex editor (desperation) each cell starts with a null which I can get rid of by selecting the cell and deleting left. Is there an easy way to remove all the null characters?

Update: it was due to the database being used. The data in a test database had become corrupted and CR/LF's were messed up. On installing again all works fine. Again thanks for the help.

Ok thats not it - I just installed the prior database version and copied the data across and it all works fine (I was hoping it came up with the same error).

johnwm Am afraid I still get errors when running it (error 91 - object with variable not set). Realised as you were sending the last reply that my hunt for objFSO was fruitless and was mid declaring. It would be nice to see what the code does but I guess not this time - cant expect you to do my...

Private Sub Command1_Click() Dim myStr As String Set objText = objFSO.OpenTextFile("c:\fred1.txt", _ ForReading, False, TristateUseDefault) myStr = objText.ReadAll() Call objText.Close For c1 = 1 To Len(myStr) Debug.Print Asc(Mid$(myStr, c1, 1)) Next End Sub Gives a variable not...

Sorry still no joy. Am using VB6 SP5 on win2k sp4 if that makes a difference. My only other references are: VBA VB runtime VB objects and proc OLE automation and MS scripting runtime (just added)

johnwm, Sorry FSO reference. The dim is coming up as a syntax error as I can't find the correct reference. The text box funnily enough works fine at work - evrything as far as I know is the same here.

Notepad shows them incorrectly whereas wordpad shows it correctly NOTEPAD:"By the end of the course you should have achieved:Improved fitness for everyday life.An understanding of the advantages of an overall exercise programme to help prevent a variety of age-related problems.Improved mobility...

Yes multiline is true in all cases. The character is what you get if you crtl+enter in access which is where the data came from.

I am reading data (text, several paragraphs long) over ADO into an array of textboxes. On one machine where there is a newline in the text it shows as a double pipe and wraps at the edge of the text box. On another it wraps and starts a new line where a newline character is. Operating systems...

I am moving a dataset from access to MySQL currently but have an issue with running a query from within access that does the bulk of the query on a remote server but takes a where value from within access. The where value is exported from an application and can only send it in access 97 format...

Thanks for that - its been bugging me all day :)

I have two colums National rate 1 and 2 which if either or both have a value in needs to have Listed in a third column else Loadbanded. This works but I cant work out why so I supect a bug: Listed/Loadbanded: IIf(((IsNull([FE_ANNUAL_VALUES]![NATIONAL_RATE1] And...

Well I managed to get this to work - can someone tell me whether they would have done it a different way? CurrentDb.QueryDefs("query6").SQL = "SELECT * FROM felearnaim;" change the query - does not update screen...

I have a dialog I have created which has a subform which I wish to change the contents of by pressing command buttons. I have the source as a query and use: CurrentDb.QueryDefs("query6").SQL = "SELECT blah blah" to change the query itself but cannot get the subform to...