I would like to ensure that the JE Headers (the "one" of the one-to-many relationship) cannot be added to the table unless it has at least one JE_details (the "many" of the one-to-many relationship). The JE_details table is filled by using a subform and it is located on the form for JE Headers.
The accountants would ideally have to press a submit button that would validate the entries (both JE_Headers form and...
VBANovice
Last Activity: Mar 5 '08, 08:13 PM
Joined: May 20 '07
Location:
-
If there is a way to suppress the "Tab Key" and prevent the User from "Tabbing" thru the controls, that would be useful....
In the end, however, I want the user to fill out the controls on the form as well as the controls on the subform. Two different tables that are linked together.Leave a comment:
-
Require data entry in both form AND subform
HI!!!
I am in the process of building an Accounting Database. I have two tables. The first table is the Journal Entry Header and the second table contains the Journal Entry Details (the accounts to debit and credit as well as the debit and credits themselves). Its a basic one to many relationship.
I have both tables on a form. The Journal Entry Header is on top and the Journal Entry Details is the subform. Is there... -
Thanks! I really appreciate it!Leave a comment:
-
append table with records in recordset via vba...
Below is my code....I am simply connecting one database to another via VBA. I cannot figure out how to take the records out from the recordset and put them in a table. Me stumped...
'create connection to another database
Dim RConn As ADODB.Connectio n
Dim rRecordset As New ADODB.Recordset
Dim RString As String
RString = "Provider=Micro soft.Jet.OLEDB. 4.0;" & _
"Data Source=C:\Docum ents...
No activity results to display
Leave a comment: