Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
 
 
Thread Tools Rate Thread Display Modes
Prev Previous Post   Next Post Next
Old 03-05-2013, 06:22 AM   #1
Rahmonic
Newly Registered User
 
Join Date: Mar 2013
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Rahmonic is on a distinguished road
How to save data from different forms in different tablets

Hello,

Just to give you all a brief overview. I am making a Form to save Fish data. This one Form contains 4 Sub-Forms

Main Form
1). User Input (Data, Name etc.)

Sub-Forms (in tab form)
1). Conditions (for ex. Location, Objects used, Which pump etc..)
s16.postimage.org/42234m34l/Condition.png
2). Regular Fish (Name, count etc.)
s21.postimage.org/f13t21h6v/Regular.png
3). Special Fish (same as above)
s8.postimage.org/43dhv0ycl/Special.png
4). Algae
Similar thing

So now you all have some idea of what I am working on, I need help on some parts.

Conditions & Algae content saves perfectly into their tables. I guess because all fields are connected already and there are no IF statements.

But in the case of Regular Fish and Special Fish. Depending on the fish they select in that drop down menu, I want to save in those specific tables. I have tables for each fish.

This is the code I am using.

Quote:
Public Function round_whitefish1()
Quote:
CurrentDb.Execute _
"INSERT INTO RoundWhitefish (ID, Total, Finclip, Lamprey,B1,B2,B3,B4,B5,B6,B7,B8, B9,B10,B11,B12,B13,B14,B15,B16,B17,B18,B19,B20,B21 ,B22,B23,B24,B25,B26,B27, B28,B29,B30,Label,Data, Dcomments) VALUES ('" _
& Form_P1.DayID.Value & "','" & Me.txtCount1.Value & "','" & Me.chkTag1.Value & _
"','" & Me.chklamp1.Value & "','" & Me.txtB1.Value & _
"','" & Me.txtB2.Value & "','" & Me.txtB3.Value & _
"','" & Me.txtB4.Value & "','" & Me.txtB5.Value & _
"','" & Me.txtB6.Value & "','" & Me.txtB7.Value & _
"','" & Me.txtB8.Value & "','" & Me.txtB9.Value & _
"','" & Me.txtB10.Value & "','" & Me.txtB11.Value & _
"','" & Me.txtB12.Value & "','" & Me.txtB13.Value & _
"','" & Me.txtB14.Value & "','" & Me.txtB15.Value & _
"','" & Me.txtB16.Value & "','" & Me.txtB17.Value & _
"','" & Me.txtB18.Value & "','" & Me.txtB19.Value & _
"','" & Me.txtB20.Value & "','" & Me.txtB21.Value & _
"','" & Me.txtB22.Value & "','" & Me.txtB23.Value & _
"','" & Me.txtB24.Value & "','" & Me.txtB25.Value & _
"','" & Me.txtB26.Value & "','" & Me.txtB27.Value & _
"','" & Me.txtB28.Value & "','" & Me.txtB29.Value & _
"','" & Me.txtB30.Value & "','" & Me.chkLabel1.Value & _
"','" & Me.cboTest1.Value & "','" & Me.txtcomment1.Value & _
"');"
End Function
For some reason it’s just not saving the Regular and Special fish data, its saving everything else.

And lastly I want to have same ID as the main form in every sub-form. So for example when I am looking I can open specific date by specific person and all the entries shows up.

I hope I was clear enough. Thank you in advance guys, your help is much appreciated. I am not a Access savvy

Rahmonic is offline   Reply With Quote
 

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Not letting me save changes to Forms fifieldbl Forms 6 10-17-2012 11:30 AM
Access on Tablets jcruzAME General 1 01-09-2012 08:37 PM
Save Button with Sub Forms cdoyle Forms 7 10-10-2007 06:37 AM
forms cannot save the data rahultiwari Forms 4 03-03-2005 06:42 PM
[SOLVED] Prompt to Save Sub Forms topomni Forms 1 07-30-2001 07:37 AM




All times are GMT -8. The time now is 09:05 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World