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...

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...

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?

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.

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...

I am building an app that will build customer based powerpoint presentations overnight based upon user requests. I am having difficulty with some charts they want in the presentations. I found some code that will export a form chart as a jpg file, but from the open form. I need to loop through a...

Anyone know if there is any way of saving a report as a .bmp or a .jpeg file. I am trying to create a file on the network to use as the desktop background on users PCs.

I have an access appication that will be used by three or our users. One of the functions of the app will be to copy files off a share on our lotus notes / windows server, import them and then delete the files from the server. Our network chaps have created a logon that has read / delete...

I have an Access database that contains links to a DB2 back end, and one of the tables contains a column containing XLM strings of varying lengths. and Access seems to be truncating the strings. Is there any way using VBA that I can see the full column values so that I can split the XML out into...

I am trying to change the connect string for a series of Pass Through queries in a database, so that the end user can choose between Prod and Test DA Sources. I believe that the connect string is read only for an existing query, so I am capturing the Prod and Test connect strings, the SQL from...

I need to loop through unopened mails in a Lotus Notes mailbox and save the attachment(s) from each message. Has anyone got any ideas?