Search results

Pros Fantastic program Cons You do something one day and completely forget how you did it a week later! Not much help really...sorry

Thanks I was perhaps being a bit lazy in not wanting to convert the databases........I have learnt my lesson

I had a look at the list of services etc that you provide when first discovered the website.....i have not used any of them yet - but would be nice for small projects to be carried out etc which I assume you do already... but difficulty will always be with pricing I suppose - how longs a piece...

Any ideas on this one recently installed access 97 onto a machine already running 2000 (to enable a database to be designed in 97 for someone else not running 2000) Since then had major problems with the wizards - ie not all of them work in 97 or 2000....tried reinstalling office 97 and 2000...

Merging from Word is easy....If you have a very simple database set up in access with a table with name and addresses etc In word - go to tools mail merge as normal Create the letter as normal In get data use Open data source Change file type to MS Access databases Select the database a box...

See my reply somewhere below today on mail merges - set up your mail merge in word as normal and when getting the data link it to the table you have set up in your access database - use the query option in word when actually carrying out the mail merge to select the specific record (s) you want...

Harry Works spot on........much appreciated

I have set up quite large mail merges in word linked to tables in databases. I have it in the form of a "letter template" and use the query option within word to select the record or records I want. Ie I have over 1000 contracts and set the field "contractno" to the one i want to pick up and...

Thanks Have tried the Requery which although works creates other problems as I am running subforms and tabbed pages - the requery does updtae but takes me out of the "current view" I am in. I will have a go at the other options suggested ...

I have a main form which displays summary data and another form to enter data. It is set up so when the data entry form closed the main form is updated immediately (only displaying info for that record ...but I don't think that has anything to do with my problem) I have done this by entering...

Many thanks for the replies, I will see if I can crack it .

I need to set up some sort of simple (!!!) security / passwords on a database used over a network. To be honest I have read too many horror stories on user level security (lock outs etc) and the database is such a fundamental part of the business to "play around" with if it all goes wrong...

Many thanks Will try this and fingers crossed.....NB, out of curiosity does any one know why it only affects one of my databases????

Unfortunately not yes or no But tried with aol and could not get it to work, now using with Outlook express Hope this helps

I am running access 2000 over a network and have set up two seperate databases. One works spot on, however I am experiencing problems when previewing reports in the other. Each time I preview a report it does not restore to the original print settings for that report. Ie different margins and...