Search results

Hi Having brain fade! How do I insert an existing subreport onto an existing report using vba? I cannot just have subreports on report and then hide/unhide them, as there are a lot of them and would make the report very slow to open. Depending on user options there could be between 1 - 10...

Hi Is there a simple way to check for the existence of a file on a ftp server? I have tried searching posts but cannot find anything to do this - maybe just not looking hard enough!! cheers:confused:

:Hi I have what I think is a simple query, but driving me mad. I wrote an error handler for a database at the old company I worked for and it all functioned fine. I have tried using the same error handler on a new database I am working on at home, and it does not recognise '.LastModified' (it...

Hi I am having a problem with 2 excel files that have been generated by Access. They have been generated using the TransferSpreadsheet function, selecting acSpreadsheetTypeExcel9, although I get the same error if I use the OutputTo function. Their is a master spreadsheet that looks up...

Hi I have an issue with my database since I split it into 2. Once I have opened my main form whenever I try and change existing queries, forms etc I get the warning - you do not have exclusive access to the database at this time. If you proceed to make changes, you may not be able to save them...

Hi This is a really simple question, but one I have never needed before. I am using a recordset to obtain data from a table. In the past I have only ever looked at current database (ie set db = currentdb()) I now need to look at another database, but am coming up with an error which I can't...

Hi :) Probably a really stupid question, but am having one of those days! I have a function that takes data from a table to be used in queries. This works fine, but I want user to be able to put "(All)" in the table and the query to return all records. I have tried setting value of function...

Hi All :) I have spent the last 6 months designing/building a database for the company I work for. Everything has gone well and all users are happy :) I have just been tasked with writing documentation for the database. Although I have been building access databases for about 5 years...

:confused: Hi. Does anyone know a way to change the colour of controls depending on their value in a continuous form? I can change the colour of the current row in a continuous form, but I cannot adapt this so that it changes colour depending on the value (ie conditional formatting) Ta