Threads Replies Last Post 43 Pages: <<  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  31  >>   Tool Required to Convert Hi , Can Someone help me out to Create a tool in Access which Converts Unaligned data to aligned data in Access. example of unaligned data: xyz x...@something.com --->x...@something.com 05/12/2006 18:25:43 Local Output should be: xyz x...@something.com 05/12/2006 18:25:43 file consist of lotsa data and which are not in order, p... 3 24.05.2006 11:45:56 Use ComboBox in Form to run report from macro I want a form to be a user-friendly interface to select criteria and run reports. I would like to have a combo box allow for a drop down menu that contains the criteria for the report. I'm asuming the easiest it to make the selection a filter for the query driving the report. But I don't know how to build the macro with the right steps to accomplish this. The only macros I've done in... 9 24.05.2006 18:11:01 Grabbing Data from a Subform I have a Form that has an imbedded Subform used for order entry. These are line item purchase transactions. Each line item has a bound field called "Subtotal" that extends the line item price. In the Subform Footer I have an unbound field called "Total Subtotal" that sums the Subtotal fields as:=nz(Sum([Subtotal])). I have a Total field bound to my main Form that is (supposed to) grab ... 19 23.05.2006 21:36:42 Setting the File Name Hi I have a query which pulls data from a table using date fields on a switchboard(StartDate & EndDate). This data list is then exported to Excel using a Macro. I would like the name of the file to include the start and end dates entered in the switchboard/used by the query. Is this possible? Many thanks Kerry ... 3 23.05.2006 11:38:02 how do i create a input form in response to a notinlist event ? I want to create a pop up form to enter customer details when the customer isnt already in the table from a job form using a combo field to choose the customer - what macros do I need to set up . I tried notinlist and got a pop up form to open but when i try to requery thye control on the job form it keeps telling me i have to save it before i requery. I tried saving it and then requ... 1 22.05.2006 22:11:02 How do Hide a table through a macro? I have imported a table through a macro into a database that has, by neccesity, all of the tables hidden. When I import any new table it automatically makes the new table visible. I can not open the database and use the commands in the toolbar as I am not always available, and many times others are using the system. So I must set it up so the macro automatically hides the table. ... 4 22.05.2006 19:31:05 simple 'close' question I have a command button on a form that is intended to close the form without saving the record. It's attached to a simple close macro with the save argument set to no. While it closes the form, it's saving the records, anyway. What's up with that? And how do I get it to stop?... 11 22.05.2006 16:17:02 Hi Hi ... 1 21.05.2006 20:04:36 looping macro I have run into yet another hurdle. I am creating a macro in which I want the following to happen: -open form -go to first record -open query (append table) -close query -check if last record (stop macro if last record) -go to next record -go back to step 3 (open query). I basically want the form to run page by page and run an append query. I would really appreciate the help. -- ... 10 21.05.2006 19:18:03 count loops Is there a way to have a macro count how many times it loops? -- Message posted via http://www.accessmonster.com... 3 21.05.2006 15:41:24 Combining Tables I have created a macro which uses several queries to open and append twelve tables to one table. I typically come up with an error that says "type conversion failure" even though the column headings are the same and the data types are the same. Your help would be greatly appreciated. Thanks!! ... 3 21.05.2006 03:08:42 pause macro until command completed is there a way to cause a macro to pause in MS Access while a form is displayed to make corrections to some data. Then when you close form the macro will continue on. Thanks... 2 19.05.2006 19:00:34 How do I reference a VBA procedure from Access Macro Definition? I have created a number of VBA functions in an Access database and am trying to use them in a macro. I have tried RunCode, OpenStoredProcedure, among others, but Access can't seem to find any of my functions. I have them placed in a module and a static class module but none are there. All are declared as Public. If I use Expression Builder for RunCode, I can find it, but I get an error ... 2 19.05.2006 18:56:03 Where am I in the table when my UDF bombs?? Greetings! Have a UDF that is used in an append query, and it chokes on a particular source data combination. Is there a simple and direct method to determine the record number in the source table when this happens? Thanks, George ... 3 19.05.2006 05:46:24 Appending Text from one column to another Total newbie, easy question, but I can't find the answer. I have 3 columns: Old DocID, Effective Date, and Procedure. I want to append the text strings from the other columns to create a new Doc ID column. So: DocID(77343)_11-08-2000_High-Dose is created from Old DocID "77343" + Effective Date "11-08-2000" + Procedure "High-Dose". So, I know it's a no-brainer, but ...?... 2 19.05.2006 00:57:28 create a form based on a query I would like to run a macro that runs a query then takes the results and sows them to me in a form. How can I set this up? Thanks for the help.... 2 18.05.2006 21:48:49 Pause macro until form closes Access 2003: One of the steps in my macro opens a form. How do I pause execution of the subsequent steps until the user closes the form? I've seen the responses that reference a "timer", but that isn't applicable in this case. I've also tried making the form "modal", but that doesn't affect macro processing. Thanks in advance for your help. Dorci... 5 18.05.2006 20:28:01 Using a query to generate value for field? In Access 2000, I have two fields in a database that I want to populate with year-dependent values. The first field is the last two digits of the year in which the record was added, saved as text format. I used Expression Builder to automatically insert the digits as a two-character string. I want the second field to be a three-character string of numbers that automatically incremen... 4 18.05.2006 17:51:02 Opening A Queries with a Queries Dialog Macro button I need to be able to open about 10 queries by double clicking on the queries name in the dialog box and Selecting them and click on an open queries command button button on the form. I cannot remember how to setup a command button to make it open the selected query. Do I have to create a macro group to open the queries?... 1 18.05.2006 05:08:01 SendObject - Multiple Actions Hi, I have set up a simple macro that distributes the results of a few queries to named recipients. I have set up a SendObject Macro, it has a sendObject action for each location query. There are approx 70 locations. I have added the DCount("*","AIR")>0 to the condition so it does not email reports with no value. However, when I run the macro it gets through about 12 of the loca... 2 18.05.2006 03:31:02 StrConv Format and Proper Use I have an access DB and i need to convert my FirstName and LastName fields to proper case. I have absolutly no idea how this is done. i have read some of the other threads and it appears i need to use the following string: =StrConv([FirstName],3) But where do i put it and what else needs to accompany it so that this will work. Thanks in advance for any help anyone can provide Ne... 3 17.05.2006 19:24:33 How can I prevent certain fields from refreshing when submit is clicked I have a form with about 20 fields and this form is bind to a table where when I click submit, the data from the from will be saved to the table that it binded to. Now there are certain fields that I do not want to refresh when I hit submit. Is there a way to preserve the value in these fields? These are Combo boxes by the way. Thanks ... 4 17.05.2006 19:09:57 macro events Hi, I have created a macro which seems to be working, but there are a few problems. I want the macro to check if certain conditions exist and if they exist , then I want a dialog box to pop up. The user has the option of entering information into this dialog box. Upon closing the dialog box a report is generated. If the conditions do not exist, then I do not want the dialog box to... 6 17.05.2006 16:58:03 information in one form to automatically update in another I have two forms. The first has four fields: Name Current work status (are they working for the company) Status (temporary or permanent staff) hourly rate This information goes into a query which is then picked up by the main form. Is there a macro I could use so that when the information in the first field is updated it automatically updates the information in the main form without... 2 17.05.2006 01:26:28 How to use a single Prompt to supply parameter for macro generating 2 reports I have two reports that I want to print from a command button. I want the user to supply a date as a parameter one time and have the macro print two Thank You letters, one for New Members and one for Renewals. As it stands now, both reports use a single query that prompts for a date and the query selects records with a MemberStatus of "1" (for Renewal) and "2" (for New Members) (these were... 4 16.05.2006 22:46:32 43 Pages: <<  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  31  >>