Search results

Hi , I am very new to access and I have made a database for a small wedding car hire firm as an assignment for college. The database works fine , I can add my customers , staff , vehicles etc.. and make orders ok but I have some criteria I need to meet running through criteria A-Q I have met...

Perfect , works a treat and does all I need thanks for the tips , its the easier stuff like this I dont know , and not knowing Access very well I get a bit lost. a very handy tip and info thanks

right thanks for that Pat ill take all this on board and change things accordingly. I am an absolute starter when it comes to access and evrything is new to me I do understand some basics however and what you say makes sense. I didnt know for example that I could calculate the deposit on a...

well what happens at the mo is. I input a total cost in one form field and the deposit field below in the form has a little forumla in the Control Source =[Cost of Order]/2 the deposit will always be 50% no changes there but once this data has been inputted the table updates the total cost...

Hi I have a field on my form called cost of order I also have a field called deposit on the form that is generated by dividing the cost by 2. is there a simple way (most probably) to the send this data to my payment table, I already have a deposit filed set up in the payment table I just want to...

after a day of water and a night of sleep I sat down today and got miles with this database on my own , hoorah! one thing you may be able to help with is this. I would like to change a form based on a choice perhaps using "afterupdate",is it possible to run several queries from a form after...

ok, dont be too mean though this is my first ever db lol , as if you couldnt tell :)

Sorry bob , databases are not my speciality at all, I can manage to get through most things but I am not sure of the access lingo to do certain tasks like checking things against each other. Basically what I have to do is create a simple Wedding car hire company. A customer makes an order for a...

If any of you guys have any spare time on your hands would you mind having a look at this mess and tel me where I have gone wrong. http://www.geocities.com/andrewnorthwales/Andrews_database.mdb andrewnorthwales/Andrews_database.mdb mm this board is...

This is simple Access but I am quite simple so help would be cool all I want to know is how to put text from one field into another, but not every time. lets explain I have an order form and two fields , one date booked , and one date requested. if date booked is empty I want to copy the info...

Hello I am a total newcomer to the world of Microsoft Access and I have been given a task by our tutor to create a database Using the programme. I have set up my tables and my forms and some querys but I am unsure how to do a simple task. The idea of the database is as follows. A customer books...