Search results

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

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

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

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

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

I have a table that contains a Zip Code field. Some of the Zip Codes are missing the leading 0. Zip Codes are a 5 digit field and these codes only have four. how do I get Access to recognize the number of characters and then add the leading 0 to only the ones that have 4 numbers? Thanks

I have duplicate loan numbers in a table. I want to create a query that will assign a number so the the duplicates will have a new field called sequence. example LNNUM SEQ 999999 5 999999 4 999999 3 999999 2 999999 1 888888 3 888888 2 888888 1 777777 2 777777 1 Any suggestions?