Within my db I have a table containing BusinesstypeID and BusinessName.
I have created a form with a combobox wherein I can select the BusinessName
and the BusinessID is the result. (checked it with a msgbox).
Now within the form I have created a listbox in which I want to display ...

Hi,
I'm using MS Access 2003.
My work colleague created a stored procedure from a SQL Database. Let's say
it's called "EpisodeData". She said it accepts two parameters: a string and a

I'm trying to convert(format) this sql from my query to a form I can use in
vba(or vb) and escape the DoCmd.OpenQuery "qryQuery" trap.
My query sql view:
INSERT INTO tblMessQ ( RecipID, ConCode, Message, [Date], [Ack/success] )

i'M NEW TO ACCESS AND AM HAVEING PROBLEMS APPENDING DATA FROM ONE TABLE TO
ANOTHER.
I have a table called ALL with the following fields:
LES

I have a text box where I want to change the backcolor depending on the name
in the text box. For example, if the text box reads "red", then the backcolor
should turn red.
I came up with this, but it doesn't seem to work. Can anyone help? Thanks.

I have the follwoing code: and I would like the month that is passed by the
input box be used in the second function as creteria.
Public Sub Which_Month()
   Dim qdfCurr As DAO.QueryDef

I wish to use a combobox as a record selector in an Access 2003 asset
tracking database. The problem is, the database is in 3NF, so eight of the
assets table fields hold only longint FKs, including those fields of most
value in selecting an asset record (e.g. current owner, asset ...

I'm looking for a method of prompting a user to enter a
value and using that value in a simple calculation.  For
example, an inputbox would ask for an integer and subtract
that number from an existing value in another control.  

I've followed 2 books exactly, as far as I can tell, but "it" doesn't work.
I have in a Standard Module [modBusinessLogic]:
_____________________________
' General Error Handler to be called from most procedures

I have read several ways to do this,
1. Create a comma delimited string of Itemselected values, presumably to use
in an "In" function in a SQL statement.
2. Same as above but using an " OR =" to append values in a string

i need to import external dbf tables into an access database in CODE. i can
do it easily by hand by going to File/Get External Data/Import.
but i need to automate it. how can i do it in vba or as an access
application within visual basic.

i need to import external dbf tables into an access database in CODE. i can
do it easily by hand by going to File/Get External Data/Import.
but i need to automate it. how can i do it in vba or as an access
application within visual basic.

I lose all of the contents of global variables (variables declared as Public
in code modules) when the VBA-generated form I have created opens.
I needed a form in my Access application that was populated with labels and
checkboxes based on the contents of columns from two separate ...

MS Access 2003
Is it possible to create a text box in a form with VBA code?  If so, then how?
If not, does anyone have a suggestion about coding to create forms from
user’s input on-the-fly?

I am using Access 2000.  I’m using VBA code in a module.  Is there an
equivelant to 'string2 =  Right(Space(4) & [rst1]![orgn], 4)’ that would fill
with zeros instead of spaces?  Thank you for your help.