|
checkboxes in subforms
Hello All:
I have a incident table, action_taken table and incident_action_taken
table.
incident table
-------------------
iid(PK)
name
desc
action_taken table
-------------------------
aid(PK)
name
desc
incident_action_taken
-------------------------------
id(PK)
aid
iid
I have a main form and a sub form. Main form shows incident table and
subform shows incident_actio...
|
3 |
06.09.2006 15:55:01 |
|
|
Sound Clip
Hello!
I was wondering if there is a way to put a sound clip on a database to play
when the database is opened? Any help will be appreciated!!!!
Thanks!!!
...
|
3 |
06.09.2006 15:19:10 |
|
|
Compile Error: End if without block if.
I'm sure I'm forgetting something completely idiotic, but I'm (brand) new to
coding and am trying to use if...then statements to auto-fill subsequent
records after a user makes a selection from a combobox. I have created the
below code, but when I try to execute, I get an error message: "Compile
Error: End if without block if". When I check the definition, I get the
following "Identifier...
|
4 |
06.09.2006 15:11:04 |
|
|
Delete button and refresh
I have the following code in a button. I have to use a delete button because
my query that populates my form has five table with left joins and if I do a
'normal' delete record, records from all my joined tables are deleted and I
only want the record from the AllNewParts table deleted. My problem is that
if there is more than one record when the button is clicked, I need the
record to ...
|
9 |
06.09.2006 15:08:02 |
|
|
Clear Continuous Subform Fields
I have a continuous subform on my main form. I have a button on my main form
to clear the amount field only on the subform. What happens is that the user
enters amounts, but all the amounts in the subform may be incorrect, so they
would like to hit the clear button to clear out only the amount field on the
continuous subform. There is never more than 6 rows/records in the subform.
Does a...
|
4 |
06.09.2006 14:35:50 |
|
|
trying to access recordsetclone from one subform to another.
access 2000
I have a form with 2 subforms. They are on 2 different pages of a tab
control. Lets call the parent [P] and the 2 subforms [sf1] and [sf2]
I am trying resync sf2 on the on current of sf1 but I cant seem to find the
syntax to correctly set a recordset clone object. the following doesnt work.
Private Sub Form_Current() 'of sf1
Dim rst, rst1 As dao.Recordset
rst1 = ...
|
14 |
06.09.2006 13:59:03 |
|
|
Row source, should be a simply one.
I have two combo boxes in a form. The first combo box is "txtdatefrm" and the
source of the table is a query which contains a list of dates. The second
combobox is "txtdateto".
What I would like to do is create the list for the 2nd combo box only for
those dates greater than the date that has been chosen in the first box.
This is what I have.
SELECT [dateID].[WeekID] FROM date WHER...
|
6 |
06.09.2006 13:26:02 |
|
|
SendObject Change Message Font
Hi
I am using the SendObject function to send referrals when a button is
clicked. I would like to be able to change the font to Arial rather
than Times New Roman. Is there anyway to do this?
This is my code
DoCmd.SendObject acReport, stDocName, acFormatRTF, straddress, , ,
"Referral", "Please find the attached referral. If you require more
information or have trouble opening th...
|
3 |
06.09.2006 13:22:01 |
|
|
Highlighting treeview node
Hi,
I am trying to master the infamous treeview control (6.0).
I can load with data ok, and have a couple of command buttons to expand /
collapse all nodes. This is working ok. At the completion of the sub I set
MainTree.SelectedItem.EnsureVisible to make sure the current node is
displayed, which works ok. But it is not highlighted as when a node is
clicked by the mouse, so even though...
|
1 |
06.09.2006 12:31:02 |
|
|
extra text showing up in my query
I was wondering if some one would know why I have the text from my
second conditionshow in my first condition when I run a query
Time spend on Project:
IIf(DateDiff("n",[workedstart],[workedend])/60<1,DateDiff("n",[workedstart],[workedend])
&" Minutes",DateDiff("n",[workedstart],[workedend])/60) &" Hours"
When I run the query, fields meeting the first condition come out
wierd, they show t...
|
2 |
06.09.2006 11:08:41 |
|
|
CommnadBarControl
Hello!
Is it possible to create a checkbox in ComandBar ?
all what I can create is a CommandBarButton, CommandBarComboBox or a
commandBarPopup.
Thanks for any suggestion.
...
|
2 |
06.09.2006 09:03:00 |
|
|
Highlight Text If null
I have the following code in the save command button on my form. A pop
up message tells me i forgot to put address info and will take me to
address field.
If IsNull(Me.Address) Then
MsgBox "Address Required.", , "Missing Information"
Me.Address.SetFocus
Exit Sub
End If
what i want to do is highlight the text box red once user clicks
on address and puts the address the col...
|
2 |
06.09.2006 08:44:50 |
|
|
Calling a procedure in a parent form from a subform
I am trying to trigger a procedure in a parent form from a procedure in a
subform. I tried to link it to an afterupdate event for an updated textbox
in the parent form, but this didn't work. ...
|
5 |
06.09.2006 08:25:21 |
|
|
counting certain elements of a subform?
Hi,
I've got the following situation (using Access 2003):
A form containing the data of a given activity and a subform with the
data of the participants.
The participants have different attributes ('accepted', 'waiting list',
'refused').
What I now need on my form is to have the exact number of accepted
participants (based on the subform) or, if there are no accepted
participan...
|
5 |
06.09.2006 07:31:41 |
|
|
alter table in access code
How can I issue an "alter table" command in a code in Access 97 ? THanks.
...
|
3 |
06.09.2006 06:46:26 |
|
|
Loop not executing properly
The code below is part of a race timing program in Access 2000.
The loops below are designed to post an overall "place" value for all race
participants of a certain gender (in this case - female), regardless of age
categories, etc. (i.e., 1st female, 2nd female, 3rd female, etc.) The code
retrieves the race bib # from the first record in the linked query
"qryLinkTime&Bib&RaceData2Mile(F...
|
2 |
06.09.2006 04:35:18 |
|
|
Bound chart to ado recordset
I can bound forms to ado record set
I can bound bombo box to ado recordset
I can bound list box to ado recordset
I tried to folow the same logical that I used for list box but in charts
doesn't work.
Any sugestions?
PS. I'm usign adp in access 2003 vs sql server 2000
Thanks,
JC...
|
6 |
06.09.2006 03:21:26 |
|
|
Adding Beeps to a form
I'm using and If /else statement that calls a message box. The message box
works and the beep for it works. But, I'd like to add two more beeps. I
tried just putting beep in and docomd.beep; but no additional beeps sound.
I currently click in a listbox which selects and fills in several fields
(PartNumber/PO/JobNumber)
Text127 is a DLookUP to a query checking for overshipped Purchase Od...
|
5 |
06.09.2006 02:57:47 |
|
|
Working days
I have a check box that when checked brings up the present date in one field
which in turn updates another field to be 3 days on from that!
I however need this to be 3 working days and was thinking that the formula
would need to be:
Private Sub Quote_Sent_AfterUpdate()
If Me![Quote Sent] = -1 Then
Me![Contract Quote Date] = Date
Me![Chase Up Date] = dhAddWorkDaysA(3, [Contract Quote Dat...
|
3 |
06.09.2006 02:44:31 |
|
|
Changing RecordSource of a subform
Is there a way to change the RecordSource of a form that is used in a subform?
I have a subform (Total Fees subform) that uses a form (Total Fees) as its
SourceObject. How do I change the RecordSource of that form?
I tried the below but get the error: Microsoft can’t find the field ‘total
Fees’ referred toin your expression
Forms![Indvl Entries]![Total Fees subform]![Total Fee...
|
3 |
06.09.2006 02:22:01 |
|
|
Checking null field in SQL
I'm having a problem on the sql results fwith the following sql:
strSQL = "INSERT INTO tblBomMult ( Assembly, Component, CompQtyPer,
AssyQtyPer ) "
strSQL = strSQL & " SELECT dbo_BOM.Assembly, dbo_BOM.Component, " _
& "dbo_BOM.QuantityPer, BuildParts.Quantity "
strSQL = strSQL & " FROM BuildParts INNER JOIN dbo_BOM ON
BuildParts.PartNumber = dbo_BOM.Assembly
strSQL = strSQL...
|
5 |
06.09.2006 00:52:01 |
|
|
check missing fields on subform
Hi, I have a frmPurchaseOrder, with subformPurchaseOrderDetails. When User
clicks my Print button, I want to first check to see if all Purchase Order
Details (the separate Items) have a Department in the the cboDepartment field.
If it were only one record in the subform, I could check that easy enough, but
how do I check all records in the subform for ANY Null values in that field?
Per...
|
4 |
06.09.2006 00:39:05 |
|
|
flash textbox based on time
I have a textbox called delTime
it is set to say 11:00am and I want to make its textbox flash two hours
before to remind user that action is needed. I know how to make it flash
based on date, but how do I do it based on the time in the control?
...
|
4 |
05.09.2006 23:49:02 |
|
|
SQL Rowsource
This works when I use it hrough a Query, but when I use it as SQL it
doesn't work.
Thanks
DS
With Forms!CheckPreview2!ListPreview
..RowSource = "SELECT SalesDetails.SalesID, SalesDetails.LineID, " & _
"SalesDetails.ItemID,
IIf(SalesDetails.Quantity=1,"""",SalesDetails.Quantity) AS EQuantity, " & _
"IIf([Sub]=1,Items.ItemName,IIf([Sub]=2,"" "" &
Items.ItemName,IIf([Sub]=3,"" "" ...
|
3 |
05.09.2006 22:57:09 |
|
|
Excel check box values to Access Check Box values
I have been given a series of Excel worksheets that have 23 check boxes for
things like "currently outstanding", "testing required", etc. The user is
suposed to check/uncheck the box to indicate status or needs as appropriate.
I need to read these values into an Access database where the corresponding
Access Table Field is formatted as "Yes/No". In some cases the code needs to
be rever...
|
2 |
05.09.2006 22:19:02 |