Threads Replies Last Post 43 Pages: <<  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  32  33  34  35  36  >>   Linking Question Suppose I have numerous tabs in a spreadsheet and let's say one is call "Co 1". If another tab has Co 1 in cell A1 and Co 2 in cell A2. If I am in cell B1, is there a way to use the contents of cell A1 to link to tab "Co 1"?... 3 09.04.2006 15:59:02 Macro Error: Can't Find the Macro I'm using Access 2003. I downloaded the Issues template. When I open Edit Contacts and attempt to select a report by double clicking a specific report for that contact I get an error message that "Issues can't find the macro 1stReports: On Dbl Click in macro group View Reports Macros." Below is the macro that appears to be the problem. The command "On Click" works properly. The command "... 4 09.04.2006 15:49:02 Start Earning Money 15 Minutes From Now Did you know? $29 can make you $1,000? And $1,000 can return you $3,081,484 in 3 years? (without you lifting a finger) Yes, we will show you how AND give you the method Yes, InvestPlace uses extremely powerful tools InvestPlace contains a powerful combination of two match winners... This is some valuable information. I'm using it and watching my money grow everyday. ... 1 09.04.2006 14:21:33 how to retrieve the report names from the MSysObjects ... 8 08.04.2006 18:34:43 How can I monitor a macro by query name and status? I have several macros that run multiple queries and would like to monitor progress as queries run. I'd like to see the query name and status. Is there a setting for this or an add-on I can get? ... 2 08.04.2006 09:08:02 OutputTo macro with MsgBox - Help! Hi, I have a an action macro OutputTo that exports my queries into Excel. I want to include a message box saying something like "Data exported successfully" once it has been exported (clicked "OK" in the Output To dialog box). However if the user clicks Cancel instead, the msg will still display, even tho nothing has been exported. There really isn't any code to work with since it's just... 2 08.04.2006 04:38:45 Run time error 2482 This is one of those ‘Why in the world is that . . .’ questions. I have a macro attached to On_Current on frmLaurieSheet Macro reads: [txtbuyerfullname] Not Like "none” set value [Forms]![frmLaurieSheet]![cboAssignBuyer].[Locked] yes [txtbuyerfullname] Like "none" set value [Forms]![frmLaurieSheet]![cboAssignBuyer].[Locked] no I have saved the macro as a module, to g... 3 08.04.2006 00:45:01 I cannot decipher my macro error message I'm using Access 2000 to build a budget database. I don't know what to do about the error message I'm getting on a form. When I open the form the message comes up saying, "Microsoft Access can't find the macro 'mcr_RequiredFieldWarning_ProjectName.' The macro (or its macro group) doesn't exist, or the macro is new but hasn't been saved. Note that when you enter the macrogroupname.macron... 5 07.04.2006 13:19:01 Publish known bugs Please can you publish all known bugs for MS products. As a developer this would help me enormously. I am using Acc2003 and I have a scenario where: Claimed = 500 Cap = 465 and Acc2003 SP2 returns Claimed > Cap = False Is this a known Access bug or not? ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. ... 2 07.04.2006 12:29:07 OPENFORM I am running a macro using "OPENFORM" I would like to use a "filter" or a "where condition" to find a specific record. I don't how to create either or where to find help with coding. Please help... 2 07.04.2006 12:25:08 Need Help Writing First Action Command Button In a form I have created, I have two tabs. I would like to create a button on the second tab that will take to first tab on the same record. I tried to use the wizard for this but with no luck, Any Advice would be well received. ... 3 07.04.2006 04:36:34 MsgBox Hello all. How do you Adjust a Msg Box Window Location? I have a Msg box that comes up with Instructions for the User, but it covers the data enter window. I would like to make it pop up in a different location, so it will not the other windows in which the macro opens. Vincent ... 2 07.04.2006 03:29:11 DateAdd Part II > 1Field= a date >> 2field= Text (8 Possible options) >> I want Field 3 to Display a Date which =Field 1 (DateAdd) but based on >> the >> text of Field 2 >> >> Filed 2 will always use one of the 8 Options, no exceptions (if that >> makes >> it easier to code ! ) >> >> ie: >> Field1: 10/20/2000 >> Field2: R... 1 07.04.2006 01:51:03 DateaddDate Hello all, I am trying to figure out how to calcualte a Field (Date) from another Field in the same table. I tried using the Dateadd expression as well as a query, I just cant seem to get it right. Here is what i am trying to do: Field 1: 5/05/2002 I want the value of Field 2 to be 30 Years later: 5/05/2032 Can anyone help me out? Thank you. Vincent ... 6 07.04.2006 01:46:14 Macro/RunCode - referencing a listbox on a subform I have a shortcut menu on a listbox that calls a macro. The macro passes the listbox to a function via the RunCode command. This works fine when my form is not a subform, but it doesn't work when I place my form on another form (where it needs to be). I've tried using [forms]![mainform]![subform]!listbox and a million other combinations, but nothing is working. There must be somet... 2 06.04.2006 22:15:02 Use Macro to Print Reports Hi, I have a form with 6 option groups. There is a report for each possible combination. I have a command button that runs a macro to get the correct report. I want to use this same concept, but have another command button allowing the user to automatically print the report without having to first run it in print preview, then hit the print button. Also, I would like them to be able to... 3 06.04.2006 18:17:06 Security Warning when downloading Templates from Microsoft.com When I go to download the inventory management template from Microsoft.com I get a warning saying that the file may not be safe if it contains code that were intended to harm your computer. Then it asks if I want to open the file or cancel it. May macros security is set on medium which it suggested before I got this warning. What do you suggest? Thanks!... 2 06.04.2006 17:37:39 Hi > This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --B_3227184840_3948901 Content-type: text/plain; charset="US-ASCII" Content-transfer-encoding: 7bit Hv --B_3227184840_3948901 Content-type: text/html; charset="US-ASCII" Content-transfer-encoding: quoted-printable <HTML> <HEAD&g... 1 06.04.2006 12:13:59 How to change criteria in a query using a macros I have aprrox 50 queries that all have one field on common (Division). I need to run each query for each division (10 of them). Fortunately, I was ably to write VBA code in Excel that automatically runs and down loads the queries to an excel sheets. Unfortunately, each time I run 50 queries, I have to stop and go in to each individual query and change the division number to set it up fo... 2 06.04.2006 05:12:25 Prefill records based on form entry Hi, I believe that I need to use a macro for the following. I have a form based on test_attempt table which shows test_id, student_id, test description, date. Then, command button on form pulls up another form. This second form (QA) is based on a query of tables Questions and Answers. The Answers table is empty because the student has not yet answered the questions! (The answers ... 1 05.04.2006 16:40:02 Connect to DB2 Hi: I have to update a db2 table from Access; is there any way to automatically connect to DB2 - I would like to avoid typing the User ID and password. Thanks, Dan ... 1 05.04.2006 16:38:01 Transactions with VBA Hello, I want to delete and update records of different tables and when there's an error, nothing should be done. I read about ADODB.Connection.BeginTrans and .CommitTrans and .RollbackTrans. I am not sure how to use them. How do I know if a transaction was successful? Thomas Wieczorek P.S.: I am using Access2k and Access2k3 ... 3 05.04.2006 12:16:47 Need help I have a formula of sort that is suppose to count the number of days between two dates. I have that part down I think. I need this to happen only when the beginning date is a day other than the first day of a month. In other words if the date is 3/1/06 I need the formula to put in a zero “0”…if the date is anything other than the 1st of a month then it should calculate the number... 3 04.04.2006 14:04:02 table field upgate in code Hi All, I having trouble developing code needed to update tblClient w/ record from tblSkill. Here’s the situation: tblClient update records using tblSkill. tblSkill has one field containing carpenter, labor, painting etc. When clients identify a skill on frmClient, tblClient must be updated using the record from tblSkill. What is the code to update tblClient with info from tblSkil... 2 04.04.2006 01:06:48 Tab Control SetValue Macro Follow Up question Previous posts and responses from Tina helped me look at possible solutions to a subform control to construct my setvalue macros (mcrChest in my applcation). I am still having problems identifying the correct control. I left the sample Access 2002 database on one of my web sites www.watersafe.org/nicunote0.zip and a quick look could help me see what I am missing on the cardio-pulm tab... 1 04.04.2006 00:12:38 43 Pages: <<  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  32  33  34  35  36  >>