Search results for query: *

Fairly new to VBA coding. I have a table called tblManualInput that contains up to 300 customer addresses with a unique customer # for each (field name is CustNum). I have an update query (qryUpdateTotals) I want to run for each CustNum in the ManualInput table once a new spreadsheet of...

Revisiting thread605-1353118 : I've tried setting up a rule to notify me when an email is sent to an additional mailbox that I am monitoring from my Outlook 2003, but the rule does not take the assigned actions. Is there anything else we can do? Thanks, Don

When I use the following Macro command: RunCommand / OutputToExcel It copies the data to Excel, and any blank cells appear to be blank however, when you use the End key plus the down arrow key to move to the next blank cell, it brings you to the bottom of the column. This leads me to believe...

When I use the following Macro command: RunCommand / OutputToExcel It copies the data to Excel, and any blank cells appear to be blank however, when you use the End key plus the down arrow key to move to the next blank cell, it brings you to the bottom of the column. This leads me to believe...

Have come to a road block in using criteria gathered from an input form to generate query results and narrowing the results using less than (<) and greater than (>) operators. I want to allow the user to search for records that have an AVGCOST that is between the two values they enter on the...

We have an Access 2003 form with several fields and a command button which activates a macro to open a query. When you press tab or enter, it cycles through to the next field. We would like to have it activate the command button when you press enter (so you don't have to go to each field)...

In conjunction with MAS 200 (Sage) and Access 97, we have a script that generates sales order numbers for a batch of orders that have been imported into the Access database. The code runs very slow and we are hoping to see if anything can be removed / changed to make it faster. Here is the...

We are running Norstar Modular ICS 4.0 and answer the phones from 9AM - 5PM Monday through Friday. Each morning at 9AM we have to do Feature 921 to change the routing from Night to Day. Then we do Feature 982 to open the business. At 5PM we reverse the process. Is there any way to automate...

We have Norstar Modular ICS 4.0 and all of our phones have only two intercom buttons (the first two buttons above the Handsfree button). We want to add 1 or 2 more intercom buttons so the user can handle more than just 2 calls at a time when they are logged in. Can this be done? If so, what...

We have a Meridian Norstar system and one of our M7208 phones went bad (her extension is 308). We have another phone to give her but that extension is 320. How do we tell it to be 308 now?

Does anyone have a list of the old Excel 5.0 macro commands along with a brief description of each command? Thanks!

We're using Office 97 on a new PC running Windows XP Home Edition. With Windows 98 SE we used to be able to email files from Excel and Access 97. With XP, the &quot;Send to&quot; option no longer appears on the File menu in Excel and in Access, I receive an error when trying to send...

I've got a macro which opens an exsisting table, deletes all the records then imports certain columns from a .txt file (using import specifications). This is done daily so the latest information is present in the table (the text file is updated each day). After running the macro, the records...