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  >>   transferspreadsheet action Θέμα: print data 9/5/2006 6:19 πμ PST Ανά: angie Σε: microsoft.public.excel.worksheet.functions i have linked cells from 1 to 10000 in my worksheet with another worksheet. the other worksheet comes form transferspreadsheet macro from access and the data is not always fixed, it depends on the result of the query. i want to print each time only the cells tha... 2 01.06.2006 20:59:39 Way to avoid 'halt' in macro I am running a macro that opens, selects all and copies records from a query. If there are no records, it halts the macro. Any way to avoid this? The records are being appended to an existing table if that helps. SKB... 5 06.06.2006 20:46:07 how do you make a commandbutton run a macro? I have this project i have to do for work and i want the commandbuttons to open seperate sheets within the workbook - but i dont understand all this visual basic language stuff so can someone please translate it into a dummy version for me - i can run a macro by recording it but how do i make the macro perform within the button??? i remember doing it in college but can not rem think it w... 3 06.06.2006 20:17:02 Macro "dependencies" I would like to be able to find everywhere that a specific table, query, form or report is referenced in my macros. Is there an easy way to do so (similar to being able to view object dependencies)? DKennedy... 4 06.06.2006 19:30:01 Way to keep a log of warnings from Macros? Hi, I have a macro that sets off a series of update queries. In esence, it updates address information on small databases, using address information on our company wide database. I use tables linked through DBO connections to our company db, to udate the smaller Access tables. I set Setwarnings to Off, so it doesn't stop at the end of each step. There are about 15 queries involved. T... 1 06.06.2006 16:36:44 How do I send more than 255 characters with SendObject Function ... 1 06.06.2006 15:33:01 SendObject Macro I am using the send object macro, when it starts i Have a message pop up that lets me know I am sending an email automatically. Is there anyway I can stop that from coming up every time I use the Macro. Donbenz... 4 06.06.2006 07:43:49 Relative file addresses in macros I am developing a spreadsheet which imports Excel data files using macros. I will be distributing this spreadsheet to other users. My macros have fixed file name addresses. Is it possible to specify relative addresses in the macros for these files so that if the spreadsheet is operated from a different file/folder, the macros will still work? If so, please advise how I can achieve th... 1 06.06.2006 06:27:02 How do I unlock a file so that it can be modified? I am trying to unlock a file so that I can modify it.... 3 06.06.2006 05:11:55 How to find a close match? I have a table in Access with 250 rows and 3 columns. The operators input a number let call it A. I need a macro in VBA to search A to see if there is a match or closest number to A on column 3 (let call it B) and then return the data on the same row as B on calumn 1. Any help is much appreciated. DORI... 2 05.06.2006 20:22:56 Import Macro - File Location Prompt I have an import macro which runs multiple instances of Transfer Text on a fixed width flat file using specifications. There are 26 different specs, one for each table that I need the data imported into. Using =InputBox("Enter the path and filename:") for the filename works great, for ONE Transfer Text statement. However, all 25 other transfer statements use the same file, just different ... 2 02.06.2006 19:48:16 Copy linked table and Paste as Data I have a linked table whose primary key data type needs to be text instead of numeric to create a specific join. I want to create a macro that will: a) Copy my linked table - table name SURVEY b) Paste the table in the same db as WEB_SURVEY with "Structure & Data" c) Change the data type of the primary key from numeric to text Can someone please help me out? I'm CLUELESS!!!... 2 02.06.2006 19:44:31 How do I build a macro to open a PDF file?? I want to querry to a bunch of PDF files and open the querry automaticly.... 3 02.06.2006 19:33:44 Populating a List Box Hi, I'm populating the listbox with query having a where condition in VBA code. the first time list box fills correctly but when I change the WHERE condition which is coming from the combo box in the MS Access Form it doesn not clear the list box values from the query done first time and appends the resultset query in the listbox. Please anyone can suggest me how to clear the previous reco... 3 02.06.2006 16:11:17 Go to Next Pgae/Prior Page Macro I know how to do a Go to Page 2, etc. Macro. Can you tell me how to do a Go to Next Page and Go to Previous Page Macro? I am running Access 97 and have a three-page form. -- betty... 1 02.06.2006 15:44:02 hehe ÊÔÊÔ ... 1 02.06.2006 10:58:50 Parameter queries I have macros set up which print off a number of reports together, these are based on queries which use parameters to isolate the desired record - how do i link these so that the desired information only requires to be entered once. The example is a macro which prints off a licence; a badge and a letter to accompany these to the licence holder - the parameter is [Enter licence number] o... 3 02.06.2006 10:32:02 Multi Select listbox Hi, Can anyone help me in using the multi-selected values of listbox in a query to database. any suggestions are welcome. Thanks, Shalini ... 3 02.06.2006 06:43:23 changing the captions on labels just starting out in access and need help !!!!! I have made a DB that many sites will use (siteA),(SiteB) each site has a diffrent site Name, address, cityStateZip and address what i've done is made a Macro using setvalue. it works fine when you enter information into the fields it changes the proper label but when I close the form and reopen it later all the labels have returned to the ... 3 01.06.2006 20:53:10 how to set a macro to show a message at a certain date Hello, For my company, thirty day reviews have to be completed on each client every thirty days and treatment plans have to be completed two weeks after authorization start date. What would be the best way to set a macro to somehow alert me when treatment plans and thirty day reviews are due for each client. I am stumped. I initially thought to create a message box to appear but the... 7 01.06.2006 18:59:43 Macro conditions controlling multiple lines Is there a way to set up conditions in a macro where, say, five lines are executed based on one condition? I'm thinking I saw somewhere that you use the ... (3 dots) to continue a condition but I can't find where I read that. Is this the way it should be handled? Thanks in advance. -- Glenn... 2 01.06.2006 16:58:56 Help with multiple criteria Macro I have a form that allows users to input selected criteria which will determine which report will be run when the submit button is clicked. The form has three fields - first name, last name, and category. The user must select either first name AND last name or category. The report will then generate off the criteria and either return a single name or a list of names in a particular ca... 5 01.06.2006 14:39:02 Looping thru a table problem I've done this before...but for some reason am having a problem today. I want to set a value in one field in every record in the table. Set Value New Record Run Macro I'm only looping 20 times and getting a message that a macro can only call itself 20 times. ... 3 01.06.2006 13:23:02 How to create a macro that gets infor from Exchange Server OR AD Is there a way I can create a macro that will import my contacts from exchange into my db? Right now to get info from my exchange to my access db I go through the steps of File>Get External Data>Import> and so and until I find Exchange. Then I browse to the contact list I want to import and then click on import. I'm looking for a more automated, and more efficient way to do ... 2 01.06.2006 08:33:57 How Run query then Automatically Analyize in Excel via Macro How can I create a macro that will run a query then automatically opens it in Excel. I want to be able to run the query by clicking a button from a Form then analyze it in Excel without having to click on Tools-Office Links-Analyze with Microsoft Excel. Anyone have any suggestions? Is this possible or do I have to use Visual Basic?... 2 01.06.2006 07:54:43 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  >>