Recent content by jhahes

I would really appreciate if someone could help me with the following. I have one list (3 million records) Table = DNC Field 1 - Area code Field 2 - Phone number I have another list that has say 1000 records Table = Phone list field 1 - area code field 2 - phone number What type of...

Is there anyway to automate or a piece of code to email merge with a word document. I am trying to send email updates to clients, most of the email is text with a couple of database fields in each document. I could code the html on the back side, the only problem is that I am unable to get in...

Can someone please help me, I might have my logic a little backwords. I have a table (tblLoanDetails) LoanNumberID etc. etc. etc. EscrowCompanyID then I have a table called (tblEscrowCompanies) EscrowCompanyID EscrowCompanyName EscrowCompanyAddress etc. etc. EscrowOfficerID then I have a...

I am a beginner and can someone please help me with creating indexes( I think this is what I want to do) I have a table for entering realtors the primary key is realtorID (AutoNumber) is there anyway to find if the realtor has been entered twice or prevent the realtor from being entered twice...

need more help I am a beginner in access, have lots of experience in excel. We input data into this loan software program... BorrowerName Address City State Zip Email CoBorrowerName MarriageStatus LoanAmount TitleCompany AppraisalCompany etc... The loan software allows you to generate...

i like that idea better because the loan application generates its reports to excel. if the excel data will always have the same number of fields, just more or less records, can i just import the excel sheet into the existing table or will it duplicate the records? Josh

Could someone please help me with the following problem. I have a report that downloads into excel from a loan software program. The report has lots of data for each individual loan number What I have done is link this report to access as a table. The problem I am having is how do I create...

thank you, 1 more question It worked, is there anyway to have the database window minimized at the bottom and the switchboard the active form? thanks Josh

little more detail if possible I am a novice, beginner what does NT stand for? Could you explain the steps in a little bit more detail if possible thank you for your help and patience Josh

Is there anyway to only have the switchboard screen on the screen my switchboard screen pops up over the other main screen, is there anyway to minimize my other screen so only the switchboard screen is there, I don't want the switchboard screen to be maximized if can be avoided thanks for any...

Can someone please help me with a couple of ideas in designing a status report. I am trying to design a status report for a loan applicant. The main table will have a unique key of a loan number There are about 15 steps during the process, i only need 2 pieces of information each step...

Is there anyway to do the following? 2 scenarios 1. if i have a login form is there anyway to transfer a number to a query for example right now, each agent enters their id for the query parameter, but there is no password, so any agent can enter any id and they can see the other agents...

How do i code the following I want to say if DateField in current record = "" then commandbutton1.visible=true Else commandbutton1.visible=false the button being visible would depend on the record thanks for any help Josh

2 more question thanks for the explanations.... I only have 1 table Question 1 Is there anyway to have a combobox with a drop down view when it asks what the Agents name is or does it have to be the text box? Is the response case-sensitive? Question 2 Is there anyway to put security on...

I am a beginner in access, came from excel Is it possible to send emails in access (thru Outlook)? HTML? Could someone possibly lead me in the right path. I know in Excel we could create the object(application) set the object then send thanks for any help Josh