Can I program a label with a carriage return to put the 2nd part of the
label on a new line.  The only way I can see of doing this is to convert the
label to a text box, then use chr$(13).
dixie

I'm fairly new to access, so I apologise if there is a simple solution
for this, but I have looked everywhere that I can think off to see if
this is possible and how to do it.
I have been tasked with creating a database of customers previous

For some reason this command will not trim the names shown in the
fields listed.  I'm trying to do this in a text box on a report.  I've
done this fairly succesfully in other reports but I must have done
something wrong here....

I have a table that contains contact names, their titles, and
company_IDs that are used as the Primary Key. There are multiple
contact names and titles per each company_ID. I need to have them all
listed on one row per company_id. Right now it looks like this:

Experts
I'm experimenting with ADP and MSDE and I'm trying to connect a remote
front end through the internet.
I have already enabled TCP/IP connection on port 1433 on the MSDE host

Just wondering how directly I'll be able to migrate all the stored
procedures I've created for Access ADP applications to use with a
VB.Net application instead. Does anyone have any experience with this?
lq

I developed a program in Access. Then I developed add-ins in Excel &
Power Point with common modules from Access database.
What is the solution for not having to copy+paste code from Access to
Excel & Power Point ? Can I have my code in a common file and call it

I export a recordset to excel via VB code (see code below).  My problem
is the date fields import as an integer into excel (11/14/05 becomes
38670).  How do I go about addressing this?
Public Function Export2XL(SqlQuery As String) As Long

Using Access 2003.
I am trying to delete records from one table/query
("qryHistoryPersonIDs") if they don't exist in another table
("qryDonations").  But the SQL syntax I came up with is taking forever

Does changing the Recordset Type property for a form in an Access ADP
have any effect on possible record locking?
I have a continuous form that is bound to a table but I don't want it
editable, so if I make it Snapshot instead of updateable Snapshot will

i need to do a record search in a form but there are a few twists.
1. there is no unique field to any of these records
2. the form has 9 fields, 5 of which are required for creating a record.
3. the solution has to be super easy for the end-users of this database.  i'm

hello.  i want to first say that i welcome anyone's ideas for this post.
please feel free to throw your 2 cents in.
i have a db that i'm finishing that i'm going to be giving to others to use.
the ONLY thing they're going to need to manipulate in this db are 3 forms and

The record's primary key is the report number. The form in which data
is entered or modified has this Report Number at the top. I would like
to know if I could use SQL in the VB code so that on Exit of the
'Report Number' text box, the code can scan through to see if that

I'm having a bit of a nuisance problem with my A97 application, and I
was wondering if any of you might have any ideas on how to get around
it.
The setup: I have a large main table (call it tblBenIssue) that has

I have made this msgbox to display the current Week number, but it
shows the wrong weekno.
Can anyone tell me why ?
   msg = "WeekNumber: " & DatePart("WW", Date)