Threads Replies Last Post 43 Pages: <<  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  37  >>   Access vba question How do you spawn an event from a combo box condition?... 2 03.04.2006 23:40:02 Help help help Scenario: I am attempting to auto calculate some fields. I have a program that prints rental leases. I have 4 fields as follows: Months = [Term] Days = [TermDays] Begin Date = [LeaseBeginDate] End Date = [LeaseEndDate] What I need is for the user to be able to enter the number of months the lease is for [Term]…Once they have entered the number of months they would enter the leas... 4 03.04.2006 20:55:22 Barcode location I need to create a report containing barcodes. The barcodes should be displayed in different location on the report depending on the value of the current record. For example if the current record value is FA01R1 (F = front, A = tray A number 01, R1 = 1st right position; max. 2 right positions, and so on) the barcode should be displayed in the upper-top corner of the report (landscape view). T... 2 03.04.2006 20:46:32 Conditional Macro assistance, please Hi, I need to set up a conditional macro to help do the following: If someone works in the Accounts department (AC01), their salary needs to be in the range 10,000 - 30,000 If they work in the QC department, their salary needs to be 4,000 - 25,000 Anyone else can have any salary. I also need to prompt with appropriate messages explaining what are acceptable salaries for the departme... 5 02.04.2006 09:24:18 how to update a calculated control before a macro runs? I am using Access 2002. I'm not quite a beginner, but although I'm learning fast I'm still not much good at writing code. Apologies for the length of this post, but the problem is complicated (or it seems that way to me). I have set up a form which contains two subforms. The form shows clients from a list, the first subform displays the budgets they've been allocated for various item... 3 02.04.2006 00:22:04 Multiple criteria in dcount calculation I am not getting the results expected. Anybody see an error in this statement? Can I use two criteria in the expression? DCount("[ProIdent] ","tblSR4Data","[ProIdent] =" & [Forms]![Project Maintenance Menu]![Proj2Get] And "[LGBRDate] =" & [Forms]![Project Maintenance Menu]![LGBRDate])>1 -- KMS Technical Solutions... 2 01.04.2006 23:08:08 Importing/deleting tables Calling all macro experts out there! I am automating import functions to be run from buttons on a form for users who will be doing data entry and they do not know the inner workings of the database. I want to be able to set a macro that imports the most recent version of Table A from Database X into Database Y and then deletes the older version of Table A in Database Y. However, I wou... 3 01.04.2006 20:26:01 How come expression builder is disabled in macros? The "Build" tool appears to be disabled in macro design in an .adp project connected to a SQL server. Is this by design or can it be enabled somehow? It seems to work fine when I open a .mdb database. ... 1 01.04.2006 18:59:55 Anybody has/know a macro for copying files ej:fonts? I want to create a macro, a script... a folder action... or something that would copy my fonts to their -Mac- font's folder. Does anybody know any macro, script or similar? It doesn't care if MacOs would ask for confirmation, but it should pop up and proceed by itself once inserted the CD and accepted the copying. Thanks.... 4 01.04.2006 11:33:16 Tab Control effecting subform setvalue macro I am using Access 2002. I was having some issues with using the SetValue on subforms and learned here that I need to identify the subform and subform control to get the Setvalue macro to work. Now that I put about ten subforms on a Tab Controll to see the subforms conveniently I can't get my setvalue macro to work. Does the Tab Control influence how I identify the controls to be set in... 4 31.03.2006 23:58:00 field size in access If the field type is number is there a way to limit the size of the field? I need to create a flat file (ascii) from an access query but the field sizes must be exact. Does anyone know how to create a flat file (ascii) from a query? I have only been able to use a macro to create a .txt file, which doesn't work.... 2 31.03.2006 20:06:57 User getting error message from open pivot table command I have a user that is getting a macro error. It happens when the user clicks on a button that will open a pivot table. Only this user has this error. The error message is: You tried to run a macro of used the DoCmd object in VB. The argument number above (2) is the position of the argument as it appears in the Macro window, the Action Failed dialog box, or the object browser. Try one... 1 31.03.2006 17:10:03 Programing Help!! I am creating a data access page, and i would like a new record to come up when the page is opened on the web. Also, I would like to be able to close the DAP, when the person clicks on a hyperlink, which brings them to another DAP. is this possible?? any advice would be greatly appreciated! PS: How can i write this in HTML, and where in the code should i instert it?... 1 31.03.2006 02:18:02 Programing help! I am creating a data access page, and i would like a new record to come up when the page is opened on the web. Also, I would like to be able to close the DAP, when the person clicks on a hyperlink, which brings them to another DAP. is this possible?? any advice would be greatly appreciated!... 1 31.03.2006 02:02:01 SendObj macro and Outlook... annoying pop-up message help! Hey everyone. I've recently set up a SendObj macro to e-mail personal reports to management members in one fell swoop. The macro consists of about 25 SendObj calls, each sending a different report to a different e-mail. My problem is this: Everytime I start the Macro up, I get a message from Outlook that reads "A program is trying to automatically send e-mail on your behalf. Do yo... 2 30.03.2006 23:44:59 backup macro is there a way to program a macro to run a backup each time a person closes out of access. Also my tables are in SQL so how would I do that?... 1 30.03.2006 16:11:02 Use entire table as a record in Access? I am attempting to get Access to behave in a way that is similar to Excel in some respects... Currently, payroll is using excel to post weekly employee hours. The current list of employees is posted with the hours they worked for each day during the week on one worksheet, the next week's hours are posted on the next worksheet and so on. To get an Access application to be adopted by pa... 11 30.03.2006 14:12:02 Master Macro I am trying to run a Master Macro that will run (4) child <output to> macros, where each child has a start time and end time criteria for the queries. Sounds easy, however I am wanting enter the start time and end time only once for all (4) queries and have Access populate the additonal pop-ups for me. TFTH, Tom ... 2 30.03.2006 04:16:41 delete a file macro i'd like to write a macro to delete all excel files from my desktop. i've tried using the record macro option but can't even get it to delete one file. i was hoping for some kind of wildcard code like statement*.xls. can anyone help ... 4 28.03.2006 22:30:48 Linking Records between Tables: Compensation Offered First of all I realize that this is an extra long post and I'm guessing a challenging one, too. I would be willing to offer compensation to anyone who is willing to help me accomplish this task. Please provide me with your contact information and I will be in touch to discuss. A gracious thank you in advance for taking the time to read, ponder and possibly suggest a solution! I’m... 1 28.03.2006 19:57:01 Sending email question Hello - I have created a simple contact list (300 entries) and everything is running fine EXCEPT when I want to send an email to the person in my address book I can only seem to get Outlook Express to open - not actually open an email message with the subjects address in the 'To' line. Is this possible? I created a macro with RunApp to open Outlook Express but don't seem to know how to... 2 28.03.2006 18:49:03 Number Format in Textbox Hello, How do I set a textbox in form to show:- - blank if the contain is zero - 7.25 if the contain is 7.25 - 7 if the contain is 7 I tried to set to General Number it shows 0 if it is zero. I tried to set to #.##;-#.##;"" it shows a period if it is zero, also it reserves 2 spaces at the right most. Thanks for your help. HL ... 2 28.03.2006 16:30:04 GoToNextRecord Hello All This problem relates to one I posted last week and which Steve Schapel helped me with. Although I was then able to get my macros running OK, I am now trying to use the same principle for another use and am coming up against similar problems. The problems comes from a macro with which I am tring to do 2 things - go to the next record on the current form (which is open in con... 1 28.03.2006 13:31:51 Access: Create a macro to format a table field to currency? How can I create a macro that will change a field, within a table, format from text to currency? The field is created by a query expression that defaults to text.... 2 27.03.2006 19:39:31 I WANT MY COMPUTER TO FIX ITSELF PERIODICALLY. LINKS? ALL FREE/PAID LINKS FOR COMPUTER FIXING ITSELF HOW MUCH DO YOU HAVE TO KNOW ABOUT COMPUTER BEFORE THIS CAN BE DONE? THANKS... 1 26.03.2006 22:51:28 43 Pages: <<  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  37  >>