Search results

I'm currently doing some macro in word. I want the macro to run automatically when i open the word document, what i did is rename the macro as autoopen..and it did but it show the visual basic editor window. How do i automate it without oepning the visual basic editor??? i did tried to rename...

thanks to your help but i need help how to access the printer. Our printer here is through network. It has it's own IP address. I know the path where the printer is but then selecting a certain printer is the problem. I have found something on the help menu which is ActivePrinter = HP laserjey...

I need your help. what i need to do is create a macro in word. When you open a file in word format a macro will run that will find printer 1 and make it as the default printer. Once set to default printer it will print the document on the word then once printed it will change again the default...

Hi i have two questions that needs some answers. 1. I want to put in my form the name of the user who is logged in the pc. for example, i am logged in my pc so therefore the name that appears on the txtbox of my form would be claudz. How do i do this? what should be the sql statement to be put...

In access i have an automation that will get new addresses from the address book of outlook express. Then i also have a command button that will determine the duplicates among the new addresses. Upon clicking of the buttton a query will run on the background then append the query in a table then...

Hi there i'm anewbie in visual basic codes so i need ur help guys. what i want to do is use append and update query on certain tables. What are the VBA codes for this? I know how to do this in design view but i need it in codes because what i'm going to do is an automation that will compare two...

I need help....what i'm trying to do is that i have this subform list then on its sides there is a corresponding checkbox per row. What i'm trying to do is like the mailbox of yahoo or hotmail. I want to check the checkbox of a designated row then will hit a delete button and voila!...those rows...

In order to extract the email addresses from outlook express address book you need to go to file menu then-other address book , Then save it as .csv file. And you can open this .csv file in ms excel then import it to ms access. :)

Yah i know that it can be done through query. But what i'm going to do is an automation that will compare data and auto-delete email addresses. because what i really need to do is get these new email addrsses from the outlook express address book then autocompare and autodelete duplicate...

I have two tables containing email addresses. ONe is the master table and the slave table. I need a VBA CODE that will compare these two tables and will automatically delete email addresses in the slave table that are already in the master table. And an output table will show ,after...

I have table x and y. Both table x and y consists of email addresses,first name and last name. I made an unmatched query from these two tables and i called it table z. In order to get the company names from the results, i made an sql that will extract the company names from the email addresses...

I need to export some data to outlook express. How do i do this using macros? This data includes a person's email addresses,last name, company, etc. thanks.

I'm a slight beginner in access and i need your help. I really dont know where to put this question so i just posted it here. I have a resulting query that contains email address, firstname,lastname,and company of a certain person. How will i able to export these info in outlook express in the...

another question What's the syntax for if then else loops. example: if company="R", the result would be richard else if company="A", the output would be alex ....how do i write this in sql command? thanks!

hey thanks! it did worked! :)

How do i use the FIND and MID command in acces using queries. What i'm doing is i'm trying to separate the company name from the email address. ex. claudine@intel.com = I'm going to extract the "intel " from the email address. i have already solved this using excel. What i did is that one...

I dont really know which one to use, queries or macros. Because i'm just a beginner in access. I have two tables consisting of email addresses and I need to get the common and uncommon email addresses from these two tables. How do i do these? thanks