Search results

Hi all, Does anyone have an easy/efficient way to compute a checksum for a text file, in order to store the file on a LAN and the checksum in a (seperate) DB ? Presently our guys print out miles of paper evey week, and the only purpose is to send it to archive to (almost) never look at it...

Hi All, I'm having a strange problem happening here - I am using DSN / ODBC linked tables in AC97 to an oracle back end DB. Some tables open up fine, however for some other tables (on the same Oracle DB) when they open, AC97 displays all records as "#Deleted". They quite simply can't actually...

Hi All, Having a bit of strange problem, not sure what else (if anything) to try. I have a report based on a query. I can run the query just fine, it returns five records (at the moment). However, when I run the report, Access crashes... "Program Error ! MSACCESS.exe has generated errors and...

Hoping for some assurance and assistance.... I am needing a database that will help to manage employee leave (holiday) requests. I have one but the current design is a bit...... well, you know. Leave Limits are (presently) applied by one table:- tblLimit ------- payWeek workType (twentysix...

I would like to create a "wizard style" interface to allow users to Select items (staff members) by moving them from a list of "available" staff to a list of "selected" staff (and back again if they change their minds :rolleyes: ). - e.g. Like the Report Wizard, where you move table/query...

I have a Pass Through query which works fine on my PC. I tested it on two other PCs in my office and two further PCs in other (distant) sites. One of the other PCs in the office can run the query with no problem, but the other three get an error message :- ODBC--connection to 'SQL...

OK - Stretching things here a bit... I have this lovely cross tab Pass Through query, which I can run from my PC to another database. It seems to need a special ODBC driver, which I have installed. The query runs and returns desirable data. No problem. I want to run the query, and...

For (a relatively simple) example; If I have a table tblBitMask with one field, BitMaskedField (number-byte data), that has 8 records:- tblBitMask.BitMaskedField 1 2 3 4 5 6 7 8 I want to run a query e.g. WHERE ((BitMaskedField AND 4) = true) I would expect to return:- 4,5,6 & 7 (but not 8...

Can anyone please help with the following:- I was using an ODBC linked table to a Teradata database, and extracting a sub-set of data to local tables to use in a report. I was using an administrator's (or high power user, at any rate) account to do this, and they have now decided I may not...

Dear All, I need some help ! I have a table that stores a (percentage) score for each of 10 categories, for evaluations done on employees. The table also details the employee, and the date of the evaluation; such that an extract of the table would look like this: EmployeeID (long Integer)...