I have a tabular form that populates itself via a query. The fields I am
using is Customer, Legal, Date, Margin, and Set Change. The problem I am
having is I need the Margin of RecrodSet 2 to be subtracted from the Margin
of Recordset 1 and in the Set Change of RecordSet 2 to ...

I have a field that contains text and a 4 digit number. the 4 digit number is
not always in the same position in the field. What I am trying to do is
locate the number in the field and then copy the number only to a new field.
The one problem is. The record could look like this " ...

i am trying to add psychological phrases to my dictionary but run out of room
on the add word section. is there a way to add phrases?
tnx  

I am a Boy Scout Volunteer.  I am treasurer of our Troop.  I have developed a
database to track Troop finances.  I have created two tables; 'Name Table'
and 'Bank Activity Table'.  The 'Name Table' has the Name and Status of each
Scout.  The 'Bank Activity table' has the ...

I have a report with a subreport which runs a query that requests user input.
The user enters a beginning date and an ending date.  Data is displayed
based on the dates.  When I run the subreport alone, it works beautifully.  
However, when I run the main report with subreport, ...

I am trying to query using the following expression:
TO BE APPROVED BY: IIf([TO_BE_APPROVED_BY] Is Not Null,[TO_BE_APPROVED_BY])
Or IIf(([TO_BE_APPROVED_BY] Is Null) And ([REQUEST_STATUS]="Awaiting
Approval"),"Cash Team Lead")

access 2003
my report preview is very small and cannot read the content. user has to
click the center of the report to make it large enough to read.
what's the code to make report preview large by default but not maximize to

XP SP2/ MSO 2003 Pro
I have an Access database that reads info from Excel worksheets that may get
revised over time. The Excel worksheets are all kept in folders on  a network
drive segregated by year. I have run the Access update routine both from my

Has anyone been able to get the "Adobe Acrobat Control for ActiveX" to work
in an Access 2000 Form?  I have Acrobat 5 installed and would like have a
viewer on my form, through the use of an ActiveX control that will display a
PDF document.

I receive a daily excel file that I need to get into access.  Simple
enough right?
The two problems are that the sheet will have varying columns of data
from one day to the next and column headings could be duplicated (e.g.

I'm sorry, but my English isn't very good, i'm a Dutch man. I will try to
tell you what's my problem. I hope you can understand me.
I have a problem with programming with a ListView Control in Microsoft
Access. I have an Access project. My backend is SQL-server and my frontend is

I have code that closes down forms if open.  I tried to adapt it to a
report but it doesn't seem to work:
   If IsOpen("SelfPrintNewrpt01a") Then
       DoCmd.Close acReport, "SelfPrintNewrpt01a"

I'm running into database security issues I have a fix, but I don't know if
VB has the ability.
If someone logs onto an intranet and opens an access database within that
intranet session is there vb code that will allow me to retrieve their userid

I'm trying to create a module that will take a single character code and
return the word it represents. I was using an If statement in 2 reports that
did this fine. I have to create more reports that will use this so I decided
to put the If statement in a function and then use ...

I have written an extensive access program with Windows XP and it will not
work the same on windows 98, what do I need to do to maintain all the
programming I have done?  Do I need to upgrade the win98 computer?