Is there any function in Access can convert Upper case or Lower case words to
Proper case?

Hi

I'm collecting and updating information on customers in an Access 2007
database continiously via Excel. For this purpose I first import the data
from Access to Excel sheet "Input" via Access oledb link. This works fine.

When I get back the files I use the transferspreadsheet command. So far I
have had a separate sheet "Output" where I have all the data linked with a
formula. Again this has worked fine. I would like to get rid of this and keep
the data on the "Input" sheet only and let the people to make changes in that
sheet.

I've tested that Excel recognizes a range called: "Table_database.accdb"
where 'database' is the name of my database and the range covers exactly the
fields in the Excel import from Access. In addition, I manually imported the
file into access and the wizard automatically proposed a Range called
"database#accdb". So it seems that Access can identify the correct range
name. However, when I try to use any of the above as a 'Range' on
transferspreadhsheet command, it fails.

If I change the imported table to a range in Excel and name it as "Range",
the transferspreadhseet again recognizes the correct range. I dont want to do
this as I woudl prefer to use the same file over and over again.

Getting ready to package my access database for distribution. Using MS
deployment solution included with Access 2007. I need to include a
self-extractor file. I added as per instructions, but it won't run when I run
the install disk. Any help would be appreciated. Thanks

Now that we've chased, killed, skinned and sold the rabbit on EBAY...

Here are the assorted subs..

[External Module]
Option Compare Database
Option Explicit

'Provide a global array to store the OpenArgs parameter names & values for
easy retrieval
Global aOpenParameters()

Sub openRptLoadListDetail(Optional strView As String, Optional
strWhereStatement As String, Optional strReportTitle As String, Optional
strLoadListInformation As String)

'Encapsulate opening the report so that OpenArgs string is built as needed
and passed in, this way, we don't have to remember what the parameter names
are as we code AND we centralize all code that opens the report.

Dim strOpenArgs As String

If Len(strReportTitle) > 0 Then strOpenArgs = strOpenArgs &
"mReportTitle=" & strReportTitle

If Len(strReportTitle) > 0 And Len(strLoadListInformation) > 0 Then
strOpenArgs = strOpenArgs & ";"

How would I detect if a specific app is installed on a machine? Specifically
Snotshot Viewer.

I'd like to change the default location of the lock file that is generated
when a .mdb is opened. Usually, it is put in the same location as the .mdb.
Does anyone know how to specify the location?

Hi, I have a table that collects file names via VBA . (p:\Drawing001)

When the table generates if I set the orginal property to text and then
change it to hyperlink (manually) it will automatcally open the file. I would
like to change the property using VBA so that I don't have to go into the
table to change it.

I tried setting the property to hyperlink to begin with, but that does not
seem to work...

any suggestions?

Using Win XP with Office 2007;

I searched this forum for an answer to this, but I didn't find anything;

Could someone please post an example VBA sub or function that makes the
Quick Access Toolbar (QAT) unavailable to users?

Thanks much in advance.

Hello,

First, thanks for reading my question.

I am trying to allow users to browse out to find a file and then, when
selected, enter the full file path to that selected file. The code I have
right now is ALMOST right, but only gives the file name with extension.

Any help would be excellent! Thanks.

Current Code:

Private Sub Getfile_Click()
Dim retFile As String, dlg As Variant, s As String
Set dlg = Application.FileDialog(msoFileDialogFilePicker)
With dlg
.InitialFileName = CodeProject.Path
If .Show = -1 Then s = .SelectedItems(1)
End With
If s <> "" Then
retFile = Right(s, Len(s) - InStrRev(s, "\"))
CurrentRoundupFile.Value = retFile
End If
End Sub

There has to be a way to easily create a table with calendar days? I just
need a table with dates, nothing fancy.