A user end?

qurn

Registered User.
Local time
Today, 13:39
Joined
May 2, 2005
Messages
63
I need some help building what I believe is called a user end. I'm done building the tables and forms and all that jazz, now I need an interface that my boss, who knows nothing about access, can easly access and manipulate data. Of course it would be nice if I'd look nice. Is there anybody who can help or can give me link to a decent tutorial.

I already searched these forums and googled for help.
 
For a true beginner; you could use the forms and reports "wizard" options to get you started. Look at the northwind sample db that is included with all versions of Access. Post back when you have specific questions/problems building an object.
 
yes well I have been experimenting with forms and reports. I guess one of the main questions I have is how does someone get a form to load with the Data base. Also I'm having trouble getting the forms to "search" the tables or querries. I know theres a lot of code on this site thats helpful, but not if you do not know where to put the code or how to structure it.
 
Last edited:
You can get a specific form to load when starting the DB by:

going to Tools > Startup > Then choosing the form name you want to start the DB with.

-------

Forms can be based on Queries, which is what you should be using to 'search' the DB. You can enter criteria in Queries to narrow down 'Search' results. Then use the Query as the control source for your Form.

HTH - tried to keep it simple!
 
Dang that was easy, Thanks! :)

yea ok I kinda figured that, but lets say I have a table with orders and one of the colomns is named fruits. So you have a combo box with different fruits. how do you get it so that the fruit the user chooses will be in the criteria of the of the querrie.

also how do I do the same with text boxes
 
Last edited:
clarify what you mean when you say search?

Forms can be based on Queries, which is what you should be using to 'search' the DB. You can enter criteria in Queries to narrow down 'Search' results. Then use the Query as the control source for your Form.
 
edited my last post. I'm very tired today.

how can I search for sections or key words in a phrase, like finding the phrase "the cat jumped out the window" by putting in "cat" in a text box.
 
oh yea My boss doesn't realy want to open up forms, querries, or reports. If he needs to do any looking around for different tables or anything he'll proboly think it's not working properly. basicaly I need to dumb the interface down so anyone can use it.

the more simple it is the better
 
You have to set the criteria as the name of the combo box on the particular form.

EG:

you want your selection to be based on a combobox (cboFruit) on the form (FrmSelectFruit) which is based on the table (TblFruits) !

your query has to have tblFruits as the source
The criteria in the fruits fields should hold [Forms]![FrmSelectFruit]![cboFruit] (ie so the criteria is based on what you select on your form)

Have a button on your form which runs the query

If you right click in your query on the criteria row and select Build... you can easily select the field you want your query to reference to.

also,

Part searches can be done by using Like * - asterix finds everything.


Hope this makes sense!
 
Last edited:
qurn said:
oh yea My boss doesn't realy want to open up forms, querries, or reports. If he needs to do any looking around for different tables or anything he'll proboly think it's not working properly. basicaly I need to dumb the interface down so anyone can use it.

how do you expect to build a front end interface by not using forms? :)
 
oh no I fully expect to use forms. My boss doesn't want to put any effort to open forms himself. I need to get the whole database from forms using command buttons.
thanks for the fast help.
 
Last edited:
mohsinhq said:
you want your selection to be based on a combobox (cboFruit) on the form (FrmSelectFruit) which is based on the table (TblFruits) !


Hope this makes sense!

I'm having trouble understanding this, if I use the wizard to make the form frmselectfruit based on the table tblfruit there is already a text box that is already filled out. I still do not understand how to get a combo box to relate to a table or a querrie. I'll try to attach a database that more is more or less what I want do.
 

Attachments

Yes! I got it to work finnaly, thanks guys.
 

Users who are viewing this thread

Back
Top Bottom