Search results

First of all , thanks for your attention. Let me explain , what is my database logic. For defining new user , the current operator should know , who is the id that she choosed, thats why i bound id and name but the visible field is the name. Honestly the reason that i gather first name and...

here this is my database relationship. please take a look.

Hi I have an access database that keeps the employees status. in one of forms i enter the leave that they go. i want to know how can i show on main form that based on that data that enter, how many person are on leave? and also when their leave is over. access alert me by a message box that...

Hi Is there any chance that I count on for your help about setting tables in correct way?

yes exactly.

we guarantee our quality of our repairing. and we mention in our contract with the customer that has heavy machine, if this machine during next 6 months doesn't work properly. we send our repairer that service it for them without paying money.

It applies to all parts of machine.

they belong to specific customers.

OK let me explain what I understand we have some mechanics that repair engine and and gearbox also and some technician that works in hydraulic parts but for the other parts of machine we don't have any specialist that work so we outsource those parts to other mechanics that aren't in our team...

Actually I did not understand what you mean.

Hi yes I want to record almost all you have mentioned. the items that record in the contract are : duration of repairing the cost of repairing the parts that we want to repair the guarantee service that we give them about duration of guarantee that if some parts don't work properly we service...

I want to design a database for a company that is in heavy machine overhaul and repairing. they want to keep and save the data of : cost of every parts of machine that they spend in category like cost of 1.motive force system 2.hydrualic system and etc. machine that their guaranty is started...

in every project that we may have we have several repairer that may be differ within projects. we should save their record that's why I categorize like this. maybe in one project we have 3 repairer and the other 5 or 6 . I put 9 possibilities in my database.

thank you

Actually I am new to access and I am not really professional in setting data in correct category. Is it possible to say how should I sort data that works good?

I hardly explain what is my mean because my native language is not english and my db info isn't in english by the way I upload it here my database.

Hi everyone I have a invoice form that I enter the summary of cost and the item category that is spent for and also the date of the invoice. I want to calculate that in each date and for which category how much money spend? at first I wanted to do this through query but the there are multiple...

none of them couldn't be added to trust location.

I dont think so because it was closed.

I thick this checkbox Error 490 - Cannot open the specified file I got this error in another computer for opening the folder that I address in vb . but the folder is located in our share network and the address is the same for all users. thank you for your answer but I already ticked this...