Recent content by madwoman

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

Excellent, thanks

many thanks, that's great

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

That works fine, thanks very much

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 Thanks the Linked Tables are what are causing the problem. I have reset those and now it's fine. Cheers

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

Many thanks, that would be really helpful. Attached is a stripped down sample of the database Ignore the fact that when you go into the Existing Members Form that there is a blank record, if you use CRTL-F on the surname and Find 'smith' you should get a handful. What we need to be able to do...

Hi Many thanks, this is a bit above me...how do I do this? Cheers