473,320 Members | 1,802 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,320 software developers and data experts.

Subform Creation

I need a big favor from you guys. I need to create a DB for cost savings based on a year to date situation. These are the fields that I have:


Person Reporting = Text (This can be an individual table for a dropdown field.
Category = Text (same as above)
Savings Type= Text (same as above)
Title = Text or Memo ( this will be use for more description.)
Action Taken = Text
Date Savings Starts = date/time (the format needs to be MMYY)
Attachments = (to be able to put attachments for detail information)

Second Table:

Fiscal Year = Date/Time (field has to be 2 digits)
Monthly Amount = Currency
Yearly amount = currency.

I need to create a form and a subform, but I'm having trouble putting all together. I'm able to create all the tables, but I can have them talk to each other. Any help will be appreciated.
Apr 10 '09 #1
5 1287
Nobody has a clue on how to do this???? (*_*)
Apr 10 '09 #2
RuralGuy
375 Expert 256MB
Welcome to Bytes Cachita. I suspect a number of readers have ideas on how to proceed but this sounds an awful lot like a school project. We are reluctant to pitch in here unless the poster demonstrates they have put a lot of effort into the project. I doubt anyone knows what you really mean when you say
"I'm able to create all the tables, but I can have them talk to each other."
Apr 11 '09 #3
missinglinq
3,532 Expert 2GB
You also need to take the time to read the thread http://bytes.com/topic/access/answer...ing_to_a_forum, paying particular attention to the topic "Give a clear title to your question ."

Linq ;0)>
Apr 11 '09 #4
My most sincere apologies for not reading the instruction on how to post and for not following the guidelines. I will keep that in mind for future questions. I guess everybody think that their case is unique although others might have the same situation. Thanks to those that responded.
Apr 11 '09 #5
NeoPa
32,556 Expert Mod 16PB
Cachita,

That wasn't trying to put you off. That was a prompt for you to show us where you're up to on the problem, and possibly clarify exactly what you need help with.

If it is a set problem, it is better to indicate that, then we know to be more careful.

Remember, there are various wizards that will help you to get started on some of these basic setups.

PS. I changed the title for you.
Apr 13 '09 #6

Sign in to post your reply or Sign up for a free account.

Similar topics

15
by: Rey | last post by:
Howdy all. Appreciate your help with several problems I'm having: I'm trying to determine if the Visit subform (subformVisits) has a new record or been changed, i.e. dirty. The form that...
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...
25
by: Lyn | last post by:
Hi, I am working on a genealogy form. The only table (so far) lists everybody in the family, one record per person. Each record has an autonum ID. The parent form (frmMainForm) displays the...
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...
3
by: sakuragirl1 | last post by:
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...
2
by: tricard | last post by:
Good day all, I am in the process of creating a form used to enter new purchase orders. The thing is that I do not want to bind the form to a record set; instead I will use a SQL insert...
6
by: DMUM via AccessMonster.com | last post by:
Hello I am trying to pass the name of my subform to a function/sub but I can't seem to get it to work. I am using an autokey function (ctrl E) to unlock text boxes on a subform. I have a few...
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...
7
by: tnjarrett | last post by:
Hello, I have a MS Access continuous subform that was using a query as the recordsource. I changed it to use a recordset instead because when the query was used, the changes to the subform values...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....

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.