Search results for query: *

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...

Annoyingly this works but I cannot find the correct objects to define it. I need to use option explicit and dont like not knowing how things work. I gather it is a DAO type as it is using * instead of % as a wildcard but am not sure Dim dbs As Variant Dim rscheap As Variant Dim...

t strike - I have tried the double quote thing but still get nowhere. It just seems to ignore the quote when added in. VBA jock I haven't got yor version to work yet as I have been getting my docmd version of the routine going. I have a workaround for the offending query of running the design...

vbajock The code you give baulks at: Dim oConn as New ADO.Connection Compile error, user defined type not defined. When using the locals window it shows up my SQL command as: : CommandText : "SELECT ID, A14 FROM felearnaim Where (errors like '%"a14_%')" : String It produces...

am afraid this produces the same result. I am thinking its a problem with the references I havce setup in tools and wether I am using ADO or DAO. Could this be the reason? I need to produce this datbase and currently I am just going to have to have a load of queries sitting there being run by...

On talking to collegues it seems that the setup of access may be at fault here as others use wildcards and quotes normally - could this be the problem. Am using ADO 2.1 and access 2000. Any help appreciated.