Search results for query: *

OK - I thought I knew a little about Excel but I can't figure this one out: When I press my TAB button, instead of advancing to the next cell to the right, it jumps to the next cell on the next page to the right. I have looked at the help files and my settings but cant seem to find what is...

I have a macro that uses an input box to get some data from the user. I used a OK/cancel button - what is the code to kill the macro if the user selects cancle? thanks

Is there any way to "pause" a macro? I have a macro that imports a datasheet and then begins to shred it into several reports - and eventually mails them. I would like to be able to pause execution of the macro after the datasheet is imported, so the user could verify the data before the macro...

Is there any way to have Excel create an email, populate the "To" and "Subject" fields (don't need message body) and attach a zip file?

In the last few days I have noticed a weird problem with Excel (2003 SP1). If I try to open an .xls file that was exported from an Access DB (on a network share) OR try to open an .xls file that is physically located on a network share, my personal macro workbook is gone. Any one know what's...

I have a spreadsheet that is imported daily into an access database. The spreadsheets columns are always the same, however the number of rows will change daily. The spreadsheet represents invoices from the previous day. What I need to do is check each row to see if a particular location in...

I need to to a docmd.transferSpreadsheet to export a table as a xls file. I can do that easy enough - what I need help with is the VBA to name the file according to the previous day's date. For example if today is 12/12/2005 I would like the exported file to be named 2005_12_21.xls

I have outlook set to NOT check the spelling on emails that I reply to, or forwarded messages, but it does anyway. Is there any way to keeo it from doing that? I have mine set like this: Tools - Options - Spelling (tab) - have "Ignore origional message text in reply or forward" checked.

I am trying to get a count of how many contracts were renewals - The data elements in the table (F1720) are: CHAN8 = Cust # CHDOCO = contract # CHLANO = site # CHCSDT = start date CHCDTE = end date here is my SQL: SELECT F1720.CHAN8, F1720.CHDOCO, F1720.CHLANO, F1720.CHCSDT, F1720.CHCDTE FROM...

I have a textbox where a user will enter a name (one for first name, another textbox for last name.) My SQL will concatenate them (LName & ", " & FName) anyway - I thought it would be nice to capitalize the name in case the user didn't. I did this using an input mask of ">L<??????????????" I...

I have a form that checks that the data entered into a textbox is a number and is 9 digits long. Here is the code I have: Private Sub txtRoutingNo_Exit(Cancel As Integer) ' be sure routing number is 9 digits and a number If Not IsNumeric(txtRoutingNo.Value) Then MsgBox "You must...

I have a form with several check boxes that will toggle depending on other controls/ Currently I have this: Private Sub frmPaymentType_AfterUpdate() chJan.Value = 0 chFeb.Value = 0 chMar.Value = 0 chApril.Value = 0 chMay.Value = 0 chJune.Value...

Daily I have to pull data for a report into an Access database via an ODBC connection. The problem is - I have to start a Citrix connection to a server in another city (where the dsn resides) then open the mdb file on my local PC. Then I do the "File-Import" and select ODBC - then I can select...

I have to send a report out daily that is created with a very procedural process - so I thought, this would be a perfect opportunity to use a macro. I wrote it - and it works exactly as needed - it saves me about 15-20 minutes a day. I created it in my personal workbook. My reasoning was...

I would like to include code in a macro where I could send the active spreadsheet to an Outlook distribution list. Is this possible? Also - would like to be able to customize the subject line. I am currently sending the spreadsheet using this: ActiveWorkbook.SendMail...

I have a macro that takes data from several workbooks and combines it into one (new) workbook. Since the old ones are no longer needed, it would be nice if I could have some code delete them for me. Is this possible? Thanks

I have an application that uses linked tables. The front-end has several queries, macros, modules, etc. If I upsize the data to MySQL, and relink the tables in the front-end application using an ODBC connection, is it safe to assume that the (access) front-end will still function as before? I...

I have an application that uses linked tables. The front-end has several queries, macros, modules, etc. If I upsize to SQL, and relink the tables in the front-end application, is it safe to assume that it will still function as before?

I have 12 columns named JAN to DEC. On a report I want to add these values together. I tried placing a textbox out to the side and use this as the control source: =[JAN]+[FEB]+[MAR]+[APR]+[MAY]+[JUN]+[JUL]+[AUG]+[SEP]+[OCT]+[NOV]+[DEC] But that just concatenates the values together. I also...

I have a table (tblListing) that has: Listing (a number representing an ad) StartDate (date ad starts) EndDate (date ad ends) Cost (price or ad) most ads run for 12 months (for example start may be something like 2/1/05 and end is 1/31/06) what I need to do is list by month, the cost of each...