Search results

it is set like that but is still aligned to the left.

Without grabbing the whole form in design view and moving it over is there anyway in which i can just centre it to the centre of the screen horizontally? My form is not very wide but i've created it while leaving the thing aliogned to the left of the screen so the whole right hand side of the...

Thanks for your help guys. Turns out i did have exactly what i wanted. Having a customer reference for the address in both tables linked up in the relationships bit. All i had to do was put in the query and adapt it to show the results i wanted and then produce the report. Great stuff.

Because eventually i want to be able to produce a report that has the customers address on it and what they ordered. Now if they have more than one order in a day under a different order number i would like to get it so the address shows, all items are added together and then the order numbers...

With a subform is it possible to reference one table but save the data to a new table? Say i created a table (Address Table) that has my cutomers name and address in. It has 7 fields as such "customer ID, Name, Address1, Address2, Town, County, Postcode" Now i want to create an order form. It...

Thankyou for your help.

Is there a way to delete the borders from a form? You know the ones from the bottom and right hand side which have the buttons on for you to skip between records? Also the one on the left which has the arrow in the top corner.

Basically being a newbie to Access i dont know where to start. What i want is to create an order form that has the customer ID on it and then has 5 drop down boxes where you can select the items the customer has ordered and the quantity for each and the data save to a table.

Thanks for your help.

My problem is i have had access for a day and just dont know where to start really or any good tutorials to show me how. I spent my first day on the program learning how to make a table and a form so now i hope to move onto doing what i said and was just hoping for a nudge in the right...

I have a list of addresses that i have saved in a table. I have made a form that allows me to enter a new customer and their address and then save it to that table. Each customer has a special number to identify them. Now what i want is to be able to build a second table to save their orders...