Search results

Hi, thanks your reply, however the database I have built will not be getting changed any time soon, it was the first one I have built and works fine. We only need to access previous years data for a very limited time. I base the new years database on the old years database and only delete the...

Hi, My database has a front end that uses forms to allow the user to navigate within it, each year we create a new database which is based on the previous year's database but with all the variable information removed. Within the database each form has a caption that starts with '2014-15'...

Thanks for your reply both, however I don't want to hide the main form as I had a problem with it updating with any changes plus I did have an issue with it saying I had too many databases open. I'm pretty sure there is a way to open showing a specific sub-form I just don't know how to write...

Hi, Firstly I appologise for posting another thread regarding opening a form with a spcific subform showing, however I just seem to be unable to take any of the previous answers and relate it directly to what I need. Basically I have a database that records commitments for clients. The user...

Hi, I am using John Big Bootys Dynamic Search Form (built in Access 2003) as it totally met my search requirements, however when typing anything into the search box it is realy slow, taking several seconds for each letter to show in the box. This has always been a problem now and again...

I think I have fixed this myself. Wihtin the properties of the command button I have added text within the ControTip Text, which means when the user hovers over the button the text will appear.

Hi, I have a form with command buttons that run different macro's that downloads queries into Excel. What i would like to do if it is possible, is to somehow add an explanation of what the download will contain if the user should either hover over the button or even better if there was a way...

Hi, Hope this is the correct part of the forum to use. I have a query and a form, and what I want to be able to do is have the user type in within the form the parameters for the query. The part of the query that will hold the parameters is based on an amount (formatted as Currency), but...

Hi, System - Excel 2007 File Type - Excel 2003-2007 Workbook I have several Excel Workbooks that are linked through formulas. If I open the main file plus the files that feed into it the formulas do not appear to update. If I look at the formula, it is showing the full filepath even...

Hi, It is the same excel file they are uploading and one of them can and the other can't and gets the error message.

Hi, I have a split database that is used by several colleagues. They all have the same front end. I have buttons which are linked to Macros that will automatically import data from an excel spreadsheet. The filepath to the spreadsheet consists of the full server name as we have some people...

Hi, thanks for your very quick reply. I didn't actualy do this it was someone from the company that supports our Database. We didn't think we would have to re-link the tables as effectively the Back End hadn't changed name and strangely some of the forms did work, and some didn't. I...

Hi, I have a split Database (2003) that has been working fine since it was installed in April, however for the first time the Back End was Compacted and Repaired today, which seemed to go fine, but when accessing the Front End one of the Search Forms had no data in it and people were unable to...

Hi, I have a DLOOKUP which is used to auto populate a field on my Income Commitment Form based on a field on my Expenditure Commitment Form. It works perfectly when you enter a new commitment. Currently you enter a new Expenditure Commitment, save it but don't close it, then from the...

Sorry my original query doesn't make sense. The double click that open the selected form on the correct filter works fine, it the Dynamic Search form that I wasnt to requery when it is called on, for example if I have typed in smith on the search box, double click to open the form for smith...

Hi, I have forms that show commitments by Client, by Cost Centre, by Provider etc. If I add new commitments or edit commitments it is done through the Commitments by Client form, as all other forms lead back to this one. To create a new or edit an existing commitment, it is done...

Hi, I have a Dynamic Search form, which I use to search for client, on the double click it takes me to the client, at which point I have the Forms Visible set to False. When I click on a button to open that Form, the Visible turns back to True, however it shows my last search results, how do I...

btw enables = enabled, I clearly have typing issues!

I'm sorry it's been a long day and now I;m really confused. I have set the Manual Rate.Enables = False in the after update event of cmbProviderRate, and it works, so the Manual Rate box is only enables if the user selects a 0 rate. Do I still need this: Private Sub Detail_MouseMove(Button...

Hi, thanks for your response, it's not as simple as that, as I have a rates table which has rates linked to Providers, so for example, I have a ProviderRateID = 986 ProviderRate = 0 Provider = Homecare (in this scenario I want to enter a Manual Rate) ProviderRateID = 987 ProviderRate = 14.69...