Search results for query: *

I currently have four date fields: AgreementDate, RevCompDt, RevDueDt and RevByDt. The AgreementDate and RevCompDt are manual entry fields and RevDueDt and RevByDt are calculated. The formula for each is:RevDueDt = IIf(IsNull([RevCompDt]),[AgreementDate]+335,[RevCompDt]+335)...

I hope this question is in the correct forum. Any help greatly appreciated I have two tables tClients and tFeesComm. Fields in tClient include ClientStatus and fields in tFeesComm include FeeStatus and AdviceArea. What I would like to happen is if ClientStatus = Signed Up and if FeeStatus =...

I am using Access 2013. I am developing a DB based on 'Navigation Forms'. I have a tab which opens a subform containing 'Clients'. Also in this subform is a button which uses the 'BrowseTo' to navigate to another subform (EditDiary) which opens at a record designated by the 'FullName' open at...

I am working in Access 2013. I am using a 'Navigation Form'. One of the Tabs displays various reports called vis a combo box drop down list. This function works perfectly. However some of the reports when called from within the Navigation Form allow scrolling via mouse wheel and others do not...

I am using an Access 2013 'Navigation Form' and on one of the Tabs there is a subform container which is used for the 'BrowseTo function for showing various forms and reports. One of these Forms (fHomeClient)contains a subform (fClientFeeComm)which contains a FirstName and LastName field which...

I am using the following code to Disable the custom First, Last and New Record buttons but receive an error message when I press one of those buttons and being relatively new, do not understand why. Could someone explain please? The code is Private Sub Form_Current() On Error Resume Next...

I am working in Access 2013. I am using a 'Navigation Form' (not a TAB control) with horizontal tabs When the user hits one of the three tabs currently available, before seeing anything in this tab the user must enter a password to continue. The tab will contain 5 controls, consisting of 4...

I have a form that includes a 'Date From' and a 'Date To' field. These values are passed to a selection query. I don't have a problem when these fields are used ie. dates are entered by the user. My problem is I want the user to be able to leave these fields blank and have the query select all...

thread703-1476741 The above thread was very useful to me. However I am using the same code that Hookum provided and I am getting an error. The code is basically doing exactly the same as before and is being started on a button click. The first time I click the button after opening the form and...

I have a form with several text boxes which are used to build a search filter. I have used this many times and it works perfectly. However I have a need to allow the user to search for a value that is >= to an entered amount and I cant get the correct syntax in the code. The code (apologies...

I have a table of data that has initially been imported from Excel and which appears to have imported correctly. Two of the fields in this table will be used in a report. The Table is tIncome and the two fields are ITEM and AMOUNT. ITEM is a Combo Box where the source is another table with the...

I have a switchboard with 3 'groups' of controls Tagged blue, green, pink. I would like to have 3 'buttons' each representing a 'group' which when clicked would 'SHOW' the relevant group and hide either of the other two if it were already showing. I have searched the forum but not found...

I have a form (fOrderHead) with a subform (fOrderItem). The subform may contain several items which might be delivered at different times. I want the user to be able to select one or many items in the subform that are ready for delivery, press a 'button' that will generate a 'Delivery Note' with...

I have a form with several text boxes into which I enter search criteria which will be applied to a query that in turn will update a form based on the result of the query. All of the boxes are working fine except the one where I enter a date value in 'short date format ie 06/01/2011', and I want...

I have 2 worksheets. On one there is data Date Category Cash/Chq Amount I want to be able to find data that matches a date range and if it is 'Cash', if data is found, copy the row then paste it into worksheet 2 at lets say cell A1, then go off and find the next data that meets the...

I am enetering results of a competition in an Excel spreadsheet. There are 50 competitors who are listed in a matrix. The result is given to me in the form of Competitor 02 W Competitor 47 L on date 18/09/09. I use the following code to enter the data via pop up boxes.. Sub EnterResult()...

I have a form with several boxes in that a user selects data to filter a report, so what ever the user has in any or all of these boxes there is code that builds this info as a filter string. The code which was obtained from this site (but I cannot find exactly where or by whom) is like this...

I have a table containing information on vehicle fuel usage eg Reg DateFuelIn Amount Cost Mileage So there will be multiple entries for each Reg. The data is entered via a simple form. What I would like to do is show in that form (I guess as a subform) whatever was the last entry...

I have a table that contains as well as other fields, two fields which are populated from the same drop down list ie I have a list of surnames and in field 1 the user selects a surname then in field 2 the user selects another surname from the same list ending up with perhaps SMITH JONES At...

I have 2 worksheets and one print area defined on each. I would like to print both print areas ie. the two print areas combined... on one sheet of paper. Is this possible?