Threads Replies Last Post 43 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  >>   Macro to create automation. This is a very basic question, and any help would be appreciated. I have a really good understanding of Access with the exception of Macros. I am attempting to create a macro which would take an entire population and make it so it will only show a table where a field is equal to a criteria provided by the user. I am assuming this can either be done by asking the user to supply a par... 4 18.10.2006 01:16:31 Run a Macro in a Query... that will update a main table the query is attached to on close of the form being used? -- Thomas... 2 30.09.2006 18:08:11 Macro to calculate days in a month I am working with a Microsoft Access Database helping a non profit organization try to figure out how many nights in a month people are staying in there shelter. I have two fields a Check In Date and Check Out Date Field. Therefore to figure out the nights a person stayed, I minus the Check Out by the Check In Date. The problem is if they check in the prior month, let’s say Febru... 4 30.09.2006 17:56:53 Recv'g Message: Unknown message recipient(s); the message was not Not sure what happened - but I have been executing the same Macro for 6 months now, and all of the sudden, I receive this message: Unknown message recipient(s); the message was not sent. It's a very simple send object command...the email address is correct, I even tried different email addresses. It is a query that I try to send...any idea what could have all of the sudden went wrong? Th... 1 29.09.2006 14:08:02 theoretical question I have never written a macro so I need some guidance please. I have a query that pulls data for all of our marketing reps. The query sorts the results based upon last name. What I would like to do, if possible, is export or transfer to a spreadsheet the results but put each respective marketing reps data on a seperate worksheet. Is this possible? If so, where should I begin? Many thanks... 3 29.09.2006 13:30:21 Creating a Mail Merge Macro I have created an Access Database. In the database I have a field titled "email address". I wish to use MS Word send an email using it's mail merge feature to all the addresses listed in this field. If I have one email address in the field: IMATEST@Gmail.net The program works fine. But, I wish to have MS Word send it to multiple address at the same time. The database field l... 1 28.09.2006 17:45:02 change output object to tab delimited Currently under "design view", under "Macros", I have an "output to" record. The "output type" has limited options, and I need to get this changed to "tab delimited format". Please could someone offer some assistance, as I have found nothing on the net. Thanks... 8 28.09.2006 01:42:24 Printing different reports based on criteria I have two different invoice reports based on productID. After I have entered what invoice number I want to see, my commandbutton should print report A if productID is between 80 and 89, else it should print report B. Is it possible to put this criteria to OpenReport-action or is Visual Basic needed. Thankful for Your help!... 8 27.09.2006 17:40:51 Use Direct-X date picker to pick date range for query I have set up a data base with a query-based form in which I enter a range of dates to call up a set of records...so far so good. I also have a Direct-X date picker which is very easy to use and which I can plunk almost anywhere in a form. What I want to do is use the date picker to pick the dates for the query. Can I do this with a macro (i.e. have two fields, each with a date picker... 3 27.09.2006 00:07:02 Convert Currency (USD) from Numbers to Text I know there is a macro that does this that works in Excel. Will the same code work in Word? Where can I find that macro? My goal is to enter the currency amount in number format in a field in a Word document and have it appear in text format in a second field, e.g. $4.95 > Four and 95/100 dollars. Or would I use text boxes or table cells? Or can't this be done? ... 4 26.09.2006 21:31:36 Sending a Query (in a spreadsheet format) to a shared directory Hi - I have a query that I need to send to a shared directory - how can I do this via a macro? I know how to sent via email, but what command do I use to send to a directory? Thanks ... 2 26.09.2006 20:06:13 Remote server error My problem is that the coding (below) I have to print a document (from a template) based on the current record (MSAccess Form) works fine for the first instance, but after that I get an error message of "THE REMOTE SERVER MACHINE DOES NOT EXIST OR IS UNAVAILABLE". If I restart the database the document will print but I get the same error when I try to print any others. The code is: P... 1 26.09.2006 17:35:05 Insert photos Hello How could I insert a photo on the database and show it in a form? I have created an OLE object and try to insert a photo but I don´t success showing the picture in the form, I can only open it clicking twice and see the image but not surfing form one record to another. Thanks for all ... 3 26.09.2006 17:28:02 Get Record Count Number by Macros Dear all, Is it possible to get the numbers of records from a query / table by using Macros? Thx in advanced. ... 5 26.09.2006 09:03:02 SetWarnings I am using an OutputTo macro in my AutoExec module. Is there any way to turn off the prompt that asks if you want to replace the existing file? I have DoCmd.SetWarnings False as my first statement; however, I am still prompted to answer yes or no. ... 3 25.09.2006 20:42:02 look up name from inputted ticket number I am running a raffle. I have one worksheet with peoples names and a associated number. I have a second worksheet with the raffle ticket numbers and the associated number of the person who purchased the ticket. I need to be able to enter the ticket number and have the persons name come up.... 2 25.09.2006 18:32:26 Convert into capital letters Hello Is it possible to convert the output in a report in capital letters? How? ... 2 23.09.2006 12:38:43 error trying to use ADO to read table items I'm using Office 2000, getting run-time error 429 (activex component can't create object) which fails on this code: Dim rs As ADODB.Recordset Set rs = New ADODB.Recordset I'm trying to read the text in one column of each row, send that text to a function, and then enter the result returned by the function in another column of the same row. I was using the approach below. ... 3 23.09.2006 05:00:25 Random Trying to create a macro that will open a table and then go to a RANDOM record. After selecting the random record, append it's selection to a different table and delete it from the original. Can anyone tell me what the Access Offset expression is to go to a random record and how to set up the macro to do what I need it to do? Thanks so much!... 4 22.09.2006 02:16:57 How would I create a macro that will open an .xls? How would I create a macro that will open an .xls file on my "C" drive? Thanks! -Adam... 4 21.09.2006 20:18:56 output to excel in specific sheet Can anyone tell me if there is a way to output a query to an excel file in a specific sheet from the macro page. I have the query going to C:\directory\file.xls but this creates a new workbook and I need to overwrite a specific sheet. Wht is the format for this. Thanks... 4 21.09.2006 19:58:26 como fazer uma base de dados para lista de clientes? ... 1 21.09.2006 15:57:02 Print Automation I am working on a db for work. I'm a therapist not an access programmer. What I want to do is 1- create several reports OR output to word/excel, then 2- have a single button to push that will print either the reports or word/excel files. These files MUST look like tables when they print. Each cell MUST have a border all around it. These are my questions: can I have a report that has bor... 4 21.09.2006 04:35:02 Data Duplication in Command Button I used the event procudere On click process in a command button, located on a switchboard, to talley information into a table called Talley. When I created a second button using the cmdSortintoQuestion selection along with click and input different table information in it for a table called TalleyColl, the information copied identically back into the first button I created. How do I keep... 1 20.09.2006 16:24:02 ignore posts you cant do this in access 2003 ... 3 20.09.2006 14:48:07 43 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  >>