Search results for query: *

Can anyone help me with a step-by-step working example of converting an MS Access report to html using a template or css? Should I use the SendObject Method? Access help is a bit skimpy. Can you help?

Hi jnicks, Such short code interests me hugely. I am not aware of River text handling. How can I use it with VBA to import the data range "DELIVERY DATA" into an MS Access table? Thanks for taking time and interest. Regards Howard

Hi Grant, thanks a million. I reckon I can take this project further now. I still hope that you will be able to help in future. Regards Howard

I wonder who is going to answer this? Hi Steve, Did you implement Oharab's class successfully? I am also needing to import text files into MS Access. I run this code and get to a macro dialogue box with csGetAlign in it. I step into this procedure and end at Compile error: Variable not...

Hi Grant, I am getting on fine with this and see that it will be soon that I can use it. As you noticed, the table name is in the first field of your header array i.e. INSERT INTO Table4 ([WEEKLY SUMMARY], [SEASON], [WEEK], [FIBRE], [MOISTURE], [TONS]) VALUES ('', '2002', '8', '67.121'...

Grant, the code works properly and is most educational. It will help me to understand the next step. Thanks. Can I take your offer up in imorting the DELIVERY DATA data range only into an Access table using VBA? To refresh, the challenge that this text file (as at the beginning of the thread)...

Grant, Thanks for you precious time. When I run the above code, Access gives the following error. Compile error: Method or Data member not found Grant, this occurs at the code line List1.AddItem thisLineType .AddItem is highlighted and the help reveals the following suggestions:- Method...

Hi Grant, I need to search for the following block of data only and import it into an an MS Access table in this format:- DELIVERY DATA,SEASON,WEEK,DATE,VOUCHER,TONS ,2002,8,18-04-2002 12:22:52,B170485, 27.300 ,2002,8,18-04-2002 17:22:05,B170786, 28.250 ,2002,8,19-04-2002...

Thanks Grant, You were right on the button-I do need to put the data into different tables. I will try your code and let you know how I got it it to work. Howard

I have a text file with four summary headers and one detail block of data labelled "DELIVERY DATA". These are separated by open lines. This text file is downloaded from the mainframe in exactly the same format every time. Please help me with a working sample of VBA code to automate...