Search results

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?

Has anyone ever done this. I need to design part of an app that inserts tasks in peoples Lotus Notes to-do list. Any help welcome.

Many thanks Ken. It works perfectly. After update event of the check box is set to move to the next record and all is OK. Thanks once again.

OK, I added a field called txtEnabled, that is set to either Enabled or Disabled based upon the setting of the check box (named Completed) as follows: =IIf([Completed]=False,"Enabled","Disabled") This works at a record level. I then tried to set the font colour of a record in the continuous...

I have inherited a database designed by an ex employee, and I have been asked by the users to add a checkbox to a continuous form. When the check box is set, they want a date field on the record to be set, and then all of the controls on the record to be locked. Is this possible to do, because I...

Re: Export report chart to jpg file - SORTED Done it. I was vastly overcomplicating it. This works like a charm: Private Sub Report_Deactivate() Dim oleGrf As Object Dim strFileName As String Set oleGrf = Me.OLEChart.Object strFileName = Me.Name oleGrf.Export FileName:=outJPGPath &...