Recent content by AndyV

I have a form with a number of subforms on it. For each main record, either 1 or more than 1 subform maybe applicable. I have set the subforms visible property to false on the main forms current event, and then loop through a recordset to see which subforms are applicable, and reset the visible...

I am not bothered about mine, it is the other databases knocking about that will pose the problem. I have done a preliminary check and there are about 600 db's on the fileserver.

As I won't be physically looking at the databases, I won't see any symbols. I will probably kick the process of overnight, so do I have to get the vba to open each of the databases, loop through all of the tables and then close the database again?

The network guys where I work are changing the directory structure of the main file server. I need to write some vba that loops through the directory structure, and finds access databases containing linked tables. I have written the looping through the directory structure bit, but is there a...

I have found the answer to the first problem, using the On_Current event of the form, [TreeviewName].Clear removes all nodes.

Hi chaps, I am trying to include a treeview control in an app that handles customers, and I want the treeview to look in a folder on our network where presentations, documents etc. are stored (each customer might or might not have a folder, but the app creates the folders and documents so the...

Can a Data Access Page be designed like a continuous form? Cant seem to find an option in the page properties?

This maybe a silly question, but in the report page setup, have you set the printer to the thermal printer, and the page size to the label size?

Do all of your export files have to be saved with the same name, if not you could always add a date and time string on the end of the file name, that way you would also know exactly when the file was produced. You could save it to another folder and use a file copy routine. I produce a few files...

By the way, you need to set a reference to Microsoft Scripting Runtime in your Access VBA references.

This is what I have done in the past: Function Create_CSV() Dim rSt As ADODB.Recordset, strFile As String Set rSt = New ADODB.Recordset rSt.Open "xxx_column_types", CurrentProject.AccessConnection strDate = Format(Now(), "YYYYMMDD") strFile = "c:\temp\zzz" & strDate & ".csv" Open...

My method also creates csv files (I have just checked), and you can insert whatever you need in the first row of data, and ad a hash total row at the end if needed.

Gemma, what about the first row that he needs. It might not be the column headings, most of the files we receive for importing into other applications do not contain the column headings, because they are predefined. The first row in most of our files contain the date, number of rows in the file...

Does the output have to be a csv file? I have a lump of code that sreates .txt files and .sql files. If the first row needs to be some sort of control line, this could make the task easier. Do you have to do anything like have a #count control row at the end of the file? I will stick the code up...

I presume no-one has done this then. Anyone know where I could get some help?