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

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

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

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

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

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

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

Hi, Is there anyway that you can order a query to be descending by an expression in your query rather than an actual field from a table. I am trying to do this but the following message keeps appearing: The Microsoft Jet database engine does not recognize '[ExpressionName]' as a valid field...

Hi, On Current on a form, I want to be able to run two 'loops' independent of one another. Basically, they both look at data in seperate tables. If both tables have data in them, both loop procedures work fine. However, if the first table has no data in it, the second one doesn't work...

Hi, On our main menu table, I only want to be able to add one record. On the form that I have linked to this table, should you press the tab key to go through all the items / buttons, it opens a blank record screen. However, I do not want this. Any ideas? Thanks in advance Lee

Hi, I have a button on a form that imports data into a table. This works fine. However, after the import, once data exists in the form, I need the button to be disabled so no new import can take place. This database needs to be finished today so am starting to panic a bit now!! Can anybody...

:mad: Hi, I m really struggling now with this problem. I am importing a csv file with addresses and Post Codes on into a Properties Table. However, when I import the csv file, there is another field in the table called Area. I want the import routine to somehow use a lookup table that will...

Hi, I am using the TransferText function to import a csv file with addresses on into an Access table. This will need to be done on an annual basis into the same table so I have included a field called 'Year', that is updated using an update query. This all works. The update query only...

Hi, I have an Order table that is linked using one to many relationships to three other tables (Users, Suppliers and Cost Codes). However, when entering data on a Order form in the Users ID field for example, because I want the other drop down lists to update after update, I have used the...

Hi, We have just moved from Win 2000 and Office 2000 to Win XP and Office 2003. Everything works fine. However, every other time that you run a report, the report, instead of printing on 1 page, enlarges and spreads over 8 or 9 pages. Is there a system change needed? Please help as this...