Search results

I'd like to create a spreadsheet that feeds from access table/query directly and automatically. I update the table and then open an excel spreadsheet, all the fields get updated automatically and current data shown. That's how I would like to work. What is the best way to do it? Thanks.

Thanks a lot. It works excellent.

I tried to find the answer to this, I think simple for expert, question on the forum but coudn't. A report is created from query. I would like just sum up each of two columns with numbers. Which fuction I should use? (they called H and O btw) Thank you in advance

Perfect. Thank you very much.

=[Surname] & ", " & [First Name] This is a field in a form in header. What to do to have surname displayed always in CAPITALS? Thanks.

50 columns in main table, 2 of them are primary key with duplicates ok index (ID and Programme). Now I have other table that shares 3 columns with main table. I want to upload data from other table to main one for those 3 columns. How to do that? Is update query good for this job?

I have main table with 2-field primary key (ID and Programme). I'd like to use update query to update 3 fields from other table. These 3 fields will be changing once a while. I created Update Query per Access Help however it doesn't update anything. Any help? Cheers

How to create control in form header that allows to send e-mail with one click using address in current record view? Thank you.

while clicking hyperlink which take me to word document I take this message, how to get rid of it?

also I created mail merge in word with hyperlink to it in access form but...I get alert: this hyperlink might be harmful... everytime I click on it...how to get rid of it...security level is low at the moment

I did create letter report although it shows only first record no matter what I do...

almost there... it works, however when opening word file from access hyperlink it says that it can be harmful to my computer, then confirming data link properties... lots of clicking to get there...how to get rid of this security message?

thank you, Bob...it seems I got where I wanted :)

nice...how to do the button that doesn't show the full link though, the name of the letter in this case instead?

I Created mail merged letter feeding from my database. Thank you for help. Now, how to open this .doc file from access? Is it doable?

I work in college. I do have a table full of names and course names etc. We send offer letters to applicants. I need a letter that feeds from specific record of the table. Not hundreds of letters. One out of the time. ps we've got novell network with win xp, anyone has to be able to access...

having database full of names and info, how to create a letter which feeds from specific database records with one click, so it can be printed and post it? cheers

having database full of names and info, how to create a letter which feeds from specific database records with one click, so it can be printed and post it? cheers

I might try oracle...which version is the most user friendly if you know what I'm mean... would it be more useful for my stats? I do have 25 tables with names [duplicate and not] and numbers and would like generate report/query summing all that stuff...

cheers, it works...it seems I need to learn some sql