Search results

Hi, I am trying to produce a query that shows how many appointments are available each day for a particular contractor. I have used the Between [Start Date:] and [End Date:] function in my query to select the dat range that I want to query. However, this only brings back the dates where...

Hi, It is Access 2007. I have done a bit more digging. The PCs with the problem seem to have Windows SP 2. It seems to work with SP3. Is that right? Cheers Lee

Hi, I have used the SendObject functionality for years in Access. Having not used it for several months, it now seems to have stopped on the PCs in our office. It works fine using the same database on my home PC and when I connect to our network at work using citrix. Is there a security...

Hi, I need to have a button on a form that opens either a form in Datasheet View or the table. I can't seem to find the code anywhere? Many thanks in advance. Cheers Lee

Hi, I have a form (frmMaster) with three fields in that are all combo boxes. Depending on what I select from the first box (Function) needs to determine which values can be selected in the second combo box (Activity) and then depending on which I select from the the second box will determine...

Hi, I am trying to add a column into a query to rank items in that query. For example, I want this table: Name Score Lee 10 Simon 8 Steve 8 Mike 6 to read: Name Score Rank Lee 10 1 Simon 8 2 Steve 8 2 Mike 6 4 I have read the Microsoft help but...

Thanks Thanks Cheers Lee

Hi, I am setting up a table based on a questionnaire where there is a genuine need for a lot of fields. However, I have got to the stage where I can add no more fields in the table. How can I add all the fields I need? Can you carry on in another table and them join them in a query...

Thanks Thanks, that worked great. Please let me know though if you think of a better way of making sure that the users have ended previous tenancies before starting a new one. Thanks again. Lee

Hi, Using the following code, my database automatically open a particular record: DoCmd.OpenForm "frmPerson", acNormal, , ("PersonID =" & lstOtherHouseholdMembers.Column(6)) This works but filters the recordset so that only that record is available unless you untick the filter button. Is...

Only 1 tenancy at a time. Hi, They can't have more than one at a time. I am relying on the users entering a tenancy end date to identify that a tenancy has ended. Then, when they have a new tenancy, hopefully, the new tenancy start date (this will be the latest date) will identify that this...

I have set up a tenancy database. I have a table that holds people records. I have a table that holds properties and a table that holds tenancy information. They are related in the following way. 1 Person can have many tenancies and 1 property can have many tenancies. The tenancies table is...

Thanks, that worked great! Cheers Lee

Hi, When the main form opens, I want the 'New Record' button on the toolbar to be disabled as I want to force users to use another button. However, I can only do this by disabling all the command bars using the following code on the form load: Dim i As Integer For i = 1 To CommandBars.Count...

Hi, I am trying to create a procedure that creates a unique reference number in the format of 'year/number'. For example, 07/0001. This worked fine until I found out that the year is not based on the calendar year but the financial year (April 1st to March 31st). I have changed my code to...

Thanks that worked great! Cheers Lee

Hi, I need to use the following code to present the previous year (2006 for example) in the format 06. However, the code misses the 0 off the front. Format(Date, "yy") - 1) Any ideas? Thanks Lee

Thanks, that worked great. Cheers Lee

Hi, In a query, I am using the following code to return the average length of each tenancy. This works fine unless the length is 0. If so, it only brings back 'blank'. How can I change this code to return a 0 value? Tenure Length AVG: IIf([Average Tenure Length]>0,Format([Average Tenure...

Problem found!! Hi, This works fine but I have now encountered another problem that is related to this code. This worked perfectly when there was only one button that needed to be disabled when one table had data in it. However, now there is another 2 buttons that relate to another two...