|
Expot to excel
I can use the DoCmd.TransferSpreadsheet command to get data from a query
into a spreadsheet, but how do I get certain other bits of info into a
spreadsheet?
For example, I'd like the exported spreadsheet to have a name (heading) when
opened up and viewed in Excel, a cell on the left containing the date, and a
few other single-cell values obtained from the Access form..
Thanks!
--
Bi...
|
3 |
18.08.2006 07:23:02 |
|
|
search free formated field
I have an employee name field with text data type, the employee name get
entered by all type of users so the field format is very different for
example:
John (blank) Smith
Smith, John
John (blank) / (blank) Smith
John/Smith/3669
..
...
I need to take this free format field and append it to an employee table
with the following fields:
lastName
firstName
Regrads
...
|
3 |
18.08.2006 06:10:51 |
|
|
I need to find someone in the Sarasota, Fl area to program Access
I have a computer client who is establishing an additional business of
house-sitting.
He wants to have the ability to have his staf fill out a form after an
inspection and have the form emailed to the client. The program would also
need DB integration to keep track of clients, billing, etc.
This is beyond my capabilities.
Would Access be the way to proceed, and if so, is there a lis...
|
2 |
18.08.2006 04:28:01 |
|
|
save report as separate PDFs per group
Hi Everyone
I have a report that needs to be saved as PDF. But I need to create a separe
PDF file for each group with file name that I keep in [FileName] in group
table. I think I need to loop thrugh report for each [GroupName] in group
table, save it as PDF and pick up [FileName] on a way.Can anyone help me with
the code?
thanks
Barb...
|
3 |
18.08.2006 02:28:02 |
|
|
Preview documents
Good evening,
Is there a way to display a document in a 'preview window'? I have a form
which contains reference documents (Excel, Word, PowerPoint), would it be
possible to allow the user to get a visualization of the document when the
double-click on it without actually launching the application?
Thank you,
Daniel...
|
1 |
18.08.2006 02:14:02 |
|
|
filter not working
I am applying a filter to a subform (object name = subfrmKitComps) based on a
field in the current record of another subform:
Me.Parent.subfrmKitComps.Form.Filter = "KitItem = '" & StrCurrentKit & "'"
where StrCurrentKit was obtained from the Current event of the other subform.
Unfortunately, subfrmKitComps still shows all records; it does not exclude
those records with values in ...
|
3 |
18.08.2006 02:08:02 |
|
|
"Overflow Error" - need help please.
Hi all:
I am getting an "Overflow Error" when I open a form on certain data. This
data has been appended to my database. The append query appears to work as
my data is added to the table but when the form is opened I get an "Overflow
Error" and no further explanation.
I have gotten help under the "Forms: Programming" section of this discussion
group and have tried everything suggeste...
|
7 |
18.08.2006 01:53:11 |
|
|
Could anybody tell me how to create an OLAP cube through Access VB
Could anybody tell me how to create an OLAP cube through Access VBA?
Thanks a lot!...
|
3 |
17.08.2006 21:38:02 |
|
|
Parsing out lines of text
Hello:
Suppose you have a string of text like this:
650 0 $a Authors, American
650 0 $a Frontier and pioneer life
650 0 $a Children's stories
650 1 $a Authors, American.
650 1 $a Frontier and pioneer life.
There is a crlf at the end of all lines but the last. I want to extract each
line separately. I'd love some help as I've been trying different things
with no success...
...
|
7 |
17.08.2006 20:02:48 |
|
|
Type Mismatch Error In SQL String
I've been converting my RunSQL methods to db.Execute to trap errors. I'm
generating a Type Mismatch error on the 2nd strSQL assignment statement
below. Can anyone identify where I'm erring?
Thank you.
Sprinks
Dim db As DAO.Database
Dim strSQL As String
Set db = DBEngine(0)(0)
strSQL = "INSERT INTO TSHistory ( StaffID, PeriodEnding )"
strSQL = strSQL & " SELEC...
|
2 |
17.08.2006 19:38:15 |
|
|
OutputTo & Crosstab Queries
I had a heck of a time trying to figure out why this error occurred, and now
that I have a work around solution, I have to ask: Why did this happen in the
first place?
Following is the situation: I had a simple crosstab query saved in an Access
2000 database. The SQL was fine, I could view the results with no issues.
However, if I tried to use the DoCmd.OutputTo command in my code to ex...
|
4 |
17.08.2006 18:02:49 |
|
|
Setting default path to find files
Im using some code that I picked up from a previous posting to retrieve a
file location but was wondering if there is someway to have the search
function start at a specific folder each time. The code I have now is:
strFilter = ahtAddFilterItem(strFilter, "All Files (*.jpg)","*.jpg")
I need to to go to a folder such as:
G:\DC_Public\Photos\
so that they dont have to spend alot of time buil...
|
4 |
17.08.2006 17:36:48 |
|
|
Logical Operations in a report SQL
Background:
I have a database that records responses to a survey.
Most questions have multiple responses.
The responses are True or False (with False the default) only.
More than one response can be selected True for each question.
There are 20+ questions with responses ranging from 3 to 44.
Sample Question:
Q10 What program languages do you use:
1. VB
2. C++
3. Forth
4. Assembly
5....
|
5 |
17.08.2006 17:33:02 |
|
|
Manipulate contents of Immediate window
Hi all.
I'm wondering, is there some way to manipulate ALL the contents of the
Immediate window?
I've got some code that processes a sizeable table and prints text into the
Immediate window that indicates how the execution of the code is going.
Would there be some funky way to grab ALL the text that's printed in the
Immediate window?
If i go in there after the execution is comple...
|
2 |
17.08.2006 16:29:27 |
|
|
How do I secure a record?
I want to be able to secure a record once I have completed it. Once closed
and then re-opened I want it to be read only and only able to change the data
through password control or an alert pop up or similar. I don't need to
password protect the whole database, just the individual records.
Tom...
|
3 |
17.08.2006 16:15:01 |
|
|
how to programatically remove recent files from file menu ?
Hi !
I'm able to disable almost every menu items in commandbars like so...
'disable database property from file menu
Dim cbc As CommandBarControl
Set cbc = CommandBars("Menu Bar").FindControl(ID:=2939, recursive:=True)
cbc.Enabled = False
Set cbc = Nothing
The 'recent files' has the ID:=831.
But I cannot remove or disable the recent open files in the file menu. I
know that I can 'h...
|
3 |
17.08.2006 15:22:02 |
|
|
Limited field properties?
Hi,
I have created an SQL string which is fed into a query. I then want to
change the "Format" and "DecimalPlaces" properties of the field "Downloads".
However for some reason this field doesn't contain these properties. If I
run the follwing code it shows that I only have these field properties:
### Code to check field properties ###
For count = 0 To 30
Debug.Print coun...
|
5 |
17.08.2006 13:43:02 |
|
|
Given Users Access to Color Palette - BCP
I am trying to find out if there is an ActiveX control or some other addin I
can use to give Users the ability to select a color the same way you do on
the property screen and capture their selection, the number, like the way you
can select and capture a date with the calendar control. My goal is to allow
users to customize form properties like color, test fonts, etc....
|
2 |
17.08.2006 13:24:49 |
|
|
.Export Function Crashing Database
I have report with a chart on it. I'm able to export the chart as a jpg by
placing the code below in the OnFormat event.
....
ChartSpecialtyPie.Export "c:\GraphTest.jpg", "JPEG"
Me.ChartSpecialtyPie.Action = acOLEClose
End Sub
The report opens fine and the jpg appears exactly where it should in the
file system. However, when I try to close the report, I keep getting an error
below:
...
|
1 |
17.08.2006 13:09:01 |
|
|
Avoiding repeated conditions?
Hello All
I have inherited a db with a fairly complex module that I am trying to
simplify. Essentally there are a lot (35) of reports in the db that are
generated for a given [practice]. The reports are uploaded to a website and
then sent as emails, and/or printed and posted, to the Practice. The report
is generated for a [practice] if the value of a corresponding yes/no field
(there are 3...
|
7 |
17.08.2006 12:30:51 |
|
|
Resizing columns on a subform
Hi - i am creating a contact management system as a hierarchical database and
have a company level screen and a tab with subforms below it showing all
divisions under that company and all contacts under that company. Im happy
to allow users to resize the columns on the subform if they are unable to
view all of the information but i cant get the columns to re-set to their
original size w...
|
7 |
17.08.2006 09:27:08 |
|
|
VBA question
Hi,
I am a VB developer and have been given a task to write some VBA code. I
know how to do these two through a recordset in VB but am not sure where to
go using VBA.
1.
What I want to do is open a table and return a password for the user that
has been input on a form. I have a table with all user names and passwords in
it and so I want to query the table and return the password so ...
|
4 |
17.08.2006 08:19:40 |
|
|
Browse for path (not file)
I use the comdlg32 API call for locating files, particularly back-end MDB's
in order to refresh the table links.
I now have a need to browse just for a path (not a file) and populate a text
box with the path. I can't figure out how to browse for just the path without
the file.
Here is the function declaration line at the beginning of my code (followed
by lots of lines of stuff that's...
|
9 |
17.08.2006 07:44:12 |
|
|
How to find complete subsets within sets?
This has been bending my brain for days. I want to find all the kits that
include all of the parts listed in a table called [Find items]. If I only
wanted to select kits that contain any part in [Find items], the query would
look like this:
SELECT [Sub Kit Comps].KitName, [Sub Kit Comps].Item
FROM [Sub Kit Comps]
WHERE [Sub Kit Comps].Item
IN
(SELECT [Find Items In Kits].[Part Number...
|
6 |
17.08.2006 06:51:07 |
|
|
Minimixe/Hide Access application until startup complete
Is there a way to Minimize or Hide the Access application until my custom
startup code is complete.
When access/my app opens, I still see the default tool bars & menus, even
though I have selected them now to be available on startup. They do disappear
and my custom menu replaces them, but there seem to be a transition time
period. I am sure that machine speed will affect this.
I woul...
|
5 |
17.08.2006 05:18:07 |