Search results

so if your not here to help what are you here for?:confused: and if you take the time to explain a bit better instead of being so abrupt i would be able to do it my self! but then again if i could do it my self i would not be asking for help.???? And you wonder why i started another post...

What I meant was I left all the relationships set up but I also had queries set up e.g tblCustomers you could select StateID drop down and the query inputs the state you select. instead of the StateID number. the database now has no queries and was wondering if you could setup say tblCustomers...

i have included the new db with the relationships set up now? don't know how i missed that last one! there is now no look up's at all if you could show me an example it would be much appreciated. thanks, Dean

All changes done, Thanks As you have probably seen i have look ups in the tables via query do these look right or is the an error? One trouble i keep coming across if i want to look up the details of a customer in the sales table it wants to input it as the customerID number instead of the...

restarted db as the old was quite a joke! Ok got it pretty close just need some help relating tblService & tblServiceParts any ideas? To me it looks pretty good and seems to work pretty good entering data through the tables. all the expected results show up.

i don't kinow everything i seem to do when trying to get my forms setup does not work i think because i don't have the relationships right?

please, please please help as i am totally stuck :confused:

Thanks got it now, Any comments on the rest?

Thanks for your reply, Do you mean sycronized combo's if so what's the best way to go about this? All the parts are known to us by part number as there really arn't that many.We use MYOB for our main buisness stuff this is mainly a db to have reminder's to allow employee's to start the db...

Could somebody please check over my database, it is finished and just would like some last minute Input. Click Here Any Ideas would be greatly appreciated. Thanks,

Sorry one thing i have also forgotten to mention is that we use MYOB for all our transactions, this DB's main use it for employees to see what services need doing via reminders that i will set (so every morning they open database and see reminders), that is why the info in the database is...

Added the query to all the forms Makes it a lot quicker Thanks :D Still having a little trouble understanding machine layout though; If this helps we have a lot of machine (wood chippers) 30 different models to be exact, we might have 5 of the same model machine on the floor to sell, but...

This was a hard one, as we have many machines of the same model but all have different serial numbers, engine numbers e.t.c. (would this create a whole heap of records of the same model?) Good idea Forgot that one. These machines are very big mainly for chipping trees and stump grinding so...

I have dine a lot of work on this since, I think it is finnished have a look and let me know what ya think. password is "landwaste" dbl click dates for calendar, also try scheduling a service and restarting database for pop up. db1 2002 version Thanks Dean :D

Please help as i am at a total loss?

Tables were redesigned by wazz can any one please help with form layout, as i am at a total loss, this database's job will be to store info about customers, the machines they bought (serial numbers etc), service's done on the machine what parts are used and and i want to be able to schedule...

ok i think i have got it, so which tables of mine should i delete just machine,machine parts and parts? also the main reason for this db is to schedule services on machines and be able to use a reminder for the day the service is scheduled will this table layout be able to adapt this. thanks...

Wazz are you saying to delete my tables and keep the ones you created? Thanks Dean

I thought i was finished but seem to be running into some trouble just wondering if yous could have a look at the tables and relationships and see if they look alright. As I am starting to get confused. This is access 97 Version db 97 version

Hi, Thiought i was finished but still need some help with my customers form, what i want to do is be able to view the parts needed to do a service on a customers machine.i curently have the customers form and machine details sub form, but if a customer has 3 machines i want to be able to select...