Hi all! Not long ago I wrote an Access database to maintain inventory
operations in a tiny warehouse of a friend of mine. Now he has expressed
some interest in having a PDA (wireless with built-in scanner) to read the
barcode of an item and bring its details on the PDA screen.

I have a form with a List Box(lst_entry), upon clicking on an entry a
new form (frm_edit) should load up showing the details of the entry
selected in listbox.
In the "On Dbl Click" event I've used the following code;

I have a database that I want the fields locked only when a check box is
ticked.  I have set the On Current property of the from to
=LockBoundControls([Form],True) and this works but I would like it to only be
this way if the "Paid" check box is checked.  I have tried the IIF ...

Public Function editMemo()
  On Error Resume Next
  With Screen.ActiveControl
     .SelStart = 0

I would like to be able to create tests for students in Access of find a
template to do so. I am a novice with access.

i have a drop down list of names on a form.
the problem i have is that the users of this are typing in there own
text instead of choosing from the drop down list of names.
how can i lock this list so that they can only choose from the list

okay, I'm using Access 2003, and I'm trying to generate a calculation in a
query that will give me the totals I need.
I have a table that lists specific items by contractor, this table includes
the contract values that are sorted by cost code.

I have 3 forms.  Company, Department and employee.  The Department form is a
subform of the company, and the employee is a subform of the department form.
This allows me to easily navigate and view all employees very quickly.  
However, what i'm interested in, is to create a ...

I have a combo box that uses data from a table with the fields (setupid,
physician setup, md_PIN).  the bound column = 1.  The physicians sign on
using their name (signing_md) and PIN (signing_md_pin).  thanks to advice
from this website I have...

Using an Iif statement in a Select query, I am allocating unit costs -
dollars and cents to two decimal places - to Year fields - 2001, 2002,
etc.  When the query results are ultimately Appended to a table, the
cost is rounded to whole dollars, e.g. 5.75 ends up as 6.00.  The

Before I use this program for my business I want to know where the
information I input is being kept? What I mean is my info is on my computer
or being kept out online somewhere?
Thanks

I have an Access 2000 database. I would like to be able to make information
in this database available to different users through the web. The users
would need to enter different passwords to be able to access the info. Also
the users would need to be able to view, update and ...

Is it possible to change an object dependency?  I can view them but I cannot
find a way to change them.
I have two reports:  one for males and one for females.  Each is based on a
"male" and "female" query.  I needed to add a number of items to the reports.

I am using a sub that I pulled from a MS website to return the current users
of a database. The "JET_SCHEMA_USERROSTER" method.
I keep getting errors that state either I don't have the necessary
permissions to use the "database path here" or another error that states "The

I am using Lebans facility to print a snapshot to PDF (it works like a charm
on my computer, thanks very much to Stephen Lebans...).
But now a few of my users complain that they get the message
"Sorry...cannot find the DynaPDF.dll file"