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!

  • Congratulations strongm 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. h20vrrq

    SQL Query - run without permissions/direct access

    Hi, One of my users has written several simple SQL queries that he needs run every month against one of our databases. The queries delete, insert and update data and are run in 4 separate groups. My manager has said the user can not have direct login access to the server unless absolutely...
  2. h20vrrq

    Data visible then its gone

    Yes, everyone who needs it has a copy of the database. The Score is being saved in the table.
  3. h20vrrq

    Data visible then its gone

    The database is only accessed by a single user at a time so I didnt think I need to keep track of them. There will only ever be one set of answers stored at any one time.
  4. h20vrrq

    Data visible then its gone

    The table structure is as follows: Table name is 'Scores' Field 1 is 'Question' with data type of Number Field 2 is 'Score' with data type of Number The forms all have a Record Source of 'Scores'.
  5. h20vrrq

    Data visible then its gone

    I've been asked to create a database that needs only to store the answer to 6 questions. Each answer will only be between 1 and 9. Each question needs to appear separately so I have created 6 forms, one for each question. The table used to store the answers (Scores) is very simple, and just...
  6. h20vrrq

    Oracle Client & Windows 7 64 bit

    Thank you both. Yes, I will need the 32bit version as well. All being well, I will download the 64bit Client this weekend. Could anyone point me in the right direction for the 32bit version please? Many thanks,
  7. h20vrrq

    Oracle Client & Windows 7 64 bit

    Hi, I got a new works laptop which is running Windows 7 64 bit. On my previous pc I was using DataDirect ODBC 5.2 to connect from Windows XP to Oracle. The version of datadirect we have doesnt work on the new laptop, so I have been advised that if I want to connect to Oracle via odbc, my...
  8. h20vrrq

    Excel error when importing into Access 2003

    Hi, Does the excel application method work in Access? Where would it go? Private Sub Command0_Click() EmptyTables Dim pPathname As String pPathname = "\\cat\kieranm\BudgetTesting\2012\" FilesInFolder (pPathname) End Sub Sub EmptyTables() Dim db As Database Set db = CurrentDb...
  9. h20vrrq

    Excel error when importing into Access 2003

    I have an Access 2003 database that scans a folder for excel workbooks, opens them and imports various ranges from within the workbook. The owner of the workbooks has changed a coupl of the worksheets and now when then import runs I get the message 'This workbook contains links to other data...
  10. h20vrrq

    Importing multiple ranges from a single worksheet

    Hi, The solution we came up with is below. Basically just added an index to only look at each range once. Option Compare Database Private Sub Command0_Click() EmptyTables Dim pPathname As String pPathname = "\\cat\kieranm\BudgetTesting\2012\" FilesInFolder (pPathname) End Sub Sub...
  11. h20vrrq

    Importing multiple ranges from a single worksheet

    I should have mentioned that I am searching upto 300 workbooks in the same folder. Each workbook has a number of worksheets one of which is always called 'Summary'. The other worksheets from all workbooks will also be imported.
  12. h20vrrq

    Importing multiple ranges from a single worksheet

    Hello, I am trying to import multiple ranges into Access 2003 from a single Excel 2003 worksheet. The ranges all go to different tables with Access. I can import a single range with no problem at all, but when I try and specify a second range all I get is the second range and not the first...
  13. h20vrrq

    Mix, Max for a group of records

    Hi, I am trying to create a view that has the start_date and end_date for each employee based on their location of work and I'm struggling to work it out. The table is called location_history and the fields are ID, (this is the unique number for each record in the table) employee_visit_ID...
  14. h20vrrq

    Trying to merge more than one record to a page

    I have to mail merge of a long list of staff into Word document. The document has already been created and approved so I have to use it. It has been set up to allow two staff records per page, one in the top section and one in the bottom section. Both sections are identical. I've tried...
  15. h20vrrq

    Multiple Text Search on Memo Field

    Yes, the report needs to return the record(s) where at least one of the text items is found in the field. It should not return any records that do not contain any of the text items.
  16. h20vrrq

    Multiple Text Search on Memo Field

    Hi, I've been asked to write a report that looks in a memo field called {t_Invoice_Items.Description} and searches for any specified text string. The aim of the report is for the user to type in any number of different words/phrases they want to search the description field for, they will...
  17. h20vrrq

    Maximum date where less than Start Date

    Hi, I will need to identify each animal. The table looks something like this (an example of one animal record): - AnimalRef CategoryDate Category 300004 10/05/2008 New 300004 25/09/2008 Training 300004 17/12/2008 Transfer 300004...
  18. h20vrrq

    Maximum date where less than Start Date

    Hi, I am trying to write a report that will let me find the last category date & category for each animal in the table where the category date is less than a parameter date. There will be many category dates, some before the parameter date and some after the parameter date. I know how to...
  19. h20vrrq

    Importing Excel worksheets into Access 2003

    I have to set up an Access database that has to import data from several hundred Excel Workbooks. In each Excel Workbook there will be three types of worksheets, a Base sheet, a budget sheet and a project sheet. In each workbook there will always be one of each type of worksheet, but there...

Part and Inventory Search

Back
Top