Populate a combo box from another combo box
Thu, 18 Dec 2008 08:28:01 -0800
I have two combo boxes cmbApp and cbName
cmbApp RowSource is this: SELECT Application.ID, Application.Name FROM
Application;
And cbName is this:
Me.cbName.RowSource = "SELECT Deployment.[Verison] FROM Deployment INNER
JOIN (Application INNER JOIN Deployment_Application ON Application.[ID] =
Deployment_Ap ...
|
cummulative sums
Thu, 18 Dec 2008 07:52:01 -0800
I have a form where I enter a date and amounts. It is set up where several
records may have the same date but different amounts. Also, earlier dates
could be entered after later dates. I have a text field where I am deducting
a cummulative amount from a fixed amount. When I am at any given record, I
woul ...
|
create word document form a record in a form
Thu, 18 Dec 2008 04:06:01 -0800
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:
.Se ...
|
) missing.... but where
Thu, 18 Dec 2008 12:14:12 +0100
schljaar=IIf(Month(Date() Between 9 And 12 , Year(Date()) & "-" &
Year(Date())+1 , Year(Date())-1 & "-" & Year(Date()))
returns an error saying there is a ) missing...
Can anybody help?
Thanks ...
|
How the imported data will add to the exixting data
Thu, 18 Dec 2008 00:48:07 -0800
Hello,
I created a church database and the data will be combined in the higher
office.
My questions are as follow:
1.Waht should we use to combine, is it import or append data
2. If the record number is generated by the the sistem when inputting the
data in the form. Can we do import?, or it will zeopar ...
|
?F?U?b?q?Z ?U?e?e?Z?h?^?h?c?q?Z ?Y?q?f?d?m?`?^
Wed, 17 Dec 2008 17:41:18 -0800
Ç÷ÈWÈUÈYÈlÈUÈhÈr ÈbÈ^ÈcÈiÈh ÈmÈ^ÈgÈhÈdÈXÈd ÈiÈYÈdÈWÈdÈaÈrÈgÈhÈWÈ^Èu
http://sanderswynx.chat.ru
...
|
Tab to next subform
Wed, 17 Dec 2008 15:49:01 -0800
I have a form (frmAssessments) with three subforms(sfrmAssess1, sfrmAssess2,
sfrmAssess3). I want the user to enter data into the main form and then be
able to tab to the fields of each subform and enter data.
I got it to the point where they can tab to the first subform, but once you
get to the last field ...
|
|
|
Clear items selected from multiselect list box
Wed, 17 Dec 2008 13:53:01 -0800
I have a form bound to a table (dt_accounts) with an unbound listbox that I
have set up to insert multiple records into another table (dt_accountrole)
that has a many to 1 relationship to the table the form is based on. The
field Account_id is the primary key in dt_accounts and a foreign key in
dt_accountro ...
|
error 2105
Wed, 17 Dec 2008 12:55:01 -0800
Hello,
This was working fine until today.
I have a form with a subform. When I enter in the information on the form, I
have an "Add" button that moves the information to the subform. Today when I
tried to use it, it is giving me a runtime error 2105 and highlights my docmd
line. Please help me figure out wha ...
|
VBA code broke in migration from 2003 to 2007
Wed, 17 Dec 2008 11:15:02 -0800
I have some very extensive VBA code using Access forms for the UI. While
migrating from Access 2003 to Access 2007 I have encountered a problem with
the "visibility" of subform controls and their properties in my VBA code.
One of two things happens when the problem occurs:
1. The code behaves as if I have p ...
|
