Search results

Hi Plog Thanks for the reply, its almost perfect only downside is the date might not fall on the monday of each week. So I will have to put in some checking on the date to see what day it is. Cheers Dj

Hi Thanks for the replies. Unfortuantly it isnt my database so I cant restructure anything as to much relies on how the tables are structured. I have just been asked to create a specific report and the report needs the dates as I have shown in the example. We work Sat and Sun on occasions...

Hi All I have a table with the following fields Date|Department|Process|Mon|Tue|Wed|Thu|Fri|Sat|Sun The Data would be as example Date |Department|Process|Mon|Tue|Wed|Thu|Fri |Sat|Sun 07/10/2013|Wood |Mould |250|250|200 |200 |100|0 |0 15/10/2013|Wood |Mould...

Database: Access 2007 Hi All I have designed a touchscreen input system using Visual Basic.net and this writes to an Access Database. Each Touchscreen has its database locally so it can still work even if there are Network problems. Now what I would like to do is have all these local...

Hi Wayne I figured out the code, great help and changed it slighty and works perfectly, here is my updated code. Private Sub Command0_Click() Dim row As Integer Dim clm As Integer Dim rst As DAO.Recordset Open "C:\MyIni.ini" For Output As #1 Set rst = CurrentDb.OpenRecordset("Select Field1...

Hi Wayne Thanks for the reply, but I have no idea what to do with this, do I put it in the coding of a button, create a module and paste it into a module ect? Regards Druid

Hi All I have had a request from my company to be able to output a text file formatted as an ini file from a database query. Its a strange request but I do see what they are looking for, basically this ini file will drive a display screen that was designed a few years ago but we no longer...