Recent content by mstorer

Thank you Bob. A long day and not enough coffee can sometimes make a mountain out of a mole hill. For whatever reason, I was fearing I'd have to write a function that looped to the first character.... very inefficient with the size of the database. And I use the Val()function all the time...

Hi Everyone - I have a string field from which I need to extract a number. The field is not split into fixed length units though. For Example: 00150 002250ABC 0032500XYZ I am only interested in the numeric portion in bold. I can omit the first three numbers easily enough, but since the...

One would think that would be possible. What I have found, is that if you have a union query referenced anywhere in a set of multiple queries, the Access ODBC Driver fails to pull in the data. So, making a standard SELECT query from a union query won't trick it. :( But thanks for the...

Thanks for the response! I've been using the "make table" work around for a number of years... Due to the nature of these reports pivot table reports, which are viewed by a number of various users, I needed a way to avoid that process. In speaking with our IT folks, we'll attempt to add the...

I searched the internet and this forum for the answer to this. I did find the exact question posted in this forum way back in 2002 but there was no reponse... When updating an Excel Pivot table using an Access Union Query as it's source, I receive the message "[Microsoft][ODBC Microsoft Access...

Thank you Bob. I laughed when I saw the field names...some were more than a mouthful. Thanks again for the verification. - Matt

We're testing a product from a vendor that takes XML files and "shreds" them into a SQL Server 2000 database. I've linked an Access database to the SQL Server DB (since I find Access an easier and quicker tool to look at the 150 tables!) Of the 150 tables, only one is giving me fits. I can...

Our insurance policies use a driver rating factor which is used to determine premium. This factor is derived from driving experience, accidents , etc. of each driver listed on the policy. On policies with multiple vehicles, we take the average of the factors for each driver. For policies...

You may disregard this thread. I moved the database to a different server and now I can see my SQL. It must be a hicup on the server. Thanks for any consideration given to its solution. - Matt

I have a union query which is part of a multiple step process to retrieve our data. I need to make a change to the WHERE clause of one of the union's select statements. However, when I go into the SQL view of the query, the window is blank. Oddly, the query runs fine as is. Additionally, I...

In the caption property of the option label, place & in front of the letter you wish to use as a hotkey. For example, type: &Radio One. By doing this, the user can type alt+R to select the button rather than using the mouse. I hope this helps. - Matt

Thanks for the insight. Rich, I figured that there may be some limit. I hadn't thought of breaking out the combo boxes into parts of the alphabet. Thanks again for the suggestions. - Matt

Thanks Joe. After experimenting with some test data, the first example does seem like the way to go. Thanks again for the input. - Matt

I am laying out the specs for a new DB for our company that will track applications that our offices receive. I am at a point in the table layout that I need an outside opinion. I hope this is clear and concise: Our company has 4 branches that handle different types of insurance. 90% of our...

Is there a limit to the number of records a combo box will display? I have a combo box that displays, via a query, all of the records in a table. There are about 67,000 records in the table but the combo box won't display past about 65,500 in the drop down list. The drop down list displays...