Search results

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

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

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

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

Hi, i have a form with cascading combo boxes, all of which are set to requery the combo boxes below, however i have one which is Service SubType, and it should requery Provider and Subjective, however it only clears the Provider and the previously selected subjective is still there, when you...

Hi, I have a form, and on the form there is a Provider Rate which is a combo box, if the user select a zero rate, then it has the description please enter manual rate in box below. There is another box which the user can enter a manual rate. Can someone suggest how I can limit entry into...

hi, I have record navigation control buttons on my form, but if I am at the First Record, I don't want the Previous button to be visible, and equaly if I am at the last record I don't want the Next button to be visible. Could someone let me know how you go about doing this please? thanks...

Hi, I have a form which is a single form with a subform. The form shows commitments and the subform shows related income commitments. They are linked through the CommitmentID. On the Main form there is a tick box which should be ticked if the commitment has been cancelled. The backgorund...

Hi, I have created Forms to use as navigation panes, and have inserted command buttons to go between the navigation panes or to open the forms for data input etc. My main form is attached to Startup part of my database. Once I click on a button and it opens another form, I have a bit code...

Hi, I need some help and advise please. I have a commitment table in my database, and normally people will input commitments through a form. However each month I will have a flat file upload from excel directly into the Commitment Table, these will be up to 1500 lines. (they are downloads...

Hi, I have a form called frmCommitments, where each user will enter commitments. Each user has specific Cost Centres that they work on. This is noted within the Cost Centre table, within 3 different columns, Finance Analyst, Finance Technician and Finance Assistant. When the user (who...

Hi, I have a form that has been created from a table. One of the boxes in the form is the IncomeSubjective, which I have used a Dloopup within the On Current event to get the correct Income Subjective, which it is doing, as I can see the subjective in the box. However when I go to save...

Hi, I am trying put a default value into a form (note this may be changed by the user at a later date) the default value is the value from the commitment (which is another form) divided by 2. Below is what I have used in the VBA, but it just isn't working, I keep getting Run-time error '13'...