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

Thanks for the advice, when you talk about converting to a groups query do you mean selecting "Totals" from the "View" menu? I'm using MS Access 97.

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

Thanks, but problem is fixed on all pcs.

I tried the following and it works great: If IsNull(Me.DateCustomerActive) Or Me.DateCustomerActive = "" Then Me.DateCustomerActive.Enabled = True Else Me.DateCustomerActive.Enabled = False End If Cheers

Thank you both for your advice. The first code "dcurtis" supplied works perfect for what I want but when I added code "scottian" to the oncurrent property for the form the field wont allow me to edit at all. Can you please confirm what I'm doing wrong: Private Sub Form_Current() If...

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.

Sorry for taking so long to get back to you. I took your advice and added the sub-report. I also used the DSum function to retrieve the Total I needed. My report has everything I need now. Thanks for the help - you guys are great!

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

It has worked this time. I think my PC is just a wee bit slow. Superb!

I have entered the following within SQL view, with the correct field names, and then attempted to change to datasheet view. It will not let me do this and only shows the "egg-timer" icon within SQL view. SELECT ud2.RDAccountReference FROM [User Details] AS ud2 WHERE...

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

Thank you all for your sound advice.

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 just needed a little bit help and you were there. Thanks again

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