I searched the forums with no avail. I cant seem to figure out how to:
function somefunction(arg1, arg2)
If arg1 = "someText" OR "SomeOtherText" AND arg2 = 1 THEN
      Run some code

I’m trying to update the coding for a report. I am having problems with the
coding on the form. I have it broken down by certain criteria and they are
all working, but one and I can seem to figure this one out. It looking up a
number field and I am using the following syntax:

I need to Convert the code from a text field to code for a number field:
If Me.SpecificResultCode = True Then
      If stLinkCriteria <> "" Then stLinkCriteria = stLinkCriteria & " and "
      stLinkCriteria = stLinkCriteria & "[dbo_customers.QuitCode]  = " & ""

On my form (Frm:BillingWorksheetMultiples) I have 2 listboxes.  
The first listbox (list1) has as it's rowsource:
SELECT dbo_Clients.ID, dbo_Clients.Cltnum, dbo_Clients.CltEng,
dbo_Clients.CltnameFROM dbo_Clients ORDER BY dbo_Clients.Cltnum,

I have the following code created with the assistance of Steve Schapel.
When this code was written, the data type of the fields, tblLoan.LoanNo
and tblCommission.LoanNo was Number.
As I dont have to do any calculations on these fields and to solve

I have code to call a form to input data when it is not already in the table
underneath and appearing in the combo box. I have an intermittent problem of
the code runs and opens the form to input the new details but also sometimes
the default microsoft access error dialogue box ...

Using Access 2003.
I'm using the following code to invoke a the comon open dialogue box in my
form.
The user selects a file and the file path is captured in the string

I have a problem involving type library versions I hope somebody can help me
with.
I develop applications using Access 2003 running on Windows XP Professional.
The finished applications are published to a Windows 2003 Server where they

I have a list box with 10 items / columns.  I want to hide and unhide item /
column 3 based on certain conditions.
Here is what I am trying to do but I don't know the syntax:
Me.lstContacts.ColumnCount = 10

Is there a better time to use one versus the other? Are there any performence
gains in defined situations?

I am trying to build a file in access 2000.  I want to record details in the
subform so that the new entry/empty row where the data is entered is at the
top, so that the newest data is at the top instead of at the bottom of the
subform.

Have had a request from one of my clients to add OLE support to one of my
access databases.  Basically, they want to be able to relate a jpg, bmp, or
ppt file to a particular record in the database.  I've heard that OLE objects
tend to seriously bloat an MDB, which causes them to ...

Okay, I know this is VBA 101, but I've been away from it a long time and
having brainfreeze. Here is the scenario:
I have a form with a subform.  Subform is a datasheet view of a table.  I
want user to select a record in subform and click Edit button and have a new

I am using the following line of VBA to transfer an Access table to an Excel
workbook off of a command button on a form:
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel3,
"tblFacComplianceByAuditType", strInitialFileName, True

I've been trying to set up something in Access so that my church can keep
track of tithes and offerings.  What I've got set up so far is not very much
help because I can't get more than one day on the form.  I know I've done
something wrong, but I am at a loss as to how to fix it ...