Search results

I have a table containing courses data that has been exported from a website application (MySQL) that I need to use in an local Access database application. One of the fields that is in the website table includes ID values from another related table on the website and I need to update these ID...

I have setup an ODBC datasource, User DSN which points to a SQL server database and have tested the connection whilst in the ODBC setup (Windows>Administrator Tools) and the connection tests OK. But I can't seem to see that ODBC connection when I try to setup linked tables in Access. I setup a...

I have an Access database which we inherited and it has linked tables (2 database files, one with data tables and one with forms, queries etc) - the links being set to a path on our local company server. We are in the process of opening another company office in another part of the country and...

I have a table with a field QuotationRef containing a series of values which include a year indicator (eg Q11101/06, Q11102/06, Q11103/06, Q11105/07, Q11106/07, Q11108/07) - where the characters after the / denote the year a Quotation was started. I need to be able to setup a criteria filter...

I have inherited a database which originally did a direct print output when a menu item was selected. However we really need the report to appear in PrintPreview rather than print out directly as we need to be able to export the data to a file before the print output is generated. The current...

Hi I have inherited a database that contains details of staff training data and the tables contain the following: Personal Information Table: PersonalID Surname Forename EmploymentStatus (this contains either Staff, Operative, or Supervisor) Training Courses Table: CourseID Course Name...

Hi I am generating a report which shows exam results. My results table contains 6 different exams in the table and against each exam there is a single letter value for the actual results (eg P, F, C, D). When I display the result for each exam in the report I want to display the following as...

Hi I have just inherted a Personnel System which appears to have two linked databases: PersonnelDatabase.mdb PersonnelStorage.mdb It was originally operated from a server but is has now been copied onto a single user PC. Whilst it was on the server if you opened PersonneDatabase.mdb you would...

I am trying to generate a report from a database query which contains exam results, and the report is a letter which confirms a candidates results to their employer. In most cases each candidate only has one record line each year containing multiple exams and results and I can generate a letter...

I have inherited a partially completed membership Access database which I understand was originally generated from a load of linked FoxPro tables. There is a form which uses multiple tabs, the first tab contains general membership data (ie name, age etc) and this pulls data through from the...

Hi I have a set of membership records which have data input via a simple form. When looking for a particular record I use the standard Find menu item on the whole record set from the Form view, and move through the results using the Find Next button. Is there a way to move back through the...

I have inherited a 5 table database which is associated with membership details and all tables are linked via the membership number which appears in every table..eg Main Register membernumber, surname, forename, age etc etc etc Home address membernumber, address1, address2, address3...

I have inherited some Foxpro tables which I am trying to convert to Access and I hae set the exported tables up and have tried to set the relationships between the tables so that I can run queries and setup forms to review and add new records. However I am struggling to get the relationships in...