Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. mobile2

    A Live, changing counter of a database

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

    Passing data from formula fields in subreport to main

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

    Query not giving exact result

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

    Query not giving exact result

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

    Labels producing Error "#Name?" instead of fields

    Thanks, but problem is fixed on all pcs.
  6. mobile2

    Lock a field after it has been updated once

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

    Lock a field after it has been updated once

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

    Lock a field after it has been updated once

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

    Can't calculate what is visible on report

    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!
  10. mobile2

    Can't calculate what is visible on report

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

    Using calculated fields with grouped headers

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

    IIF function advice

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

    IIF function advice

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

    IIF function advice

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

    Many-to-Many relationship help

    Thank you all for your sound advice.
  16. mobile2

    Many-to-Many relationship help

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

    Code on sub-form not working

    I just needed a little bit help and you were there. Thanks again
  18. mobile2

    Code on sub-form not working

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

    Can I control a "page (tab) caption" depending on its sub-form content

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

    Having problems appending multiple records

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

Part and Inventory Search

Back
Top