Recent content by garygdj

Is there a way to tie a send object to a combo box on a form? I know I can write a query to pull information from a selection in a combo box using the [form][formname]thing. What I'm trying to do is I've created a database that allows many users to enter a request in a form. then when the...

The information is very sensitive. Account numbers and such. Please understand that what I am giving you is made up information. 'con', 1234567, null, {ts 'ccyy-mm-dd 00:00:00.000'}, 123, 456, 12.00000, 123,456.78 There are 54 fileds for each account and over 300 accounts. They are all...

It's already been zipped.

We have received a zip file from a new client containing several thousand loans. The problem is that when I open the file as text all of the data is in one "field" meaning instead of going across the data goes down. loan type, loan number, origination date, loan term, lo type, etc.... Then...

Many times I deal with data in which we are purchasing loans from another company. I can't help how they store their data. If I were developing there system yes the names would be split. Infact that is what I am trying to make happen so that the data will work on our system. I find it...

I am exporting a table into a text file. I have an intrest rate that is formatted in the table as as five characters past the decimal point xx.xxxxx. However, when I export it to a text file, I loose my 3rd through 5th position. Any ideas on how I can export to text and still keep all five...

I got it figured out and it was all my fault. I hate those kind of issues.

I thought that was a link to the DNC home page.

It's not working that way for some reason. For example lets say the two dates are 02/01/2016 and 02/16/2021. A date diff should catch that. however, it's not. the fields are both formatted the same. Heres the strange part. If I go back to my table and change the day in the first date from...

Try holding down the Shift or Control key when you open the database.

Is there a way in a query to write a datediff that looks at all the possibilities month, day, year? I have 10 different fields that I need to do a date diff on. I would like to have the fields checked in one place rather than 10 day checks then 10 month checks and 10 year checks. I don't need...

Msp Mortgage Servicing Package Fidelity MSP is the servicing system that the over 50% of the mortgage companies in the US use to service mortgages.

I don't really have a choice. The data I'm dealing with is from a client and we need to manipulate the data so that we will have all the information we need in order to make the data work on MSP. The client is not on MSP so we must do this in order to make MSP work. I tried using the temp...

Is there a workaround to update a table with a computed field.

I have a Zip Code field that contains the Zip Code and the Zip Code Suffix all together. No spaces or dashes between them. I want to seperate the Suffix the last 4 characters of the zip code into a new field. I'm not sure how to get access to look at only the last 4 characters. Thanks for...