Is there a way to concatenate 1 field which has different data in it in
2 different records into 1 for a report?   (see explanation & report
below)
I've set up a database to track medical insurance coverage and charges

Hi all,
   This is probably really simple but the answer has eluded me so far. I have a frontend application which when closed on PC's at work,  just closes. However, when I close it (an exact copy) on my home PC, the forms & database window close but then prompt for the ...

Greetings all,
   Despite the inefficiency, I am content to cut and paste 20Kb JPEG images
into a OLEBound field in my inventory DB (because I don't want subsequent
users to have the hassle of loading and linking to other applications -

I have the following problem. I know how to create a mail in VB with a
subject and people to send, but is it possible to create an Outlook
appointment in VB, if it is possible, please be so kind and give me some
example?

Friends,
I have a form named Welcome on which there are various pages. On one
page, simply named PAGE1, I have added a list box named LSTINITIALS,
which stores the initials of my database users. This list box is also

Hi all,
   This query is not too specific, I was just curious. An application at work retrieves data from SQL server. One SQL that is used runs 3 at the same time and returns the results together in notepad. Each SQL has it's own header with the results underneath. I have looked ...

I need to create some operational HTML pages (for data capture), which will create data on
a database on a server. I will then download the entered data and use it in a system
locally. These are time sheets that will be filled in by a traveling band of consultants!
My problem is ...

I am writing a query that should prompt a user for the name or the ID
of an application.  I put the same prompt text in the criteria column
of the Application ID and the "or" column of the Name column.
The SQL view shows the following text:

I'm am creating a CSV text import file for another application from my
Access database.  The other application requires a leading and following
space surrounding a hyphen in the field name in order to import correctly.
Without the spaces, the import application crashes.  I have no ...

I'd appreciate any help which is offered to my problem. I'm using
Acess 97.
I have a flat text file which lists names and addresses. Sometimes,
these can be 4 lines and sometimes 5 lines, with a blank line

I'm trying to import a textfile into an Access table. I want
to write a macro to do all the work automatically.
My textfile looks like that:
artNr;description;sellingValue

Thank you for your help in advance!
I am having a serious difficulty with a database conversion utility
that I have created using Director and Datagrip to help support a
database application that we already have in the field.

Anyone have any tips on how to "convert" queries created in the Query
By Design to SQL for VBA in Access? I particularly have difficulties
with all of the quotation marks involved with parameters when
converting QBD queries (SQL) to VBA sql.

Hi.  Thanks in advance for your help.
I have a database in which one report will not show the text from a memo
field.  If I run the underlying query, the field shows up in the table,
with all fields complete.  However, when I create a report and either print

I messed with Windows XP SP2 and for a while did not get the installation
quite right. It looked for some file (I think a remnant of a Trojan file that
was left on Windows/System32 after Norton had zapped the Trojan) right near
the end of the installation, couldn't find it, ...