Threads Replies Last Post 43 Pages: <<  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  32  >>   Updating Inventory On The Fly I have a form that uses a combo box to look up Parts. The user enters the quantity of the part to order and the OnHand number shows up. Now, what I need to do is add a button to "Update Inventory" that will commit the Quantity, go back out to the Parts file, and subtract the Part order from OnHand and refresh the form with the updated OnHand quantity. Example: The Form pulls in the Part... 3 16.05.2006 14:49:02 Cell content of a cell based on the active Cell Good afternoon, I have a situation where the content of a cell is based on what the active cell is. This is to display a Help message. I know i could use the Data > Validation > Message but this is not a good use for what we are trying to achieve. If the Active cell is A1, then B1 = the content of a cell C1 If the Active cell is A2, then B1 = the content of a cell C2 If the Act... 2 16.05.2006 05:25:28 macro to pass text I am working on a database, that has a publication # and title. I am trying to pass the title to a pick list document via a macro, like "basing a combo -box on another combo box" type of situation. I only want to show the title on the pick slip and invoice for confirmation. I can get the query to run and have the doc# as a criteria to enter, but I am not knowledgeable enough to fill i... 1 15.05.2006 19:34:02 Macro to run report n times Dear all, Thanks for all the help I have received from this board. Anyway here is another obstacle I have. I have form that when click a button on it a report will be generated. Now is there a why to create another button that will run the report more than 1 time. What I mean is before I have a certain month I want the report to generate (Ex: January). Now I would like it to a couple of mo... 6 15.05.2006 19:32:53 Cannot get SendObject to run Hello All I am using A97 and W2kpro. I have a new PC that I am trying to set up exactly the same as an existing PC. On the existing PC outlook express is the default (and only) email program, and I have no problem using the SendObject access macro command. On the new PC again outlook express is the default (and only) email program, and with the same account as on the existing PC, but th... 7 14.05.2006 09:06:06 How do I setup an AfterUpdate calculation from another table? The objective is to load the field “ExtPrice1” after Qty1 is entered (in one table) using the UnitPrice from the Parts table. I thought a very simple process, but... If AfterUpdate(Qty1) is, “=[ExtPrice1]=Forms!Parts!UnitPrice*[Qty1]”, then I get this error: Test can't find the form "Parts" referred to in a macro expression or Visual Basic code. If AfterUpdate(Qty1) is “=... 12 14.05.2006 04:56:12 Create a Macro w/Append Query Hello I have about 50 append query's created that are based on both linked and imported tables. I have set up each append query to once refreshed to repopulate my master table, however, I don't want to have to refresh the query's daily. How do I set something up to automate the process once the file has been opened. I have never written query's in access before only excel. Pleas... 2 12.05.2006 23:01:11 Macro to Create A Report Can a macro create the following report: Using this logic, ExternalSymbol(NewId"N") and ExternalSymbol(NewID "N+1") are not equal AND Duration1(NewID "N+1") is less than 0:00:05. Here's the original table: NewID NewTime Duration1 ExternalSymbol 1 9:31:16 A 2 9:31:37 0:00:21 B 3 9:31:41 0:00:04 B 4 9:31:50 0:00:09 C 5 9:31:53 0:00:03 D 6 9:32:02 0:00:09 E Here's the rep... 2 12.05.2006 22:56:49 ole object in access to a word serial letter I have got an accessDB with a field, that contains an Word-OLEobject. Now I will write a serial letter in word and would put the ole object into this serial letter. So that the (formattet) Text of the (Word-)OLE is in the serial letter. Thanks for your help. ... 1 12.05.2006 10:14:19 OPEN APPLICATION how can i open an excel worksheet by using a macro? ... 2 12.05.2006 08:47:36 Building a dynamic file name using OutputTo Is it possible to automatically change the spreadsheet name each time i export data from an Access query using the OutputTo action? The output file name needs to consist of (1) some literal values, (2) a variable entered into the form the user uses to start the process, and (3) a value from a second query based on a value also entered into the form... 2 12.05.2006 08:43:34 exporting report I wonder if anyone can shed light on my problem. I have a report which I have been happily exporting to excel for a client. Quite suddenly with no logical explanation the export has stopped working and I was using a send report macro. I get a message "Action Failed" with the only option to halt. If I halt, the report has appeared but not exported. The report is not particularly com... 2 12.05.2006 08:38:51 Current root of the Access DB I'm searching for the correct VBA expression to save something in the same root like the current Access DB. In Excel I think the expression for Access is "Activeworksheet.root". Thanks ... 3 11.05.2006 09:18:26 Export an OLE Word document I have the follwoing solution for exporting an ole Object out of Access into an seperate file. But the probplem is the following: the Format of the file is not Word-compatible, so I can't open the file in Word! Please can you help me what I must change in the code to an an Wordformat? Thanks. 'Begin of Code Function BinExport(tabelle As String, PfadDatei As String, BinaryFeld As Stri... 1 11.05.2006 08:38:06 Warning message How do I create a macro that automatically provides a warning message when the user opens the form. cheers!... 3 10.05.2006 22:58:57 How Run query then Automatically Link to Excel via Macro ... 1 10.05.2006 16:31:02 Run Batch file via macro? I've created a batch file to run some software which runs fine through Windows (with some internet security changes). I desparately need to incorporate this batch file into a macro to prevent a 30 min job becoming 4 hours through doing it manually and for other users to run. Basically just need to work out how to run it through a macro. Everything I read seems to be about shells and VBA (... 3 10.05.2006 06:44:02 ACCESS MACRO TO PROMPT USER TO RENAME A TABLE? I need to repeat a query many times to isolate data, my query prompts for the appropriate criteria. I want to create a macro that will re-run the make table query and then rename the table and continue. I will need to change the name of the table after it is created, but I want the macro to do it and prompt me for the new name each time? Any help would be great. ... 2 10.05.2006 03:35:39 Type Mismatch during Setvalue macro I have a subform (ACTIVITIES) within a form (END USER), which has ‘Distributor ID’ in the field list but not on the form. I have ‘Distributor ID’ in the field list of the parent form (END USER), which is selected using the row source of a combo box. The combo box takes the information from a linked table and puts it into the ‘Distributor ID’ field in the table. When I sele... 4 10.05.2006 02:12:57 How do I give the user a File Open dialog on transferText macro? I know I've done this in older versions of Access. I use ImportDelimited, specify an ImportSpec, specify the target table, and then type some clever text in the file name text box so that when the macro runs, a file open dialog will be shown with which the user can hunt the desired file. What is that clever text? I remember it beingsomething like = GetFile() or the like. Than... 2 09.05.2006 21:57:28 Macro to pause after each query I have a macro that runs about 15 queries. The problem I have is they all prompt in the beginning of the macro and all run at the same time. Is there a way I can have the macro pause after each query? ... 3 09.05.2006 21:39:52 Transfer Spreadsheet (Link) to Specific Worksheet and Range I want to create a link, using a macro, to a specific worksheet and range. What is the syntax? e.g., I want to link create to worksheet "Sheet1" and range A1:B300 in the Excel file "C:\Transactions.xls". What values should I type in the macro fields?... 2 09.05.2006 18:48:11 Macro to Calculate a Median I am trying to use this sql. Does someone have vba code for calculating a median ? Switch([PriceC] = 0, [PriceD], [PriceC] < 0.15, [PriceC], [PriceB] <> 0 AND [PriceC] <> 0, MyMedian([PriceB], [PriceC]), True, 0) Thank you in advance. ... 3 09.05.2006 16:24:01 Comparing 2 Adjacent Records My database looks like this: ID Time Date Code 1 93116 20060403 UMUD06C30.00 2 93137 20060403 QAAE06C65.00 3 93141 20060403 QAAE06C65.00 4 93150 20060403 DLQD06C30.00 Is there a way to filter out (Exclude) Record 3 based on the logic: If ID "N" Code is the same as ID "N+1" Code and the difference between Record N+1 Time and Record N Time is less than 5 seconds. I t... 1 09.05.2006 16:11:01 macro to email report How do I make a macro email a report made in Access that is in the body of the email and not as an attachment? Thanks.... 5 09.05.2006 12:58:47 43 Pages: <<  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  32  >>