473,396 Members | 2,061 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

Subform not allowing creation of new record

I am working on my second Access project and have run into an issue I
cannot get around nor find info on.

I have a form, with a subform in datasheet view. Within the subform I
have a hyperlink field that is populated when the checkbox field is
clicked. There are no other fields. Once the hyperlink field is filled,
the form does not add a new record for more input. I believe this is
because all the input is done behind the scenes per se, but i cannot
figure out how to fix! Any suggestions are welcome.
Thank you!

Nov 13 '05 #1
3 1343
It sounds like you need to link the forms.

Nov 13 '05 #2
Thank you for your response. The forms are currently linked. if i have
2 textboxes on the subform the subform works correctly. it is only when
i have a checkbox and a hyperlink field that it no longer creates a new
record. Any other suggestions?

Nov 13 '05 #3
i think i need to clarify a bit more on this; the hyperlink field data
is programically input. I think this is the reason it does not give me
an option to add more, because i am not typing directly into the field.

Private Sub Command18_Click()
On Error GoTo Err_Command18_Click

Dim lngFlags As Long
Dim strfilter As String
Dim strPathAndFile As String
Me.AllowAdditions = True
Me.AllowDeletions = False
strfilter = ahtAddFilterItem(strfilter, "Word Documents (*.doc)",
"*.DOC")
strfilter = ahtAddFilterItem(strfilter, "Excel Documents (*.xls)",
"*.XLS")
strfilter = ahtAddFilterItem(strfilter, "All Files (*.*)", "*.*")
strPathAndFile =
ahtCommonFileOpenSave(InitialDir:="\\department\sh are\", _
Filter:=strfilter, FilterIndex:=3, Flags:=lngFlags, _
DialogTitle:="Choose a File")
If Len(strPathAndFile) > 0 Then
'MsgBox "You selected: " & strPathAndFile
[Form_Gains Chart]!AttachmentLink.Value = Right(strPathAndFile,
Len(strPathAndFile) - InStrRev(strPathAndFile, "\")) & "#" &
strPathAndFile & "#"
Else
MsgBox "You didn't select a file"
End If

Exit_Command18_Click:
Exit Sub
Err_Command18_Click:
MsgBox "Error " & Err.Number & " : " & Err.Description & " in
Command18_Click", vbExclamation, "Model Scoring Form 4"
Resume Exit_Command18_Click
DoCmd.Save
End Sub

Nov 13 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: Jon McLean | last post by:
I fear that my question may be elementary, but what I am trying just is not working. I have two tables: tblContacts (Essentially a mailing list. Each contact has an Autonumber ID.)...
5
by: Mary Litten | last post by:
Hi - (This is my very first post) I have gotten to this point of registering to post because I have been spinning my wheels so long, I believe I am all caught up in the weeds. (and mud) I have...
4
by: Dave Boyd | last post by:
Hi, I have two very similar forms each with a subform. The main form gets a few fields from the user and passes this back to a query that the subform is bound to. The requery is done when the...
1
by: Damon Grieves | last post by:
I've disallowed additions and deletions from a subform to prevent user 'accidents' but there is a need to delete a certain type of record occasionally which I've flagged. Is there a preferred or...
6
by: MLH | last post by:
When the vehicle entry form (frmVehicleEntryForm) first opens, the additional owner SubForm control (frmAddnlOwnrListSubForm) is enabled. You can click on it and it will accept the focus. But after...
1
by: planetthoughtful | last post by:
Hi All, I have a mainform with a subform in which I show some task summary data. On the mainform I have a number of unbound controls that reflect values relevant to each task in the subform....
7
by: robtyketto | last post by:
Greetings, I have a main form. Upon filling in a combo box it then displays a subform (based on a query that uses values in the combo box on where clause) THe subform has the paramater Data...
3
by: pzh20 | last post by:
I have an unbound form/subform where I populate a combo box on the main form, and using the onchange event, display fields from a table in a datasheet subform. I want to add a new record via the...
1
by: troy_lee | last post by:
I have a table (Table A). It has one field, a PK. It is in a 1:M with another table (Table B). I am having trouble with a form/subform setup to view the 1:M records. On the parent form, there is...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.