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

    Retaining a user ID access right throughout a database

    Hi, I have a database which I've recently converted to SQL backend tables. Since the conversion when I use my log-in form which takes a network login and password, the access rights are no longer consistent throughout the database. When I get to the main form, for read only users they can...
  2. Powerhouse123

    Using INSERT INTO and trying to pick up an ID number from a from

    Hi, I have a table which acts as a history for a child's Assessment form (done through subforms). When a new assessment is created for a child I want the history table to be populated with a couple of default records. I've managed to work out how to use the INSERT INTO function and get the...
  3. Powerhouse123

    Using dbSeeChanges OpenRecordset option

    Hi, I'm currently updating local Access tables to SQL linked tables. I've updated all the links in the relationships, queries and code. The database appears to be working perfectly except... I have a login form to open the database and I get the common "You must use the dpSeeChnages option...
  4. Powerhouse123

    Form based on a query but not allowing any edits

    Hi, Merry Christmas! Scenario: Users Table: Training 1 Table Training 2 Table ID ID ID FirstName FirstName First Name Surname Surname Surname Address Attended Attended Tel...
  5. Powerhouse123

    Making a query return a error message if there is no match

    Hi there, Merry Christmas! I have a simple query which is using the criteria in the design view to search the surname... Criteria: [Please enter a surname] This is great when there is data to return but when there is nothing it doesn't look great so is there a way to create a message which...
  6. Powerhouse123

    Report linked to Email

    Hello, I am trying to use the SendObject function on the macro options to send a report in an attachment from Access and I want the report to attach to a template email I have saved. Is this possible? I think I need to use the template File option in the macro settings but I cant seem to get...
  7. Powerhouse123

    Between Query

    Hi, I have a very simply Table... ID, NAME, ISSUE DATE, EXPIRY DATE 1 Bob 01/01/2004 2 Dave 23/04/1998 3 Jim 02/01/2004 4 Scott 05/11/2007 5 Keith 06/03/1995 The expiry column is blank because this is calculated in the query... Expiry Date: DateSerial(Year([Issue...
  8. Powerhouse123

    Choosing a date between a criteria based on a calculated field

    Hi there, I have the following table and query and what I want to be able to do is find out who has expired between a a set of dates I select. Table structure... FIELD DATA DATA DATA DATA ID 1 2 3 4 Name Bob...
  9. Powerhouse123

    Creating a query based on info calculated in a form

    Hello, I have a form which is calculating information and I want to produce a query based on the calculated information on the form. I realise you cannot create a query based on a form...or can you? My base table includes the following: Issue Date: 01/01/2005 Expiry Date: Nothing - this is...
  10. Powerhouse123

    Access Forms - Returning text based on mulitple criteria

    Hello, I have a form whereby I want to return a value in the "Valid" field (see below) of "Yes or "Overdue" based on a calculated field and against today's date. e.g. Issue Date: 01/01/2005 Expiry Date: (code in control source =DateSerial(Year([Issue Date])+3,Month([Issue Date]),Day([Issue...

Part and Inventory Search

Back
Top