|
DAO, Recordset, Edit, Updating, BeginTrans, CommitTrans
Hi Marshall Barton,
Thank you very much for your earlier reply. I tried a ranking sub query but
I can't
seem to get the ranking to disregard ranking ties, in that the requirement is
to have a ranking sequential number e.g. instead of 1, 2, 2, 4, 5 or 1, 2, 2,
3, 4 I need to show 1, 2, 3, 4, 5. (I know it's an odd way of ranking but I
work
with odd people!).
If it is possible to d...
|
3 |
11/28/2008 2:55:35 PM |
|
|
Fill in value
Hi Groupies
I am using the code for Sandra Daigle's list box transfer.
I would like to change it so that when you remove an item
from the table on the right, it does not remove it from the
underlying table. Instead, I would like a field to be filled in with
a date. I can not seem to get the code right.
Here is a snip:
<snip>
For Each varItem In Me.lstOnSite.ItemsSelected
...
|
2 |
11/28/2008 2:04:22 PM |
|
|
Checkbox Problem
Access 2003
I have a form with six paired checkboxes (for three events) A, B, and
C.
Event Start End
A --------- AS ----------- AE
B --------- BS ----------- BE
C --------- CS ----------- CE
And a Status textbox. The Status is either "Pending" or "Waiting"
When you open the form and all checkboxes are 0 the Status = "Pending"
If you check AS the Status changes t...
|
3 |
11/28/2008 5:25:01 AM |
|
|
Has something been written?
I have an unbound text box on a form. I would like to give the user the
opportunity to save the contents of the text box only when something has been
written in it. That is, my save button is not enabled until the length of the
string is greater than zero.
I tried using the key up event with:
if len([mytextbox]) > 0 then
mysavebutton.enabled = true
end if
Can't seem to get it to work...
|
2 |
11/27/2008 11:46:21 PM |
|
|
Auto Fill field - No answer yet
Hi
I'm using access 2007 and I have a form to enter the products info. the name
of the form is "frmProductInfo".
I have two fields that I want the 2nd field to be filled automatically if
the 1st field have certian value. the 2 fields are from different lookup
tables and no relation between the two tables. the tables are related with
the main table.
example:
1st field name: Pro...
|
4 |
11/27/2008 10:49:01 PM |
|
|
Object doesnt support this property...
When I click on a button I receive this msg: "Object doesnt support this
property or method"
I know the problem lies within the section of code below because I get no
error when I remove it and the error when it's there but I can't figure out
what I'm doing wrong. Also, the error only populates when another combobox
(Reportlistcs) is Null.
If IsNull(Me!Replist) Then
Reports....
|
2 |
11/27/2008 9:07:01 PM |
|
|
Listbox gridlines
In a report, is there a way to activate listbox gridlines (Access
2003)?
Thanks
H. Martins...
|
2 |
11/27/2008 5:57:44 PM |
|
|
What Control To Use
I want to show a button that the user will click and get a textbox to enter
one item. Then when he hits return, the action will take place. Is that a
Combo Control or is there some better one. Also, which event would I use
(xxxControlName_Click-Or_What) ? Also, I'm confused about when I have to
deal with the focus on events. Any help with any or all of these questions
is appr...
|
3 |
11/27/2008 5:23:01 PM |
|
|
This would be easy if I wasn't brain dead
OK - I coded a subroutine from the book that looks like this:
Option Compare Database
Option Explicit
Sub BeepWarning()
Dim xBeeps As Integer
Dim nBeeps As Integer
nBeeps = 5
For xBeeps = 1 To nBeeps
Beep
Next xBeeps
End Sub
Then I selected the event to run and got this:
Private Sub btnBeep_Click()
BeepWarning()
End Sub
When I click the ...
|
6 |
11/27/2008 4:12:09 PM |
|
|
Don't Know How
This is a tough one for a part time Access user...
But I know this is the place to get an answer if it has one.
Access 2007/ Vista/ 4 meg ram
I have a form that has a StartDate filed formatted at Date, dd-mmm.
The form also has a Combo field 'DaySet' formatted as text. The
DaySet combo field has values of:
Mon-Wed
Mon-Fri
Monday
Tue-Fri
Tue-Sat
Tuesday
etc
The table/form is used t...
|
8 |
11/27/2008 3:26:00 PM |
|
|
Auto Fill field
Hi
I'm using access 2007 and I have a form to enter the products info. the name
of the form is "frmProductInfo".
I have two fields that I want the 2nd field to be filled automatically if
the 1st field have certian value.
example:
1st field name: ProductFamily
2nd field name: ProductCat
if the 1st field value equal one of the following (value1 or value2 or
value3) then the 2nd ...
|
4 |
11/27/2008 2:45:21 PM |
|
|
Enabling Controls on a Continuous Form
Hi Guys,
I have a continuous form which I use for adding multiple tasks to an Action
Tracking database. In this form depending on what is selected from the combo
box depends on what controls are enabled or locked. However as it is a
continuous form these settings are placed against the same controls for the
next record and so on.
Is there any way in which you can have the settings only...
|
3 |
11/27/2008 1:25:14 PM |
|
|
Tinny font sizes problem
As a simple way to get a layout I pasted part of a Excel worksheet in
a Access 2003 report.The Excel layout is static, some text boxes
outside the Excel 'paste' do whatever is needed.
The past went OK except that fonts smaller than 8 do not print. Print
preview shows the small text perfectly, but it is printed just as
dots.
Directly from Excel the same layout prints OK, the same on paper...
|
1 |
11/27/2008 12:34:40 PM |
|
|
Problem running mdb file in Access 2007
I have a Access 2000 mdb file that will be shared with computers running
Access 2007.
I have been testing this file in Access 2007 in a standalone mode. Access
2007 finds and opens the file but seems to ignore all of the programming
behind the forms. I haven't a clue where to begin to diagnose the issue.
What I should be doing?
...
|
5 |
11/27/2008 2:14:52 AM |
|
|
Record Update Form
I have a form where in we update an existing record. In the Form Header I
have a drop down to search for the record. The row source is:
SELECT qryEventUpdate.Event_ID, qryEventUpdate.Agency_ID,
qryEventUpdate.Agency, qryEventUpdate.EventDate FROM qryEventUpdate ORDER BY
Agency, EventDate;
The Detail has the controls from the record that will show. The record
source for this is:
qr...
|
2 |
11/27/2008 1:33:04 AM |
|
|
Easy One - How to reference Label in report from Code
I need the caption of a Label in a report to change depending on whether or
not a combobox on a form has data typed in or no data typed in.
Help?...
|
2 |
11/27/2008 1:24:55 AM |
|
|
Referring to a Subform's ControlSource
I want to refer to a subform's ControlSource (Access 2000).
What is the code?
Thanks.
...
|
4 |
11/27/2008 12:21:25 AM |
|
|
VBA filter not working in form
I have the following code set up to filter a form, but the results are
always blank...
any suggestions on what might be going on?
lsFilter is a listbox with a simple mulit select
the values are a string
the field [Catagory] is in the data source for the form and is also a string
strDelim = """"
With Me.lstFilter
For Each varItem In .ItemsSelected
If Not I...
|
3 |
11/27/2008 12:17:21 AM |
|
|
Doubleclick on a treeview node - sometimes it works and sometimes not
Hello,
today I had a problem with my small database that is driving me nut, because
I don't see any logical reason for this behaviour:
I have a treeview in the footer of my form. It's task is to show the
dependencies between the quotations (the DB stores information about
quotations) i.e. which was the first q. of a project, how many quotations
are there for this project and so on.
Whe...
|
9 |
11/26/2008 11:19:59 PM |
|
|
syntax error (missing operator) in query expression
I have a NotInList that is not working. If I enter in something in the
text box such as SALTY'S #3 it will return the error. If I take out
the single quote it works fine. It is suppose to accept the new text
and add it to the list. Here is the code:
Private Sub Disposal_Site_NotInList(NewData As String, Response As
Integer)
Dim sqlAddState As String, UserResponse As Integer
Beep
UserResp...
|
2 |
11/26/2008 11:08:01 PM |
|
|
Loop through objects changing background color of certain kinds of objects
I think that sums it up. If someone can help me, TIA.
Just to clarify- I have several forms- and I want to run a program
that will look at each one, and on each form, if the type of object is
a Header, Form, Footer, or Label, change it's background to a given
color.
Something like For each object in objects...? The syntax excapes me
at the moment.
-BrianDP...
|
2 |
11/26/2008 10:52:49 PM |
|
|
MoveSize not working as expected
I'm trying to open a form directly over the top of another form. I'm doing
this using the following code in the forms Load event:
If IsLoaded("frm_LD_Comments") Then
Set frm = Forms("frm_ld_Comments")
DoCmd.MoveSize frm.WindowLeft, frm.WindowTop, _
frm.WindowWidth, frm.WindowHeight
Set frm = Nothing
End If
What I was e...
|
7 |
11/26/2008 10:42:50 PM |
|
|
One form in datasheet view, one form in regualr form view....
All the templates provided have the option to click on the ID number to open
up the details/form. How can I make this on my form? Please view a template
of Access 2007 if I'm not making sense.
It'd be so nice to just be able to click on a person's name in the datasheet
form view and have another more detailed form pop up.
Can someone tell me how to do this?
--
Message posted via AccessM...
|
4 |
11/26/2008 10:17:46 PM |
|
|
change font color
Is there a way to create a macro that would change the font color of a
field from one color to another - but only in that field and only in
that record?
ie I have a macro that duplicates a record.
in the new record i would like the [sellrate] field to be red font -
which would flag the user to confirm the new sell rate for the new
record. then i would create another macro that would change...
|
2 |
11/26/2008 10:17:10 PM |
|
|
phone formatting
Can someone please tell me how to format a text field that i have
combined other fields in so that the phone number has the following
format (999) 999-9999
design view =
=[First Name] & " " & [Last Name] & " PHONE:" & [PHONE] & " EXT:" &
[EXT] & " TOLL FREE:" & [TOLL FREE]
form view currently =
COLIN CHAN PHONE:4162461782 EXT:5513 TOLL FREE:
tks
Steve...
|
3 |
11/26/2008 10:07:59 PM |