Recent content by h20vrrq

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

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

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

All sorted now, thanks.

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