Search results for query: *

I have a userform that Pulls data from the spreadsheet as well as saves it back to the spreadsheet if I change an Information.. I would like to be able to view the character count as I enter new text inside the userform. I have tried many things already. And what I am doing does work. But I...

Please bare with me I am brand new to Javascript, I have done some other coding with VBA. I am trying to build a shipping calculator to post on a Website. I am little confused on how to do something, Or how to make it happen. I am short on some of the terms. I eliminated alot of the code...

Goodmorning, I have some code posted below that I use to answer some questions that I typically get. In Outlook I have a folder named NYF Questions, I have some subfolders added to this folder. How would I alter the code to extract Email from one of those subfolders.... I have now Set...

I do some sales in Europe and the address is typically supplied. There are alot of different characters in thier alphabet.not like USA. I download a csv file (do not open it and run it through my tool I created using a query in excel. I have it set to text and I know the csv file (when opened...

Can anyone recommend a way to change the color of a textbox on a userform. I am pulling some data off my excel sheet (viewable in the textbox) The conditional formating I have set on my sheet does not carry over. Is there a way to achieve this? Any insight would be appreciated, Thanks

I have a spreadsheet that I would like to add a button to copy the data displayed in text box next to it quickly in a click. My userform is alot like if you had a spreadsheet and went under data>>>Form.. It has the next and previous buttons. Is there a way to make a button on same userform...

I am trying to do accomplish something that appears to be so simple I am getting a bit confused with the formulas. I feel like I am taking the Very long route to get an answer based on formula: The situation Is for shipping. I have configured the whole United States Postal service zone chart...

I am trying to build a few queries here. This is the situation I am spliting up Invoicing into 2 parts Domestic and International. On my domestic query I typed in the criteria box "United States" Or "US Or APO/FPO. It worked perfectly. When I went to do my International Query In the criteria...

I have some code that I been using and It works fine. however I am looking for a better way to make this work. As you will see below, The code builds a URL based on values of cells. I use this to cyle through online invoices to invoice people. I have this on time delay sequence.(shortened...

Hello and thanks for looking at this post. I have a workbook in excel that has some code that i am working on in it... Basically its a series of macros that leads to the code that i put below.... In this workbook I am processing information in excel and then pushing it into Access...

I been browsing the board for a little bit trying to find out an answer for a very simple question... Does anyone happen to know..... How many fields are allowed in a table in Access? Is it unlimited or is thier a cut off point.. If so what is that cut off point.....

I am running some code from excel to print sales receipts out.... In sequence with some shipping labels... After this routine runs.. If I need to open up access ( for whatever reason) it is giving me a message saying I do not have exclusive access to the database at this time.... Is there...

I have been looking through the site for some infomation regarding something I would like to execute. I have a series of different macros Code in Excel. Each one formats a different shipping label for me. Sometimes I do not have a specific service to ship with and I would like to skip over...

Hello, Thanks for looking at this post. I managed to scrape together then change & alter, and then change much and alter even more and then execute some code. I got it to work. There is one thing I am stuck with and could use some assitance. This code is specifically for Naming regions in...

I am not sure if this is the right board for my question, But I thought I would ask anyway. I am importing text files into access. is there a way to immediately make them proper case without going through queries or code.... I see the Validation rule, I dont know how to use it properly. Any...

I have been trying to figure this out, I have 2 clean fuctions One cleans The whole sheet. and The second cleans Just once single column. How would I alter this to clean a few columns (Not all) But not one: Cleans All Cells Sub cleanup1() Dim TheCell As Range For Each TheCell In...

I have action queries that I run daily (sometimes more than once daily) right now I need to add a number to each line, for each record. First row = 1, 2nd =2 , 3rd =3.. why cant I figure this out.......... Does anyone know how I can achieve this... every time it can start with 1. I am...

I have reports that act as Invoice and sales receipts. I am trying to create a way to email them. When I experimented and tried to do so.... Every single report is attached to every single customer. How do I make it a single. So the report or Invoice goes to the correct person.

Hi and Thaks for looking at this post. I could use a little advice about a query I need to build. Just trying to get it straight in my head before I start. This query is to specifically build USPS International Shipping labels. Which I pull out of access into excel and Build an XML feed. My...

I have some code in an access module that I run from Excel. It basically gets my items ready for shipping, Printing shipping labels and sales receipts.... Due to the nature of the way I need to print out shipping Labels. I had broken down the reports By = United States <> United States for...