General

create a look up
I would like to create a look up for a field in a form. I would like to put in a customer number that will bring up their name and address info. How can I do this? Thanks in advance for your assistance. ... 30 Mar 2010 09:26

Subdatasheet records not updating totals
When I add a record in a subdatasheet the record appears in the master table, but the amounts do not "update" the master table amounts or the totals on the master table datasheet. Do I need to manually update the amounts in the master table? What am I doing wrong? Thanks! ... 13 Mar 2010 13:07

A little SQL
Could Someone Tell Me What Is Wrong With This SQL... It keeps telling me that the FROM Clause is the syntax problem... SELECT tCurtran.TID, tCurtran.EDATE1, ICurtran.EDATE1, ICurtran.appsta FROM [Curtran] JOIN ICurtran on tCurtran.TID=ICurtran.TID WHERE tCurtran.appsta in (8,9,10,11) and ICurtran.EDATE1>tCurtr... 13 Mar 2010 13:07

linked tables query
I'm really new at queries and I usually manage with the query wizard however it doesn't work with the queries I've been asked I have two tables linked by CLIENTID field. The CLIENTDETAILS tbl has CLIENTID field and the LocalAuthority field. The other table linked by the CLIENTID field is ENQUIRIES tbl and has ... 24 Mar 2010 08:53

LeeAnn
... 13 Mar 2010 13:07

Starting a database as a program
Hi, I'm making a database in Access 2007. I had made a startform to easy find all the forms. In the options of Access I have found the option to set this form as a startform so if I open the database, you will see this startform with a couple of buttons. Now I want to have this situation, but one step further.... 13 Mar 2010 13:07

Not allowing users the ability to edit a cell
Hi there In my database, I have included an age calculation as a control source. How do I set it up so that users can not make changes to this variable? Thank you in advance for your help. ... 13 Mar 2010 13:07

RichText showing <div> and other tags
Por favor, converti um banco de dados de 2002 para 2007 e alguns campos memo mostram ainda alguns caracteres como <div>, </div>, > depois que converti os campos na tabela e no formulário para RichText. Solicito a gentileza me ajudarem a criar uma macro ou uma consulta atualização para eliminar ou substituir es... 13 Mar 2010 13:07

f
... 11 Mar 2010 20:15

i love u
hi babs if u get dis email reply me ... 11 Mar 2010 16:52