Search results for query: *

Thanks guys i got it working Thanks again Nick

Hi cheers Dont suppose you could point me in the direction of a tutorial or similar cheers Nick

I have a query based on a set of constraints entered by user in text/combo boxes. However when i run the query i get the following error message Runtime error '3065' cannot execute Query I have run the sql threw the query wizard and it works there but not in the module code **************...

Thanks for the help was beign really stupid hadnt set it to double. Thats the prob after working for 8 odd hours straight seem to miss stupid things thanks again nick

I put a breakpoint in before the insert is done to display the contents on strSQL and it contains the data in the right format without any rounding but still rounds it when it inserts it into the db. # Nick

I have an insert statement that doesnt quite work right ************** Dim strSQL As String Dim antpost As Double strSQL = "INSERT INTO shiftcalculations VALUES (1111, " & Me.Ant_PostShift & ", " & Me.sup_infShift & "," & Me.right_leftShift & ")" CurrentDb.Execute strSQL...

HI i know this tread is from a while ago but was wanderign if is is possible to do the same (Highlight a row)not based on the unique id. In a form i am displaying it doesnt have a unique id of such. It has a cust_id but this occurs many times for each customer and i am displaying all the...

Thanks for all you replies got it working using the example code supplied the error was stupid sorted it out had put one of the field names in incorrectly. Thanks Again Nick

have been looking at the function posted would i put it under the report or as a seperate module? Have tried as both but put out an error as the value nick

the field is empty as to say there is no value there on some occasions but on others there can be Ill give the ideas a try thanks for your help will let u know how i get on cheers nick

HI Im tryign to get the average of five fields, on a report. However the fields are not allways in use so i need the average to adjust to any empty fields. How can this be done eg f1 0.1 f2 f3 0.35 f4 0.65 f5 -0.15 or could be f1 0.1 f2 0.5 f3 -0.26 f4 0.123 f5 0.36 Any idea Cheers Nick

Thanks alot that did it thought it would be something simple like that. Thanks again Nick

HI im trying to filter a record set in a form and but doesnt seem to like the ApplyFilter function any ideas DoCmd.ApplyFilter , "customer_id = '" & customer_id.Value & "'" Cheers Nick

I added incomplete code before i think it shoudl be Do While Not txtInn.AtEndOfStream lCounter = lCounter + 1 sText = txtInn.ReadLine If lCounter = 1 Then txtOut.WriteLine sText End If If lCounter > 6 Then txtOut.WriteLine...

HI im trying to read in csv file adn then import the data into a table. Everything works so far but before the csv is added i remove the first 6 lines of it except for the first one. How can i get just the ref no and append it to all records in the csv. the ref no looks like ref id: 1234...

Thanks alot gave it a try and it does pretty much what a wanted needs a bit of tweeking but its nearly there. Thanks again Nick

Ok thanks a lot ill give it a try Nick

What would be the best method to integrate this with my import statement? Nick

At the moment im reading in the file and then using DoCmd.TransferText acImportDelim, "matchdataimportspec", "match_data", strInputFileName, hasfieldnames - 0 to add it into the table. Nick

Hi Can anyone help im tying to remove the first three lines of an imported csv before i add it to the database. eg name :fred date : 02/05/2003 ref: 1052355 then the fields that i want i need to remove the top three lines automatically bofore the data is added to the table thanks in...