I am trying to call a sub procedures based on the current textbox.  The
situation is this; my database receives input from a scale and places the
weights directly into the textbox with the focus.  The scale communicates
using MsComm's OnComm event. However, this does not run the

I have a database which produces a report fro my staff detailing their
performance.  What I wish to do is automate the sending of them so that from
one button click the following happens
It takes the first person on the list

How would you additem to an listbox for the third column?
ListBoxName.Additem "X" to Column(3)?????

I have a worksheet with +1000 records with 10 columns across.  I can
display the numbers in each cell by selecting "format cells, number,
decimal places 1".  However, the cells contain calculated values with
as many as 10 decimal places each.  How can I "truncate" or "trim" the

I’m using this code to find a record and it works OK if the record has no
single quote mark like Tiny’s bar or Mark’s place. If any record has the
quote mark I get a run time error 3077
Syntax error missing operator in expression.

i have some forms. in one form i have only one textbox and one commad button.
if i enter one form name and click the button i need to open that fom.
example.
my form names are "account", "invoice", "report" and one mainform

Operating System Windows XP Service pack 2
Using Access 2003
have the following references checked:
'   Microsoft ADO Ext. 2.8 for DDL and Security

Have fallowing probelem i have cratina longuage installed on my comp
and everything is working fine, regarding special croatina letters,
(even in access) but  i am not able touse these signs in VBA editor
which causes me problem.

I have a list of text values within a field in access and I want to
return the text that appears to the left of that it the field value
matches specific text?
eg.

This module worked last month. I had a new system board put it yesterday, and now it doesn't work. It's stopping on the red line and giving the error message: Run-time error: 429: ActiveX component can't create object.
I didn't write it and the programmer is long gone. Any help ...

I need to find the median price of a list in a table, but the table contains
the following fields:
NumberSold - The number of items sold at a price
Price - The price of the item

I have a report with 2 columns. While I could use "across then down" to
create roughly even columns, this will result in gaps between entries in a
column when there's a longer entry in the row above. Also, this causes
sorting to snake, rather than flow vertically.

I was wondering if i am the only one out there. (i found one posting on
this:
http://groups.google.com/group/microsoft.public.access ...

I'm trying to find a way to show the results of several queries in a form and
then a report.  (I have a "laundry list" of "results" that I need to produce
and want to put as many together as possible.  Because of the number of joins
involved and the amount of time it would take ...

First of all, this function has worked for years... After returning from
vacation, I find that this function which is used to determine a person's age
at the time they visit our hospital, doesn't work anymore. I have racked my
brain trying to find an answer to why this has stopped ...