|
Continuation of an unsolved issue
I currently have a database that adds all service time an employee
works in each job classification. I need to modify the database to also
include any service time an employee may work in a job title that is above
his/her current job title in the line of progression (LOP). For example:
Joe Brown is currently working as a Winder Technician (LOP = 1.1.04) where
he has 52 weeks se...
|
4 |
12/22/2008 6:19:01 PM |
|
|
Change and refresh OLEObject showing Excel chart.
Hi All
I am trying to change the Excel workbook that my OLEObject on a form
displays:
Private Sub Form_Load()
With Me.oleExcelChart
' SourceDoc is currently "W:\Public\83.xls"
Debug.Print .SourceDoc
.SourceDoc = "W:\Public\XX.xls"
Debug.Print .SourceDoc
' ## how can I get the OLEobject to repaint/redisplay/change?!
End With
End Sub
...
|
1 |
12/22/2008 11:18:58 AM |
|
|
Auto Dial DSL Code
How can I have the auto dial function use my internet broadband connection
instead of the modem to place a call from within access. It works fine with a
modem but I would prefer it use my DSL connection since I am never connected
to the modem
...
|
3 |
12/21/2008 10:50:59 PM |
|
|
Modification to current code
I have a database that automatically calculates an employee’s service time in
each Job Classification that he/she works in. I have used the following
expression in the control source property of the form:
=DSum("[WeeksService]","Service Record Query","[EmployeeID] = " &
[EmployeeID] & " And [JobTitleName] = Current_Job_Title_Name")
All works well, but now I must modify or make an a...
|
6 |
12/21/2008 8:24:05 PM |
|
|
Multiple Sub form Problem
I have a main form with two subforms. Main form: parts first subform:
items quoted (form in continuous view).
I would like to click in row in first subform (quoted item) and have a
second subform (current prices) appear in main form.
My ultimate goal is then to click a new price box in second subform
and have it update the item in the first subform.
TIA...
|
3 |
12/21/2008 8:19:01 PM |
|
|
Trying to get fancy
So, my users are asking to run their reports, integrity check query displays,
etc. by selection criteria. Say, for example, they want to run an integrity
check query that selects 1 or more "ProjectStatus" values. I've been
interposing a form that presents the project status choices in a list box and
lets them choose. Then I execute the form or report out of that form.
But query display...
|
9 |
12/21/2008 8:15:03 PM |
|
|
error checking
I have a form that enters data into a table(table1). I would like to add
some code to a button that would append that data to another table(table2).
I know how to create a append table, but I would like some assurance that
when I append that all the data would not be lost. Is there some error code
I can use that would assure me of this? What is the best approach?...
|
4 |
12/21/2008 5:27:55 AM |
|
|
HYPERLINK SECURITY WARNING
I'm not sure if this is the right area to ask this question so here it is.
I have a field in a form that is designated as hyperlink. This hyperlink
goes to a sub directory. The system is not networked or anything. It's a
standalone.
The problem is when you click on the link I now get a message:
Hyperlink can be harmful to your computer and data. To protect your
computer, click o...
|
2 |
12/21/2008 2:06:52 AM |
|
|
Cannot set value via event
Happy Holidays and thanks for helping.
I have a main form that has a control to record last update to it or another
form/subform.
[frmClient]-user clicks button to display [frmClientUpdate].
[frmClientUpdate]-popup, not subform.
[frmClientUpdate]![subforms] - contain controls,bound, to update data. There
are several, behavior is common to all.
I am unable due to the error 2448 to up...
|
14 |
12/20/2008 7:05:00 PM |
|
|
ListBox.Column(n)
Hi,
Me.lstbxListBox.Column(6)
Is there a way to replace the column index by the column field name?
Thanks
H. Martins...
|
4 |
12/20/2008 3:12:21 PM |
|
|
Mask the message NOTINLIST
Dear All,
I've used a combo box to search a value from a list, and when the value is
not in the list, I want to show my own message and mask the access msg which
says THE VALUE YOU ENTER IN NOT IN THE LIST.How is it possible? and how can I
clean the combo box after such a condition?
Thank you all in advance....
|
2 |
12/20/2008 8:12:01 AM |
|
|
Using an unbound combobox to filter another combobox
I am using Access 97. I have a form with the record source of tblDocReview.
In the form I have two combo boxes: cboStdyExt and cboStdyNo. StdyExt is a
field from tblStudyDescription and StdyNo is a field created from
qryStudyNumber combining multiple fields from tblStudyDescription. The
following is a summery of the tables/query and their fields.
tblDocReview (contains many more fie...
|
2 |
12/20/2008 3:54:20 AM |
|
|
Why my query opens after running my code?
I have a form that I use to send email using CDO method. The form has a list
box with the multi select property is set to Extended. the code loops through
the selections made in the list box then send the email. everything goes well
except that the row source of the list box opens in the data sheet view after
running the code. I have nothing in the code that tells it to open. The
followi...
|
3 |
12/20/2008 2:56:01 AM |
|
|
Query problem - used in form
Hello there, I am having trouble getting correct output from the query
listed below and I would really appreciate help.
'Sample - RecyHistory Table Data:
DateRec PalletCount
12/1/08 2
12/1/08 3
12/8/08 5
12/15/08 2
12/15/08 6
'Query to get average number of pallets received for each day of the week -
in...
|
2 |
12/19/2008 11:42:39 PM |
|
|
Lebans AlternateColorDetailSection does not work on all pcs
The AlternateColorDetailSection at
http://www.lebans.com/alternatecolordetailsection.htm
is pretty neat on most pcs. But on a windows 2003 terminal server box it
does not seem to render the alternate backcolor, no matter what color I
set it to. The color depth is very good via RD on that box, so it's not
that the color can't be rendered....
|
5 |
12/19/2008 10:32:39 PM |
|
|
create word document form a record in a form
Hi see below
Dim AppWord As New Word.Application
AppWord.Documents.Add "\\server\db_files\Templates\~BQPO.dot"
With AppWord
..ActiveDocument.ShowSpellingErrors = False
..Selection.GoTo wdGoToBookmark, Name:="bmkDesc"
If IsNull(Me!subformPurchaseDetail!Description) Then
..Selection.TypeText ""
Else:
..Selection.TypeText Me!subformPurchaseDetail!Description
End If
AppWord.Visible ...
|
3 |
12/21/2008 6:13:32 AM |
|
|
Combining Data from Different Records into a Single String Variable
I want to extract the text of a single field (a mailing address) from a
series of records in a query, where the record matches certain criteria, to
make a single string variable.
This is to insert into Word as a list of addresses.
In plain English, I want to pull the address fields from selected records in
a query where the record match certain criteria.
I have never combined the da...
|
2 |
12/21/2008 8:32:34 AM |
|
|
My Recordset cant DELETE for rd.delete
Help, help..
I had a form that open up like this:
rd.Open table, conn, adOpenDynamic, adLockBatchOptimistic
rd.filter = "Name='" & name_text & "'"
Do Until rd.EOF
if(rd!Name = Name_Text)then
rd.delete
rd.Delete adAffectCurrent
rd.close
conn.close
set rd = nothing
set conn = nothing ...
|
5 |
12/21/2008 12:23:14 PM |
|
|
Difference beetween two tables with the same structure
Hi,
i got two tables, same structure table "028 - des" and table "028 -
prg".The table "028 - prg" is in my databese application but the "028
- des" is the newest.I can't replace table "028 - prg" with "028 -
des" 'cause in any case i need to modify other stuff.i have to find
difference beetwen the tables.
There are in the two tables the same names of the fields an structure
and you can...
|
2 |
12/21/2008 12:31:18 PM |
|
|
Code doesn't open my form?
I have a search form that is in continuos forms format. I select a record and
click on a command button to open another form showing the data that I've
picked.At least that's what should happen. However when I click on the button
I get a message that says " You cancelled the previous transaction" Can
anyone help me with this code?
Private Sub cmdopenrecord_Click()
On Error GoTo Err_cm...
|
3 |
12/21/2008 4:06:01 PM |
|
|
HYPERLINK
I've setup a field in one of my tables as a hyperlink and placed the field in
the form.
We are currently scanning documents to PDF file and then we attach those
files to lets say a client. However in order to do this we have to go to the
insert option on the menu bar and then select hyperlink. Then this takes us
to the database directory and from there we choice the directory that the...
|
9 |
12/21/2008 6:43:01 PM |
|
|
Combo lookup on subform
I would like to build a combo box that looks up records based on the subform.
The subform is in datasheet view so the combo must reside on the main form,
is there a way to do this?
--
Jacqueline...
|
3 |
12/21/2008 10:52:00 PM |
|
|
Using a Label to Sort
I have the following code for my label to sort:
Private Sub txtLabel124_Click()
If Me.OrderBy = "[LastNameFirstName]" Then
Me.OrderBy = "[LastNameFirstName] DESC"
Else
Me.OrderBy = "[LastNameFirstName]"
End If
End Sub
The code works just fine, but here is my problem:
The Form which contains this code is based on a Query which requires certain
criteria (Parameter Query). W...
|
7 |
12/22/2008 2:41:14 AM |
|
|
Excel won't close when opened from Access
I have a file that needs to be regularly reloaded into the database. Each
time it comes to us from the department that outputs it, there are extra rows
containing "non data" elements before the actual header row and data. I
can't have the creating dept remove those lines because the same file goes to
other people who need those rows. It was simple enough to create a macro to
clear them...
|
7 |
12/22/2008 2:08:02 PM |
|
|
stop window changes
I have a macro that open and closes multiple forms etc while it is
running.
Is there a way to block all the screens from 'flashing' on / off
without preventing the macro from doing it's job? this flashing on/off
causes the users concern and would be best if blocked somehow.
any suggestions are greatly appreciated.
Tks
Steve...
|
4 |
12/22/2008 3:39:01 PM |