Search results

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...

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...

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...

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...

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...

I have searched through several pages of validation rule threads but came up empty on a solution to my issue. There are two controls on my form: FeeCompany FeeExpense If a fee company is selected, an expense must be entered that is > $0. I have tried various validation rules and tinkered with...

I would like a message box to appear that notifies the user that they are about to make a "cascading" change to a record. (i.e. Do you REALLY want to do this??) I have the following code on the BeforeUpdate event of the control: Private Sub PolicyNumber_BeforeUpdate(Cancel As Integer) Beep...

I am running a query that displays insurance policy premium based on the effective dates of the policies. My report specs require that I compare the year-to-date premium of last year to this year. (e.g. 1-1-03 thru 3-1-03 compared to 1-1-04 thru 3-1-04) It would be easy enough to hard code...

I have a simple data base that records insurance applications that our company receives. The data are entered through a form and stored in one table (I told you it was simple). For searches, I have another form with a combo box, pulling from the one table, from which the users may choose the...

I am creating a report which displays, by year and month, when claims were reported. I have [ReportDate] in the data and can easily split out the years and months by using the following in my query: ReportMonth: Month([ReportDate]) This works well but the end users would generally like to see...

I have a hyperlink field on my form. All of the files to which the hyperlinks point are located in a specific directory on our network. I would like the user to hit a command button (I.e. Link Report) that will open our designated directory directly, rather than have the users muddle their way...

OLE Got Me In Deep I created a small database containing an OLE field for one user. Unfortunately, the one user turned into a department and now I have a 575 record, 1.4GB database that I am afraid will imminently crash. I am in the process of manually moving the files into a directory and...

I am performing a Dcount that determins if a user will have the ability to open a specific report. This normally works fine. Howev ver, it appears that when multiple users are running the code at the same time, it will cause the DB to hang. The message, "You can't carry out the action at the...

With the exception of having to write an additional line of SQL, are there any benefits or performance issues associated with using SELECT DISTINCT vs. GROUP BY. Am I correct in my assumption that both statements will return the same results? Assuming that I don't need to perform any Max, Min...

I'm putting together a DB to record information on the insurance agencies with which our company does business. These agencies have contracts that allow them to write policies in one or all of the following lines: 1. Standard 2. Governmental 3. Specialty Workers Comp 4. Specialty Auto...

I have a table that is created by appending (daily) a flat file from our mainframe. This flat file is given to us in a specific order and this order needs to be maintained. Unfortunately, my Access table seems to want to arrange it to suit its own fancy. There is no filter applied to the...

Very Odd Request - Replace All Characters I am working with Microsoft Tech support on an issue that I would normally handle here first. Unfortunately, some brass cried loud enough and we went straight to Microsoft. As the problem appears to be stumping the tech support team, they would like a...

I am running a report from a parameter query. The query's recordset can vary from one to "n" records. Should the value of [Total] in any one of the records exceed a predetermined value, I would like a message box to appear informing the user that the report cannot be distributed until further...