Search results for query: *

I have not been into this very helpful website for a while. Have changed jobs so not up to scratch with code. (I am not a programmer, as I do not use these skills in my current job) I have searched for over an hour and cannot find the simple solution to my question? How do I run an application...

Hi I would like to provide text comments of what results appear in subreports. Here is a sample of what's in the subreports (there are 2 subreports in each of the 7 main reports that are run weekly). I've cut down the amount of data I've shown in my samples to keep things simple. Group...

I have a query that has the following criteria for the invoice_date field ">#30/04/04#". This shows me what customers have spent after April. I have also asked it to show me who has not spent after April by putting "Is null" in "or:". I also want to know customers who have not spent after April...

I am using MS Access 97 and want to lock a field after it has been updated. I have used Edit command buttons in the past but would like to know if there a way to tell the database to lock the field automatically after the date has been entered. I welcome your advice.

Hi there, I am using MS Access 97 and have created a report with the following headers, Report, Page, CountyName, Town, Applications, CompanyName. The Detail section contains ContactNames within each company. What I want to do is show on the report how many CompanyNames are within a CountyName...

In MS Access 97 I have a report based on a query. The report is grouped by 1) Adviser's Name 2)Adviser's Sector 3)Adviser's Company names, the detail section contains the Adviser's users within that company. I have managed to insert a calculated field in the Adviser's Name Header =count(User)...

I have a query in Access 97 and think I may need to use the IIF function. The query is based on a "UserDetails" table and shows users names as well as two date fields, "JoinDate" and "LeaveDate", these are to record when a user joins and leaves a service/product. If...

I am using MS Access 97 and think I need to create a many-to-many relationship. The database is in the early stages of design. At the moment I have 2 tables, one called SUPPLIERS containing details of office suppliers, it has a primary key field SupplierID. The other table is called TENDERS...

I am using Access 97 and trying to get a checkbox named "RegistersUpdateUser" to update on a mainform when a selection "Registers Updates" is made from a combo box named "ContactType" on a sub form. This is the VBA code I am using on the subform but nothing is...

In MS Access 97 I have a customer database. Each record is displayed in single form view. On this, there have been 9 seperate pages (tabs) inserted so that users can select on the appropriate tab to see various details of that particular customer e.g. contact details, recent communications...

I have 2 tables in Access 97, one is called CustomerDetails and contains a primary key called CustomerID. This table has a one to many relationship with another table called Communication. The foreign key in the Communication table is also called CustomerID. The other fields in this table are...

In Access 97 I have created reports from the label wizard based on relevant queries within the same database. The fields, which are address details, appear on the left hand side of my label report and are kept together because the wizard has a built in function that does not generate blank lines...

I am a learner in VBA Access 97 and found a particular piece of code very useful thread705-441796. The code is working fine but a colleague has advised that I should include error handing in this code and all other VBA code I use. I am not too familiar with the error handling process and I'm not...

I am developing a database. It does not have user-level security. It is protected by a number of passwords into different forms. The users have to type in a password before the database automatically opens a "Navigation" form. I thought about removing the menu bar from this form, but...

I have recently set-up a label wizard which was working fine. But recently, some users pcs are generating "#Name?" instead of the field contents. Does this have anything to do with "Trim" which is automatically inserted before the field name in design view? Another reason I...

I have a list of 4000+ towns and their relevant county, which will be 1 of 33 names. At present the users input both fields manually. I would like the county field to update automatically once the user has entered a town. If the list of towns and relevant counties is stored in the database...

I have 2 date fields. The first field already has a date entered. I would like to update the second date field automatically once the user has selected one of 4 radio buttons. The radio buttons give the option of 1, 3, 6 or 12 months. Once the user has selected an option it will update the...

I would like my users to know how many pages there are in a report by prompting them with a message box when they open the report

I have a form with 4 date fields. The fields are updated in the following order "Active Date", "First Contact", "Last Contact", "Next Contact". I have already used a useful piece of advice for entering a "First Contact" date 7 days after the...