Complete Newbie

[toffer67]

Hi Guys,

i dont know if anyone can help me here as i have little or no experience with Access but here goes:

I am running access 2007 and have created a table with specific number, names, and dates.

I have also created a form to enter the data, the problem i am having is that i need to create a search button on the form that if a specific number is searched for and found the form is populated with said Number the date the number was entered and also the name of the person that entetred the number.

Thanks in advance
a struggling newbie.

 

[RuralGuy]

Assuming all of the data you want to display is in the bound query/table then it sounds like you need to use the ComboBox wizard to "Find a record".

 

[toffer67]

Assuming all of the data you want to display is in the bound query/table then it sounds like you need to use the ComboBox wizard to "Find a record".

Thanks for that,

ok, all the data is in the table, when i run a query i can out put the data i need onto a query, but i need to output some of the data onto the form, like name, date, and the number.

how do you use the combo box.

 

[RuralGuy]

Did you use the wizard to create a ComboBox and choose the 3rd option?

 

[toffer67]

Did you use the wizard to create a ComboBox and choose the 3rd option?

Sorry, im not following you.

i ran a simple query from the query wizard that allows you to see the date name and who it was created by, but not on the form it just outputs the data on another sheet.

i am looking to add 2 things:

1.To add a button to my form to search for a record.
2.when the record is found it outputs the number, the date, and the person who creted the record.

 

[skaas]

Are you wishing to show data from your table onto your form

or

Are you wishing to show data from your quiery onto your form?

 

[toffer67]

Are you wishing to show data from your table onto your form

or

Are you wishing to show data from your quiery onto your form?

i am wanting to add a search button, when that button is clicked i want to show data from my table on the form with name, number, and date on the form.

so i dont know if you click the button that is a query to check if the number is in the table.
sorry if im over complicating things here.

 

[Swillsy]

Heya have you tried using the command button wizard from the toolbar

create a button then select 'find record' in the wizard.

as for the other info - have you got fields in the form where the user puts his name or a timestamp?

cheers

James

 

[RuralGuy]

Let the wizards help you as much as possible. At least until you get a feel for what they are doing. Let the Form wizard create a form for your table. Then Let the ComboBox wizard add an unbound cbo that will "Find a record" After you get that working you can look at the code behind the form and controls to see how to accomplish what you want.

 

[toffer67]

Let the wizards help you as much as possible. At least until you get a feel for what they are doing. Let the Form wizard create a form for your table. Then Let the ComboBox wizard add an unbound cbo the will "Find a record" After you get that working you can look at the code behind the form and controls to see how to accomplish what you want.

Where is the combobox wizard??

i am using 2007, i have attached my form, would yo umind having a look to see if i am doing this correctly please

 

[RuralGuy]

Do a Compact and Repair first which is under the Office logo under Manage. Then zip up the file. It needs to be < 394 KB to upload. If it is too big then you will need to use one of the free file hosting services and just provide a link.

 

[toffer67]

Do a Compact and Repair first which is under the Office logo under Manage. Then zip up the file. It needs to be < 394 KB to upload. If it is too big then you will need to use one of the free file hosting services and just provide a link.

Done, saved under new table_current_23_06

 

[toffer67]

Ok, here is a update,

I have managed to get a search button on the form that when you enter the number i can out-put the data onto the form that i need, Result.

as you guys have said it just took a bit of messing about with, thanks for your help.

Now..........

would anyone know if i can add this to a shared drive so people can add to this form, i need this to be running live so it can be updated by many users at the same time.

 

[RuralGuy]

Are you saying that many people will be modifying the form? Or will many people just be adding records to your system? If it is the latter then here's a link for you: http://allenbrowne.com/ser-01.html

 

[toffer67]

Are you saying that many people will be modifying the form? Or will many people just be adding records to your system? If it is the latter then here's a link for you: http://allenbrowne.com/ser-01.html

Only people adding records to the form Ruralguy,

Is there any way of them not seeing the table and only being able to see the form, so when they click on it it is just the form that is opened and the table is updated.

also can you add a calculation to access like the ones you use in excel.
e.g. quotes/orders.

 

[toffer67]

Ok, im in a whole new world of pain now, after creating the button to search for number in my database i cannot now enter data through my form, when i get to the last entry i press enter and its juming onto the button to search for another number.

any ideas how do i bypass this???

 

[RuralGuy]

Use the Tools>Startup... form to disable everything and set your form to load.

 

[skaas]

general

Hi,

Glad to hear you are making progress on your work

1.

Here is a quick link expalining how to hide forms and other access modules from users http://www.techonthenet.com/access/database/hide_tables.php

This quick link will explain how to make your data base show a form when a user opens the database
http://www.techonthenet.com/access/forms/startup.php

2.

You certainly can make calculations in access, though the process is more complicated.

You would actually need to use VBA code to determine your values and calculations...

If you have an idea of the type of calculation, post an example and I am sure we can help you....

3.

To make sure you can enter and modify data on your form - The object the data is going to or from has to be Bound to a field within your table or an object recordset within your coding.

example:

You data shows on a form into a textbox

You must right click the textbox in design view and open properties.

There you will see an option for " Control Source "

Navigate to and select the Table and Field(s) you wish to be able to modify, the text box will now be bound to your chosen field within your chosen table.

You also have to remember to save the database - adding a save button to your form will remind users they must save the records on the form before closing it

 

[toffer67]

Hi, the calculation im trying to enter would be the number of quotes/the number of orders.

also

im not really following about the button thing, before i added the button i just added the data to the form and pressed enter on the bottom and the data went into the table.

now when i get to the bottom of the form it jumps to the search button without adding the data.

 

[toffer67]

Can anyone help with this question guys, really struggling here!!