I have a report with a subreport on it. The subreport is meant to show
multiple child record for each master record. But it only shows the first
record.
When I open the subreport by itself it shows all the records, but when on

I'm just looking for a guy to talk too, maybe hook up with?  Anyone?
http://www.gjef.com

I have a SQL Server 2005 DB that I set up an ODBC connection to so
that people can access the data through MS Access.  There are 3
tables, each of which have a date column that is a varchar (20)
because the dates do not fall within the required range by SQL

I have a list of records in a subform that a user can either edit or
delete.  This is an unbound form.  If the user deletes a record, I
want to refresh the form, and then position the cursor on the next
record on that subform.  This seems like that this should be a fairly

I'm running a query and get the error in the subject line above.  This
is the query:
strSQL = "SELECT XL_Import.Gate, XL_Import.Region, XL_Import.Section,
XL_Import.[Charter Fields], " & _

All,
I have an Access DB.  On a nightly basis, I want to look at an Other
DB (not Access, but SQL) and:
+ Add any new records from Other.Clients into Access.Clients

I have a database form where users frequently use ctrl-F to find a
record.  Doing so brings up the Find and Replace box.
When accessing the database directly, as in my case as the developer,
the search function displays the "...item was not found" message.  The

I have a table which pertains to an assembly and the individual records of
the table pertain to the components of the assembly. I need one record to
contain information pertaining to the assembly only (Job Number,
Description, etc.). I want this information to appear in the ...

Recently I migrated a MS Access app from mdb data tables to oracle db.
It all works fine when connected locally to server but errors out in
citrix for only two screens with below error.
unable to insert into link table.

Can I get the name of a procedure from within the procedure? In my error
handler, I write the error to an error table. I'd like to write the name of
the procedure that's writing the error. But, rather than customizing each
error handler with the procedure name, it would be nice ...

Is it possible to have an Access database application read a value from a
text file kept on a web server? for example, "
http://www.somedomain.com/updates/version.txt" contains a string: "1.2".
The application would read the string and compare to the current version kept

I am going to have to start holding jpg files (about 6,000 - 10,000 a
year) in our school database. Mainly, they will end up being printed
as part of the children's profiles ie via a report. I understand that
Access 2007 can hold images without the associated bloat created by

Is there a way to have the text not be selected when you tab onto a
field? (All forms, all fields.)  
Is there a way to keep a form from advancing to the next record when
you press tab on the last field, and instead  move the cursor back to

I have a form with a clients info. There is a subform with messages
(date field and a textbox). There can be multiple messages per client.
The row height of the message text box in the subform is set to the
height of one line of text. I want it to display two. Changing the

All,
I have a Query (SQL below) I can successfully use in datasheet mode to
add records to two linked tables (TBL_People and TBL_Answers).  The
tables have a one-to-many relationship, linked by an ID with "enforce