Search results

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

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

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

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

I am a beginner and I am having difficulty doing the following. I have created a form from a query, (by agent) The form took a little while to design, and I know how to copy the form, but how do you change the agent that is being referenced without having to go create the whole form layout...

Could someone please help me with the following. I have a form that gets some basic information... My table looks like the following.. NewApplicationID ClientName ClientAddress ClientPhone ClientEmail later on down the road, we will be inputing other fields, is it possible to have another...

I am a beginner and want to find out if you can have a macro or vba automatically run a mail merge with a specific table as the recipients in a word document that is already created? thanks for any help Josh

Could someone please give me some help with designing a database in access. I know excel really well, and took a class on access, and have tried a few times to get started with access but always to no avail. I have a company that installs real estate signs 1. we have about 200-300 agents...