A&A - In Any Place - Developing and Solutions in MS Excel and Acce
Wed, 10 Sep 2008 13:01:01 -0700
Em muitas empresas e departamentos várias soluções com diferentes softwares
foram implementados.
Algumas vezes faltam soluções que tornem as informações, disponÃveis para
vários departamentos, possibilitando que números iguais sejam analisados.
Conteúdo sintético, direcionado para atender o f ...
|
MS Access on Sharepoint - random I/O errors
Wed, 10 Sep 2008 11:16:40 -0500
A biz friend has coded up his timesheet application in MS Access 2007,
with the actual tables/files located on his remote hosted dedicated server
running Sharepoint 2007.
Everything has been running fine for months - until this week -
Now, the application gets random errors on the tables,
indicating an I/O er ...
|
Can't Find Object or Library
Wed, 10 Sep 2008 07:08:01 -0700
I have an access FE with a Microsoft SQL BE, about 60 users. Only one user
is having problems, so I'm assuming this is with her computer. Whenever she
opens a form that references data, it automatically goes into code view and
she gets a "Can't Find Object or Library" error and the highlighted code is a
ca ...
|
Use shell comand to open a file
Tue, 9 Sep 2008 13:41:02 -0700
I would like to use a shell comand to open a file using the target of a
shortcut.
I have 2 targets
Target 1
"C:\Program Files\Microsoft Office\Office12\msaccess.exe"
-CMD="SOFTWARE\JLP\JLP_PASM2009"
Target 2
C:\Program Files\Microsoft Office\Office11\msaccess.exe /profile "BLK2 -
Works" /wrkgrp "C:\ ...
|
Execute code when a form opens
Tue, 9 Sep 2008 04:52:16 -0700
Is there a way to execute a sub or function in a standards modules when a
particular named form opens without running any code from the form? ...
|
Cleaning up objects - Quick Question
Thu, 4 Sep 2008 08:32:27 -0700
When destroying Objects by using
Set DB = nothing
Will the previous statement also destroy all objects associated with a
particular Database object like Recordset, TableDef, Property etc
or should I destroy each one separately as in the following example
Set tdef = Nothing
Set rset = Nothing
Set db = ...
|
"Generic" name for "Documents"
Wed, 3 Sep 2008 10:21:29 -0700
Hi all,
I have an A2K3 application that runs under A2K3 or A2K7 (depends on user
platform). Using the Getz / Litwin VBA code, I throw up a Windows "File
Open" panel to get a folder path / file name that I need within the
application. I want that to default to the folder known as "My Documents".
Prior t ...
|
|
|
.FileExists
Wed, 3 Sep 2008 07:36:10 -0700
Three problems:
1) What is the FileSystemObject? I'm trying to check and see if an Excel
file exists and the below code keeps stopping at the "FileSystemObject".
2) I'm having trouble with my If/Then/Else statements. Is there a wrap code
you have to enter if you want to continue on the next line? (My Else
...
|
Select Case Statement
Wed, 3 Sep 2008 02:14:01 -0700
I'm trying to create a Search Form that specifies two or more criteria
through combo boxes and/or textboxes.
Some VB codes for a Search button were written as follows:
Select Case (Me.cboTypeofAgreement = "A")
If (Me.cboName = [Table1].[Name]) OR (Me.cboCompany =
[Table1].[Company]) OR (Me.txtTit ...
|
Creating a custom data type for Outlook Application in MSAccess
Tue, 2 Sep 2008 22:42:03 -0700
Hello!
I have a form which contains unbound text boxes which is (supposed to be)
used to send email from within Access(2003). I have code that handles this
form but on compiling generates a "user-defined type not defined". A check of
the VBHelp advises that I need to create a data type in a public module fo ...
|
