Need HELP: Forms for Data Entry or for Adding Information

davies107

davies107

Registered User.
Local time
Yesterday, 21:13
Joined
Oct 2, 2012
Messages
143
Hello everyone,

i need help here, sniff sniff.

i am creating a database about hundreds of equipment and materials. to cut the story short, i need to create a form that will add information (fields are: size, price, description, vendor name, etc.) or specification of each equipment and materials to the database. users will not go to the tables or open the tables to add data but will input information into the form that will add to the database table.

how can i do this? if there are samples to download, i would appreaciate if you can direct me to it.

thanks a lot! :)

best regards,
davies
 
You might find something in the Samples section.

But in essence all you need to do is to bind your form to the underlying tables. You might do this directly or through the auspices of a query.

You might also get some inspiration for the table structure from one of the data models available here.
 
thanks John Big Booty. will try to check the resources you have given.

i was following your replies here and i even got one of your samples - Dynamically search multiple fields ... but i have a slight problem about it, it will only search for 1 column, right? how about 2-3 columns like countryname plus winery plus grape?
 
The sample will search multiple fields using a single dynamic search term, combined with various filters from the option groups.
 
yes i got it but is it possible not to focus on single dynamic search only?

sorry but i am new to MS-Access, i am still struggling here. been reading lots of resources for the project that i am into.
 
i will set an example:

search keywords: Australia Angove's

if i will search for Australia (Countryname column) PLUS Angove's (Winery column) in the database it wont appear. its possible that users will search for specific Winery's name in Australia. for small database like your sample, two keywords isnt important since you can see it right away what youre looking for but for a bigger database, if you dont want to scroll down and look for Australia Angove's you need to have a search function that accept or search 2-3 keywords or multiple keywords not a single dynamic search only.

i hope im clear... im not good in explaining, sigh... =(
 
Last edited:
by the way, i found the solution already but i did it manually.

i added a column in a table that includes ALL information but i hide it in the database so no one can see it. so if someone will search for single keyword item will appear if they will search for multiple keywords it will also appear. hehe...

my next problem is about adding an item/s in a form not on a table in the navigation pane. will do a lot of research to get this. =)
 
There are any number of modifications that could be done to the Sample to achieve that goal.

By disassembling the sample and understanding how it works, you will find that all the tools and knowledge to achieve that goal are contained within. Please feel free to follow that path and post back with your own modifications.
 
yes i found the solution already - i will call it multiple dynamic search term not single only since it can search 2-5 keywords or any number of keywords that are in the database. but i cant post it back since the thread which you posted that sample is closed already.

thank you so much John Big Booty. your sample did a big help to me.
 
If you think the sample you have created is worthwhile you can always post it as a new thread in the sample section.

Make sure you have fully tested it and fully detailed the code using comments. Then give a brief explanation as to how your sample works in the body of your post.
 
ops my bad. its not working, i thought i got it. sigh! i tried searching 3 keywords in a jumbled positions (even in order); like Australia (countryname), Angove's (winery), and SA (state), then no item/s found.
 
so John Big Booty or any members here, any ideas how to do it about adding records to a form and will be saved to the database instead to a table of the navigation pane? i still didnt figure it out how to do it. any help is highly appreciated. thanks.

note: im a beginner to ms-access
 
You must log in or register to reply here.

Similar threads

A
Simple warehouse data entry
Replies
12
Views
695
arnelgp
arnelgp
D
Darshan Hiranandani : Creating a Form for Multiple Entries in a Table (Same Form) - Dispatch Details
Replies
7
Views
448
isladogs
isladogs
H
Solved Dlookup Or SetValue not working
Replies
17
Views
749
mike60smart
mike60smart
S
Need a Form With sub form with populated client info and a subform with services and price in items invoice, please help
Replies
3
Views
280
Pat Hartman
P
H
Solved How to make a form to enter multiple entries in table with same form
2
Replies
38
Views
2,354
hrdpgajjar
H

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Back
Top Bottom