Recent content by sw1085

Can anyone help me solve my problem? I guess I need some kind of join but not sure which one or how to add to my existing query. Thanks very much SW

Thanks, sorry about that. I hope it is readable now.

My data is layed out in three tables as follows: I hope someone can understand what I am trying to achieve. Best regards SW

access does let you store spaces using the Space() function. I just don't know what the code should look like if I want to copy the current value in the field and then paste back into the field with spaces. The logic behind this is to maintain the formatting of the data in the table data as...

Hi I've been looking for a VB code that can go through every row in my table and fill the cells with blank spaces or zeros to the maximum field length. It would need to go through every column and row. For example: If I have a field that has a maximum field length of 10 characters and the...

Thanks for your reply Pat It needs to be automated with a refresh every 60 seconds Any ideas on what code would accomplish what I am trying to do? Currently trawling the internet but nothing found as yet. Thanks alot for your help.

Hi I would like to be able to combine several tables which all share the same fields. The only way to ascertain which data relates to which company is by looking at the table name as the last three characters of the table name tell you which company it is dbo_SALFLDGASL would be for company...

Hi Paul I have made some minor changes - can you please take a look to see what could be wrong? I keep getting run-time error 3129. Thanks very much in advance for your help. Sub TRFDATATO() Dim tName As String Dim strSQL As String tName = "tblDatato & tblDatafrom.CO_CODE " & _ strSQL =...

Paul I'm sorry I don't understand. I simply copied that code and tried to amend but failed. Do you think you could help me by correcting the code? Thanks very much for your help. I've been :banghead: all day!

Hi All, I am trying to combine these two bits of code together so I can basically select the data from one table and transfer this to another table however the table name of the table I am copying to would be based on tblDatabase & the value from the record in the table we're copy from. It...