[ms_access] duplicate records in table

2008-06-26 Thread John Young
G'day to all I am new to this group and have a problem I have been given a table with 80,000 records and have been advised that there are approx 5,000 duplicate records... there are 7 fields that contain data and duplicate records will contain same information for each record accross all

RE: [ms_access] duplicate records in table

2008-06-27 Thread John Young
De : mailto:ms_access%40yahoogroups.comms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] De la part de John Young Envoyé : jeudi 26 juin 2008 11:48 À : mailto:ms_access%40yahoogroups.comms_access@yahoogroups.com Objet : [ms_access] duplicate records in table G'day to all I am new to this group

[ms_access] empty combo box

2008-07-09 Thread John Young
I create a combo box on a test form using a table but the combo box will not populate or display any data at all I then created a second combo box and populated it with data from a different table without problem I then create a third combo box using a original table [doing exactly same

[ms_access] Find and Replace window

2008-08-04 Thread John Young
When I open a form I want the find and Replace [Edit Option] window to open as well. Can someone advis on how to do this, as I can not find a way to odo it cheers PS I have still not found the problem with my Blank drop down list re previous posts... John

[ms_access] jpeg photos in access 2007

2009-03-19 Thread John Young
Ihave a database that has been upgraded to access 2007, and it has jpeg photos in a form that display as and when they are updated Ican not link a jpeg to the feild when inserting a new record... you had to load microsoft photo editor in accesss 2003 How do i get my jpegs to display in

Re: [ms_access] Excel to Access?

2009-04-05 Thread John Young
Neil Try higlighting data and headers only and past into a new sheet, then import the new sheet .. you may have a field other than your data that is being imported and is corrupting import Cheers John At 04:52 PM 5/04/2009, you wrote: I am struggling to import a three column list of

RE: [ms_access] Query won't show all results

2009-09-28 Thread John Young
Brad This may sound silly or I have missed a posting ..But, is it possible that you have spaces in the empty fields??? This will appear to your sql as a field that is NOT empty. you may have to try and run a trim function on the field this will remove any empty

[ms_access] Access 2007 report to html

2009-11-12 Thread John Young
I have an access 2007 report that includes photos and I want to export it to a html file ... the available options (unless I have missed something) will let me export text field part to html as individual table format but I can not get the photos exported ... Is there an easy solution to

[ms_access] html from access 2007 report

2009-11-24 Thread John Young
Is there an easy way of getting an access report that has graphics to display as a html page Joyhn Y