Search results

ok, i've uploaded it onto my mates FTP account. http://www.hursttilingsolutions.co.uk/frontpage at the bottom of the page, it says: download access database and when clicked on, a download box should appear. thanks. :) btw it took under 2 minutes to download it on a NTL BB 600k connection.

edit. wrong button

Parker ok, i have uploaded some pictures of the system to show you what i mean more precisely. ok, first link shows all the component tables: http://www.geocities.com/rvd48uk/1stpa1.jpg [**EDIT**: for some reason this page does not display if you click on the link, please copy and paste...

after experimenting with the subforms/reports in Form design its not exactly working. i'll give you the rundown: a customer order's a computer to be built, in Form view,a new record is made, the components are selected from the drop down list and the correct price appears in a field next to...

thanks for the reply bob. :) at this point im not worried at whether the data is updated in Excel or Access, as long as the system works, im happy :cool: i'll try and experiment with putting a spreadsheet within a form.

sadly, i carnt get the price of the component in another field. it still appears in the drop down list in the form, when i imported the spreadsheets into Access, i created a table for each component which consist of two fields: 'component' and 'Price' i combined all the components into one...

thanks for the help gold ol'penguin. its solved another problem i had which was that previously i could only get the price of a component by means of a drop down list. now, i can get the price in its own field.

im doing a Access project which is based on a computer shop, the customer records, what they ordered, computer components and prices are stored in the database. the computer components and prices are imported from a table in Excel. The major set back is for me is: that as you all know...

thanks for the help mile :cool: i went into the query which the form was based upon, and into datasheet view, i tried to edit the records but it wouldnt let me, i went back into design view and relised i had a dodgy relationship between two tables which shouldnt have been there. :cool:

my forms seem to be locked, i.e. i carnt edit them but can in table desig, though my friend can edit his records in his forms. any suggestions please? :confused:

thanks mile:D , i got it sorted now btw, is that a picture of gail porter?

i've imported the sheets one by one. now when i go to my form, for some reason it brings up a parameter box asking to enter GRAHPICS CARD.CODE value, i've checked my tables and query nothing looks out of the ordinary, can u help?

i've got 12 worksheets in a excel file. i want to import them all into one new table into Access, i go to File> Get external Data>Import. though it only allows me to select one worksheet, i would like to select them all, how do i do this??:confused:

so, i should import all the different component data to one table and have anotehr table which has the customers address details?

i am building a computer database for my A'level ICT coursework. basically, the end user enters the customer's details in with the components and prices to store as a record. i have designed a table called 'CustomersTbl' which has the fields: CustomerID, First Name, Last Name, Gender...

Mile-O-Phile thanks for that mile :D :cool: .took an age. basically, i had to just rename the "MY Field" to what i actually called it, dlete everything i've got in my SQL box and paste the code, simple ehh:) master Mile: you say that my relationships are incorrect, i have made a copy...

done what you said mile, now get another error box: http://www.hursttilingsolutions.co.uk/SQL%20NO1.jpg if i delete the asterix next to DELETE, then when i run it, a parameter box appears asking for a value.

A2 level= A'level ICT= information, communication, technology. i've made it into a WHERE statement, and it comes up with an error box: http://www.hursttilingsolutions.co.uk/SQL%20nu1.jpg im a newbie, dont get too pissed off Mile-O-Phile

ok, i've inserted the code into SQL view: http://www.hursttilingsolutions.co.uk/access1.jpg but when i click on "datasheet view" all the fields are still present and at the end Column it says "Expr1031" and gives back value's of -1 and 0 for some reason...

here's a picture: http://www.hursttilingsolutions.co.uk/M%20Acce1.jpg