Search results for query: *

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

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

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

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

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

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

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

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

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

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

Hi, I need to write a report that shows Jan to Current month and must show all months even if there is no data for it. The data itself is taken from two tables with a straightforward 1-to-1 relationship. The tables are Requests_Received and Offers_Made. There will always be a request but...