Complete Newbie

[RuralGuy]

Sorry Toffer! I didn't mean to leave you hanging here. Thanks for the bump. I'll take another look at it.

 

[RuralGuy]

I guess I have to ask how many functions is this form expected to perform? Are you searching, editing, deleting or adding and how do you tell the difference?

 

[toffer67]

I guess I have to ask how many functions is this form expected to perform? Are you searching, editing, deleting or adding and how do you tell the difference?

no probs about not getting back to me, i was on holiday, lucky me back to this!!

What im looking for is to add a record to the database through the form, this was working until i added the search button, but now when you get to the button of the record it just jumps onto the search button.

What i would also like is to be able to search for order number that would show who created the record and show the quote number associated with it.

There is also a calculation that i need to add but that can go on the back burner for the mo as i can do that in Excel.

You help is grately appreciated.

 

[RuralGuy]

Have you tried going to the Other tab of the properties sheet for the CommandButton and setting Tab Stop to NO?

 

[toffer67]

Have you tried going to the Other tab of the properties sheet for the CommandButton and setting Tab Stop to NO?

You sir are a genius

All i need now is to work out how i get this on a shared drive so many users can update data at the same time, i have a few leads on how to do this and will be giving it a bash.

Thanks very much for all your help along the way RuralGuy your help has been very much appreciated.

 

[toffer67]

You sir are a genius

All i need now is to work out how i get this on a shared drive so many users can update data at the same time, i have a few leads on how to do this and will be giving it a bash.

Thanks very much for all your help along the way RuralGuy your help has been very much appreciated.

P.S
I need to add in a calculation at some point as well calculating the orders/quotes, any tips........

 

[RuralGuy]

Describe the calculations with more detail. What are you counting and where will you be using this information?

 

[toffer67]

Describe the calculations with more detail. What are you counting and where will you be using this information?

the exact calculation that i need is the total quotes / total orders so i can see the percentage of quotes that is converted into orders by each individual.

Would i need to create another another table with all the users in the table or could i do this by creating another form??

i dont really know where or how to use this calculation or what i need to do to create it.
Any advice.

 

[RuralGuy]

Where do you plan to display this calculation?

 

[toffer67]

Where do you plan to display this calculation?

Im not sure, (advice would be appreciated)

Would i be best to create another form to do this??

so i could have a drop down menu with agents names in it then when you select one i could have another calculation button that will show the final calculation.

Is this possible??

 

[RuralGuy]

Well it is your application and I don't know how to help you here but it sounds like it is a different form that focuses on the agent.

 

[toffer67]

Well it is your application and I don't know how to help you here but it sounds like it is a different form that focuses on the agent.

Ok, no-one but me needs to see the calculation, so if i create a different form can i create a calculation on it.

the calculation will take in how many quotes have been converted into orders.

how do i create i calculation??

 

[RuralGuy]

So you want the Count([Orders])/[Count([Quotes]) WHERE Agent = n right?

 

[toffer67]

So you want the Count([Orders])/[Count([Quotes]) WHERE Agent = n right?

Yes that sound right

 

[RuralGuy]

Why don't you try and build that query in the Query Builder?

 

[toffer67]

Why don't you try and build that query in the Query Builder?

Because it wont show the percentage rate

 

[RuralGuy]

Why not? Percentage is just a formatting option.

 

[toffer67]

Why not? Percentage is just a formatting option.

Ok, im learning all the time, how do you do that?
when i am creating the query it does not give me the option of formatting

 

[RuralGuy]

I thought you were going to use the results on a form somewhere? The control you will display the results in will have a format property. In the query builder, if you highlight a column and right click, there is a properties selection.