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...
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.
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'.
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...
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,
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...
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...
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...
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...
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.
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...
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.
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 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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.