Search results

I've found Jon K's database/VBA codes to be very useful. However, since I switched to a new computer, I am no longer able to run his codes. To find out more about his database, please look at the thread below: http://www.access-programmers.co.uk/forums/showthread.php?p=1172983#post1172983...

I've found Jon K's database/VBA codes to be very useful. However, since I switched to a new computer, I am no longer able to run his codes. When I do run it, I would get this error message: Microsoft Visual Basic Run-Time error '-2147221164 (80040154)': Class not registered And when I hit...

Hi, I am trying to convert "HELLO123!" into "Hello123!". In MS Excel, I can use this function: Proper(HELLO123!)=Hello123! Is there a function in MS Acess 2003 to turn words into proper cases? Or is there a way I can get the desired results using a combination of functions? Also, what's the...

Hi All, I am trying to write a simple code using a string function, or perhaps using another function I am not aware of. This is what I want to do, but don't know how to write this code using correct VBA syntax. Function code (x) If x equals to one of the values in the following list...

Thanks for the useful tip. What happens if I want the zip-code to be in text? I tried going to the table design view and changing the data-type to text and setting the format as "00000" and 00000. The leading zeros are omitted when I turn the zip-code into text. If you're curious, I actually...

Hi, Let's say I have a column full of zip codes, and I want to see 5 digits. There are some entries where it only has 3 digits because the first 2 digits are zero's. So, instead of seeing "00123," I just see "123." Is there a way I can force the column to show 5 digits, so that I can see...

Thanks for the help.

How do I insert a screen shot of my computer? I've tried inserting a snippet of the Excel Workbook I am working on.

They're all in one cells.

Language English Spanish Chinese

Hi all, I have an Excel workbook, where a language column has 1 to 5 languages. For example: Language Record 1: English Chinese Spanish The 3 languages are separated by hitting the enter key, and not the space bar key. I have about 400...

I don't have production access to the database. So, I can't make change to the actual table, but can only make changes to the copy version of the table. So, I will need to run this code every week or so, since the actual table is live and gets updated everyday. So, if you can think of a more...

Thanks for the tip. I had to open the "immediate window" myself, since it didn't open automatically. The code takes a while to run, so if there is any tip on how to speed up the process, that would be greatly appreciated. Thanks again.

Thanks again. When you say "immediate window," do you mean the same window as where I copied and paste the code? If so, I typed in: ChangeToNumbers "NewKirk", "phone" And nothing happened. Also, I went to tools-->references--> and checked off on "Microsoft DAO 3.6 Object Library". I hope...

Thanks again, but I am not exactly sure if I am doing this correctly. Here's a list of steps I've taken. 1. Open a new query, with table name "NewKirk" 2. Type in "changeToNumbers(x,y)" in a new field below. 3. I ran the query... I get the prompt "enter parameter value x"... i type in "NewKirk"...

Thanks for the quick reply. I am surprised I actually understand the code since I did take an intro class to C++ in college. However, I don't know how to execute this code from the VBA window screen. I have changed the parameters in the "ChangeToNumber()" function in respect to my database...

Thanks for the help, but I should clarify the issue more. I have a list of phone numbers (over 10,000 records) in my database where the format varies quite a bit. I would like to change the format for these 10,000 records, so that they will look like "0123456789" (i.e. 10 digits, no space and...

Hi all, I have a question about changing the formats of phone numbers. In my current database, I have these type of numbers: 222-222-2222 (222)-222-2222 (222-222-2222 222-222-2222 etc. I would like to run a query to change the format of the above phone numbers to just having ten digits with...