I have been asked to make modifications in a database but I am not
very familiar with Access. This database is accessed over the network,
by many concurrent users. Working directly in the production database,
apart from being bad practice in general I suppose:), is therefore not

COMBOBOX  REFRESH  DILEMMA
' I have been working for hours trying to figure out how to requery a
combobox in a subform, from a Popup form
' that this subform had launched. Basically, I designed a form that

I have a database that one of the fields is a check box. Basically a
check means yes, no check means no. I am trying to import data from an
Excel spreadsheet. I assumed the check box would use a simple yes/no,
so I set up the Excel SS that way. It will not import the data for

Years ago when there weren't any display terminals and only typewriter
terminals, people used to draw "pictures" using alphabets and symbols. I
hope I am making sense. I need a rose designed in this way by alphabets and
symbols that can be emailed across. If anyone knows such a ...

I hope someone can help me with the following,
I have several (lookup) tables, were id's and names are stored.
All table all brought together by relationships (many to 1) in the
'master' table (by referring to the id's of the records in the lookup

Hi, I have searched the forum for answers on this and to be honest as a
novice I find it a bit confusing so apologies if it is simple.
There are some searches that I want to apply to my database.
1. To search for all records between 2 dates and display them in a report

I am using moduled to open forms. I run them from a menu that I have
created on the toolbar. The source of the forms are queries all with
record source to "lstpreinterview" on a form named eforms.
Public Function Openmyform()

I have a VB 6.0 application using Access as backend. It is being used
on a local area network. The backend database is password protected.
The problem is that the database gives me a run time error 3343
unrecognized database format. I open it in Access and repair it, which

OK, I admit it from the outset, this may seem like a really silly
question but an explanation is stumping me.
The file I have been modifying runs a query when the main form & subform
open.  Anyway, the query populates ten fields from the main table when

Is there anyway I can override a value in a calculated field on a
form? For example:
I have a form which displays the following fields based on a query:
Premium Due field has the value of 12,527.75 in it.

When using Access security can each group have only one password?
So all members of the group have the same and/or one password?
Then in order to have each member of a group have their own password
then you would need a group for each member?

I have a form in Access 2007 containing a subform. The control source
of the latter is
SELECT DISTINCTROW [Catchwords].[Catchword], [Catchwords].[Part of
speech], [Catchwords].[Explanation], [Catchwords].[Catchword ID],

How is the result of query placed in a unbound textbox ?
Suppose
 CriteriaLookups has columns TableName, KeyColumn, KeyValue,
DataColumn

i currently have a database for tracking members arrival and exit
times. however due to new demands my training centre are wanting a
barcode system setup where all the user has to do is use a wedge
scanner and not need to touch the mouse or keyboard. i can

This seems like it would be simple.  Is there a way to have an "After
Update" event from Subform1 trigger an "add new record" on Subform2?
I see posts to go from Mainform to Subform, but not subform to
subform.