UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Zipped File    
 
   
gandalf22
post Oct 8 2007, 03:18 PM
Post #1

UtterAccess Enthusiast
Posts: 81
I have an dbase (attached) that I'd like some help with.....if someone is willing to look at it.

When it opens, it opens to a small form. You enter the data, (you're free to enter any), then I'm trying to do the following.

I have a button that launches me to another form, where I've stored several registration dates. At the end of each of those records is a button. I want that button to export that record to the subform in the main
Registration form. I'm just not sure how to do it. Any help would be appreciated.

Thanks in advance....
Attached File(s)
Attached File  RegZipOne.zip ( 42.3K ) Number of downloads: 3
 
Go to the top of the page
 
+
HiTechCoach
post Oct 8 2007, 06:02 PM
Post #2

UtterAccess VIP
Posts: 18,396
From: Oklahoma City, Oklahoma
I used san Appedn query.

CODE
Private Sub Command10_Click()



Dim strSQL As String



strSQL = "INSERT INTO RegConTable ( Items, Description, [Date], Price, Comment, Button, [Key] ) "

strSQL = strSQL & " SELECT ConfTable.Items, ConfTable.Description, ConfTable.Date, ConfTable.Price, ConfTable.Comment, ConfTable.Button, " & Forms!RegForm.Key & " AS K "

strSQL = strSQL & "  FROM ConfTable WHERE (((ConfTable.Items)=""" & Me.Items & """ ));"



CurrentDb.Execute strSQL



Forms!RegForm.RegConForm.Form.Requery



End Sub



See the attached

Edited by: HiTechCoach on Mon Oct 8 19:03:52 EDT 2007.
Attached File(s)
Attached File  Registration_HTC.zip ( 25.01K ) Number of downloads: 2
 
Go to the top of the page
 
+
Jack Cowley
post Oct 8 2007, 06:10 PM
Post #3

Retired Moderator
Posts: 37,716
From: The San Francisco Bay Area
Boyd -

I am glad to know that I am not the only one with typing skills after a trip to the wine cellar...

QUOTE
I used san Appedn query.


I trust you know that I am just trying to have a bit of fun at both our expenses... (IMG:http://www.utteraccess.com/forum/style_emoticons/default/wink.gif)

Jack
Go to the top of the page
 
+
HiTechCoach
post Oct 8 2007, 06:16 PM
Post #4

UtterAccess VIP
Posts: 18,396
From: Oklahoma City, Oklahoma
I have a that new dyslexic keyboard! (IMG:http://www.utteraccess.com/forum/style_emoticons/default/sad.gif) (IMG:http://www.utteraccess.com/forum/style_emoticons/default/compute.gif)
Go to the top of the page
 
+
gandalf22
post Oct 8 2007, 07:56 PM
Post #5

UtterAccess Enthusiast
Posts: 81
Thanks so much. It worked perfectly. I really appreciate the help. I wasn't sure how to handle the subform.

The Forms!RegForm.RegConForm.Form.Requery explains it.

Thanks again.
Go to the top of the page
 
+
HiTechCoach
post Oct 8 2007, 10:59 PM
Post #6

UtterAccess VIP
Posts: 18,396
From: Oklahoma City, Oklahoma
You're welcome!

Glad we could assist.

I could not of done it with my spell checker, Jack! (IMG:http://www.utteraccess.com/forum/style_emoticons/default/sad.gif)

(IMG:http://www.utteraccess.com/forum/style_emoticons/default/uarulez2.gif)
Go to the top of the page
 
+
Jack Cowley
post Oct 9 2007, 08:22 AM
Post #7

Retired Moderator
Posts: 37,716
From: The San Francisco Bay Area
Now why can't I think of a cool answer like that? (IMG:http://www.utteraccess.com/forum/style_emoticons/default/thumbup.gif)

Jack
Go to the top of the page
 
+
« Next Oldest · Access Forms · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 21st May 2013 - 10:26 PM