|
merging and sum two text boxes
I have a report for employee production based on orders filled. For each
order we assign an employee ( each employee has its own unique number to
identify him), we put his number in a text box [EIDC], there is some orders
that we need to assign two employees and in that case we have a second text
box [EIDC2] that we assign the other employee number, in this case the order
which is based ...
|
5 |
06.09.2006 18:57:01 |
|
|
cancel export
I have been working on code that allows users to export a selected set of
data from a large database to an excel spreadsheet based on a number of
different parameters. I am using the Docmd.TransferSpreadsheet method to
accomplish the export. I have now been asked to include a cancel button
that would allow the user to cancel the export if it is taking too long. I
have searched around quite...
|
1 |
07.09.2006 17:03:35 |
|
|
Loop
Good afternoon,
I have a continuous form. How can I loop thropugh each record and perform
certain action?
Thank you,
Daniel...
|
3 |
07.09.2006 16:45:42 |
|
|
Values missing in a networked environment...
I have an application that is running on a network. One machine has the data
database in an .mdb file (as well as having a copy of the application .mdb
file). Two other machines have coies of the appl running using the runtime
version of access. I have a form that is bound to a table that has various
parameteres that I use in the appl. There are times where this form shows
some of these...
|
5 |
07.09.2006 16:42:36 |
|
|
Access Runtime - trying to figure out what is needed...
This seem to be an endless loop.
I have an office access app that needs to run on temp PC's for a tradeshow.
I am unable to find the runtime package. Any pointers?
tia,
michael...
|
8 |
07.09.2006 16:19:02 |
|
|
Who has opened this table?
Hello,
I have need to know if another user has just opened a table, before than I
access to this table.
Please write the code, if possible, or link-page.
Many thanks in advance....
|
5 |
07.09.2006 14:55:03 |
|
|
Who is connect to this form?
Hello,
I would know if another user has just opened one form, before then I open
same form.
I appreciate any ideas and, if possible, relative code.
Many thanks for help.
--
Giangi El-Dotor
free lance - Italy -...
|
5 |
07.09.2006 14:49:02 |
|
|
Exporting Microsoft Graph Object from Access
Hello there!
I have a small problem and hope you guys can help. Its really nothing big.
I am new to Access VBA programming. I made a button to export a graph
embedded as a picture in an Access form. The for this button is:
Dim graphExport As Object
Set graphExport = Me.Ctl3PPContractChart.Object
graphExport.Export "C:\Graph1.jpg", "JPEG"
Set graphExport = Nothing
Me.Ctl3PPContract...
|
1 |
07.09.2006 14:21:01 |
|
|
Method 'Execute' of object'_Connection'failed
The code below is what i'm running to export data from a table in access 2000
into Excel spreadsheets. The first part works fine, it creates the
spreadsheets, but the second part of the code is suppose to export the data
from the tables into the spreadsheets that were created. But I keep getting
the "Method 'Execute' of object'_Connection'failed" message. Can someone
please help. Thanks!...
|
1 |
07.09.2006 13:55:01 |
|
|
3146 error
I tried to open a form with an event which give an error like below:
3146 DAO.Recordset ODBC--call failed.
Can anyone please tell me what does this mean? Thanks.
...
|
2 |
07.09.2006 11:29:16 |
|
|
vb.net with Access
helloo
am using visual studio 2003 and office 2003. this is not the first time it
happens. everytime i connect a program made in visual basic to an access
database i can read from the database but i cant write to it i.e. i cant add
rows to the tables (i cant update the tables ) but if i get an access
database from the interent (any website that have those small programs to
show how does...
|
9 |
07.09.2006 08:29:34 |
|
|
Append new records
Please help me in writin recordset to append the new record to tTarge. I've
tSource where my employeess with their details present and I want to bring
the employees wich are not present in tTarget table.
Thanks to every one in advance
...
|
1 |
07.09.2006 07:45:02 |
|
|
Where do I find MS HTML Help Workshop???/
Hi guys
I have Access 2003 and want to create Help (F1) for my applications. I have
looked through a few postings and they talk about "MS HTML Help Workshop"....
I went to the Microsoft website and downloaded and installed it..
Does anybody have any good ideas on how to get a "basic text" help system up
and running quickly?
Regards
Greg...
|
4 |
07.09.2006 04:13:02 |
|
|
Explicit destruction of Objects declared - Style Thing
Hi everyone,
Is there any difference between the following two ? If so, which one is
better, and why ? Does this make any sense ? Any suggestions are appreciated.
Method I Method II
----------------------------- -------------------------------
Dim db As DAO.Database Dim db As DAO.Database
Dim rs As DAO.Recordset Dim rs As D...
|
18 |
07.09.2006 03:30:01 |
|
|
FrozenColumns
I would like to be able to set the FrozenColumns property of a form. But it's
read only.
What I'm doing is saving and restoring some of the properties of a datasheet
subform so that the column changes a user makes will be restored
automatically when the form opens. I've done this successfully with width,
font, color, hidden, etc. An MDE file using Access runtime doesn't save these
pro...
|
1 |
07.09.2006 03:23:01 |
|
|
Convert string to code
I have table that must be manipulated differently for each record. In each
record, I have a field that I have stored the manipulation necessary. For
example, one record might say "Price+Total-Shipping"(fields in the record),
while the next record might say "Price+Shipping+Taxes". What would be the
best way to loop through the records and have that manipulation done on
another field in...
|
7 |
06.09.2006 23:43:36 |
|
|
Change image path
Hello,
How can I change the path of an image when a form or report open before it
is viewed by the user?
What event would I need to use?
Thank You,
Daniel...
|
1 |
06.09.2006 22:44:01 |
|
|
How do I write data from an ACCESS table to and EXCEL worksheet?
I have developed several routines that I have used in the past to write data
into specific cells in a EXCEL spreadsheet that is linked to an ACCESS
database. I don't know what I did differently this time, but I find that the
EXCEL spreadsheet is Read Only, and I am not able to write to the
spreadsheet. I am currently using ACCESS and EXCEL 2003, and I developed the
original Softweare ...
|
4 |
06.09.2006 20:32:01 |
|
|
How to find out which Form called the procedure?
I have a form (A) with 6 buttons on it. Made a copy of that form (AB) and
disabled 2 buttons on it. One btn opens another form(C). Form (C) on load
event, copies ID, Name and PhoneNumber from origianl form. When I use Form
(AB) to open Form (C), on load event copies ID,NAme and PhoneNumber from Form
(A).
Sub Form_Load() 'Form(C)
With Forms!frmA
Me!txtID = Forms!frmA!txtID
...
|
3 |
06.09.2006 20:25:01 |
|
|
Failure of Linked table in Access...
I have an Access database with many (15-20) tables linked to tables in and
SQL Server database via an ODBC DSN. An application has been built in the
Access database with various forms and reports. When opening the most used
form, upon occasion, I receive an "ODBC--call failed" error and all
subsequent queries on the PROJ table fail. All other tables are ok. If I
open the table in ac...
|
6 |
06.09.2006 18:48:02 |
|
|
Open Exclusively Only
Is there a way to make a database automatically open exclusively?
I have an app that needs to be rewritten for a multi-user environment, but
would like to make it available now to some users and have it open in
exclusive mode when they click on the icon.
Is this possible?
Is there some other way to achieve the same thing?
--
Billy Rogers
Dallas,TX
Currently Using Office 200...
|
3 |
06.09.2006 18:20:01 |
|
|
ODBC SQL Server Driver Timeout expired (#0) only in Access not in
It seems whenever I run queries against an SQL Server 2005 database I get
an "ODBC SQL Server Driver Timeout expired" error message. However if I go
into SQL view and cut and paste the same command into SQL Server Management
Studio the command runs fine. I don't understand why there would be any
difference????
It is a big database which is properly indexed. Is there something I can
tweak...
|
5 |
06.09.2006 18:14:02 |
|
|
build string by looping through access table
I'm trying to build a string that is composed of values in an access table
field and have them concatenated and separated by commas.
Table Month
May
Jun
July
Aug
ex myString="May,Jun,July,Aug"
How do i loop through the table records and concatenate the field values?
--
Billy Rogers
Dallas,TX
Currently Using Office 2000 and Office 2...
|
3 |
06.09.2006 17:40:02 |
|
|
order of Step through option group
I got around adding a button in an option group (asked below) by putting in
30 options hidden and then they are made visible and captions added with the
following code.
For Each ctl In Me!Choice.Controls
If Not category.EOF Then
ctl.Visible = 1
Debug.Print category!CompanyName 'make sure of the
ctl.Caption = category!CompanyName
category.MoveNext
...
|
3 |
06.09.2006 17:24:01 |
|
|
How do I learn powerpoint basics in slides and presentations
...
|
2 |
06.09.2006 16:57:01 |