|
unbound excel control
hi all
I want to transfer data from subform(in datasheet view ) in to excel
sheet (as unbound control).Is there any easy way to do it.
My subform is based on query and the data in subform is filtered data
using combo box in form.i.e. from combobox I select a particular
'Location' and I get data in subform for that particular Location.
Now I have excel chart embeded as unbound object frame ...
|
4 |
20.09.2006 05:46:29 |
|
|
Access doesn't like its own SQL
Here's a weird one. The code
Set qy = CurrentDb.QueryDefs(strSourceQuery)
strSQL = qy.SQL
Set qy = CurrentDb.QueryDefs("Kits Found Special")
qy.SQL = strSQL
produces error 3131: "Syntax error in FROM clause", despite the fact that
the 1st query works fine if run from the database window.
After the 2nd line, strSQL is
"SELECT [Sub Kit Comps].KitItem
FROM [S...
|
2 |
20.09.2006 09:36:29 |
|
|
Stepping through code
Hi,
I have written some code that I want to step through. From my limited
knowledge of Access there is no other way of running this code without using
a button (on click) to kick it off.
The reason I want to do this is to get the following code to run.
Private Sub LoadFile(sDir_and_Path As String)
On Error GoTo Macro1_Err
DoCmd.TransferText acImportDelim, "PO_Spec", "Tb...
|
2 |
20.09.2006 09:06:04 |
|
|
Reference library loading
I notice that Application.References. … is available in VBA. What are the
uses of this? Can this be used upon application startup to make sure certain
reference libraries are loaded for a particular application, such as "MS DAO
3.6 Object Library" for instance? If so, how do you test first for different
versions of Access that users may be running and then load the correct file
with...
|
4 |
20.09.2006 07:39:30 |
|
|
Controlling a printer from VBA
Dear All,
I have a module that carries out various end of month procedures for
me, part of this includes printing a number of reports. Because some of
the reports are external I need to print them on headed paper in a
seperate tray from the blank A4 paper. Is there a way to instruct the
printer from within my module to use the approipriate trays, for
example, the headed A4 is tray 4 (pri...
|
2 |
20.09.2006 00:32:01 |
|
|
reading db file attributes
How can you read the file attributes of an mdb file within VBA? I need to
determine if the currently open mdb is ReadOnly, and we've got Access 97,
2000, XP, and 2003.
Thanks
Vern...
|
4 |
20.09.2006 00:31:01 |
|
|
Splitting Database
On my main database called, DataEntry.mdb, I have a switchboard. On the
switchboard I have a button called, "DELETE DATA DAILY". When it is
pressed, it deletes the data from my main table called, "TEST". I also have
another button called, "UPDATE AUDIT DAILY", that has some VBA code that
transfer data from my "TEST" table in my main database to another table
called, "Audit Data", whi...
|
7 |
19.09.2006 18:06:02 |
|
|
stop code sending cancelled email
I am sending an email from the statement
DoCmd.SendObject acSendNoObject, "", acFormatTXT, strTo, , , strSubject,
strBody & strTemplate
This is great as it opens up the email for editing. But if i click the x
(close button) on the email with the intention of sending it to the drafts
folder before sending, it gives an error "The send action was cancelled" and
if i just end it goes to the ...
|
11 |
19.09.2006 17:02:01 |
|
|
video capture
Hi, I am working on an access app and need to capture still images from
a video source - eg webcam or video device connected to my computer's
video card. I am assuming I can capture this image by using video for
windows apis? I simply want a button on a form that saves the image to
disk in bmp or jpg format. Has anyone got an example of this?
Thanks in advance, Ghostrider.
...
|
1 |
19.09.2006 15:41:25 |
|
|
Copy tables & relationships
Hello to everybody,
I have a question, I have a split database (FE/BE) and from the application
(FE) I am trying to copy (duplicate) several tables and their corresponding
relationships (all contained at BE). But I have found several problems:
1. First, I tried using CopyObject, but I realized that it copied only the
link!!
2. Second, I tried also to use TransferDatabase, but it seems...
|
2 |
19.09.2006 14:49:03 |
|
|
OLE Object
I have created a table with object field. I am trying to create a form with
included the OLE Object filed i created. I can only see the icon in the
referred field instead of content. I have changed the propery to see the
content. I am still getting icon only. I am using office 2003 with service
pack 1. windows xp sp2 operating system. I also tried in diffrent pc to open
this database but...
|
1 |
19.09.2006 12:12:01 |
|
|
open word then run vba automation
I have a macro in access that exports (opens a) RTF document in Word.
Then I have to manually (mouse) enter: tools, Macro, macros, then I must
select one of two files: 1-weekend or 2-holiday, then I click run. Then the
macro (VBA) takes over adding columns, text and automatically printing.
I want to have the macro in access open the previosly described series to
run the word macro. Ho...
|
1 |
19.09.2006 11:59:01 |
|
|
Option group help?
This is a multi-part message in MIME format.
------=_NextPart_000_00A2_01C6DB6C.750DD6F0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
This is probably a pretty simple question for you smart people. Not so =
for me.
I am working on a Contact database to track psychiatric appointmets. I =
am=20
just stumped with the VB coding stuff, and ...
|
4 |
19.09.2006 11:34:01 |
|
|
Code need for automatic shut down of database.
Hi all:
I looking for some code that would automatically shut down a database
(Access 2000) at a given time, say 10:00 p.m. The reason for this code is
becuase some users of the database forget to shut it down before leaving the
office and I would like to shut it down before our back up routine runs at
night.
Any help would be greatly appreciated?
Thanks,
FatMan
...
|
4 |
19.09.2006 11:31:02 |
|
|
Create record if missing
I have a database that tracks information on a number of people. The main
table has a combined primary key using the EmployeeID and date.
I have created a form to allow users to add data to the table with two combo
boxes, the first offering a list of Employees and the second offering a list
of recent dates. This allows the user to select the employee they wish to add
data for and the date...
|
3 |
19.09.2006 11:16:45 |
|
|
Getting User Information
I have a database that logs holiday requests for the company. At present a
person will fill in a request sheet, get it signed by their supervisor then
it gets handed to HR who input the data onto the database.
I would like to have a form in Access that staff can fill in and it will
populate the main database. So that there are no errors in their Name or
employee number I have linked the...
|
2 |
19.09.2006 08:50:16 |
|
|
Comparing databases
I need to see what's changed in a database over a period of time. I have a
copy of the database (.mdb) from the morning and a copy of the database now.
How might I see which tables have changed?
Thanks very much....
|
3 |
19.09.2006 08:14:02 |
|
|
import/export specification
How can I add a column and re-order the column in an existing import/export
specification with access97? Thanks.
...
|
6 |
19.09.2006 06:53:28 |
|
|
storing path only to database
helo..i'm az...from kuala lumpur...i would like to ask a question about
access...i have doing a project based on access...i have done it
successfully but now the problem is size of the file...the limit for
access is only 2gb...but the file that i have to put in that database
is about 5gb..the type of file that i have to store is images(bitmap)
about 38000 images...before this,i store all the ...
|
2 |
19.09.2006 06:08:00 |
|
|
import/export specification
How can I add a column and re-order the column in an existing import/export
specification with access97? Thanks.
...
|
1 |
19.09.2006 03:22:28 |
|
|
You can't go to the specified record
I have a command button set, when clicked will go to a new form with
the following code
Private Sub ImageNewIncident_Click()
On Error GoTo Err_NewCAR_Click
Me.year.SetFocus
DoCmd.GoToRecord , , acNewRec
Exit_NewCAR_Click:
Exit Sub
Err_NewCAR_Click:
MsgBox Err.Description
Resume Exit_NewCAR_Click
End Sub
Now for some reason that I can't see I get the "You can...
|
2 |
18.09.2006 21:51:01 |
|
|
Error on DoCmd.RunSQL
I have the code:
Private Sub txtEmpNo_AfterUpdate()
Dim strSQL As String
Dim EmpNo As String
strSQL = "SELECT EmpNo FROM tblEmployees;"
==> DoCmd.RunSQL strSQL
If Forms!frmTimeClock!txtEmpNo = EmpNo Then
MsgBox "OK"
Else
MsgBox "Not OK!"
End If
End Sub
I'm getting error message #2342
"A RunSQL action requires an argument consisting of an...
|
3 |
18.09.2006 20:56:31 |
|
|
locking error in access 2000
Hello,
I have a strange problem. I have a import process from excel, but can't use
the built-in load as the fields are scattered all over the sheet. It was
their attempt to use Excel for something its not meant to be
Anyway. I put the entire process - there are several sheets - within a
transaction. and utilise macros to perform the update/append and auditing
queries. I have run int...
|
1 |
18.09.2006 20:28:02 |
|
|
cannot open anymore tables 3014
I receive this error while printing report, previewing it perfect...
|
1 |
18.09.2006 20:00:02 |
|
|
Setting properties on a new record
I am currently working in an access form. I have "password" protected 2
fields (Date Approved and Status) by writing the following code that requires
the password "test" be typed into the Password field:
Private Sub Password_AfterUpdate()
If Me.Password = "test" Then
Me.Date_Approved.Enabled = True
Me.Status.Enabled = True
Else
Me.Date_PMP_Approved.Enabled = False
Me.Project_Status....
|
3 |
18.09.2006 19:35:01 |