Search results

You might want to rule out your browser too. Download another browser such as Google Chrome or Firefox and see if it does the same thing. If it doesn't, then you could try putting IE back to factory default settings, as there might be an addon causing the issue.

Never used vbulletin before but you should be able to set an auto promotion to a different usergroup at 10 posts. Then disable the signature for the new usergroup.

have you tried clearing your browser cache??? For internet explorer 8 its: Tools > Options > General Tab > Delete > Only select Temporary internet files > Delete Similar for other browsers.

I think overall the refereeing and the linesmen have been great. Apart from the handball and the Kaka sending off. I think its the opposite, but then again I've never watched football in the US so I don't know what it's like there. I watch alot of premiership and 1st division football in the...

Your layout for your vba module might be something like this: Dim db As database Dim rs As dao.recordset Dim qryresult as string Set db = currentdb() Set rs = db.openrecordset("yourqueryname") 'rs will now hold the answer to your query. qryresult = rs![FieldName] 'moved answer...

Depends on your macro and what you are exactly doing. If you are completely new to vb you might want to look at a few basic vba tutorials (such as If/else statements, working with recordsets) and then look into DoCmd vb for printing your report. You can basically replace the majority of your...

cool, glad you got it sorted. Also if you ever want to go along your original route from within access vba. To send a single record to a variant from a recordset (If multiple records returned you will need to loop through them and save them to an array): dim rs as dao.recordset dim db as...

have you tried using a recordset? Run the query in vba and then save the value into a string variant. Then use that, rather than: .Cells(3, 3).Value = "qry_output"

Thats giving you 10 records because you are selecting 10% of TOP 100 which = 10. If you take the top 100 out it should return 10% of everything in your qryPostInspectionLesYates

thankyou :)

I played around some more and found a solution. I replaced the .WriteLine ts1.ReadAll .WriteLine "END," & qty with .Write ts1.ReadAll .Write "END," & qty Im assuming the difference between writeline and write is that write appends to last line, but writeline doesnt and adds a carriage...

Hi thanks for replying. Do you mean read the table into a recordset and then build the csv line by line including header and footer? I thought about doing this but basically managed to add the custom header and footer quite easily (apart from that empty line) and was wondering if there was a...

Hi, great forum here. It has helped me out countless times. I'm exporting a table to csv using the transfertext method. Then im inserting a custom header and footer using vba writeline and writeline readall for the main csv body. The problem I have, is when exporting the original csv there...