Search results

Hi, I am working on a database for an assignment for university. I am seeking some help for one of the forms I am creating. I have a properties table listing all the details of a property and a unique ID, I have a client table and a booking table etc. I want to create a booking form, but I...

Aah, I'm kicking myself now, you won't believe how many times I looked over that query and constantly looked at spelling but judged it as fine... I'm silly thanks for that article Paul, I'll give it a read and a go! And thanks for noticing my idiotness! Cheers! Adam

Hi, I am trying to make a query that updates the amount of stock, by simply taking away the quantity of stock purchased from the total of stock in stock! I did what I thought I was supposed to do, but it never works - I get a box asking me to set the parameter, even though I've already...

Andy, Thank you for your help and efforts. They have been appreciated and you have helped me a lot, thanks! Adam.

Hi Andy, This is helpful, however I am not sure how to set up a filter to do this for my database. Could you explain how, please? Totally off the subject, but is it possible to set up a macro or something else so that I can print off several queries without having to individually print each...

Hello again, Once again for your help so far. I looked at the database, and the relationships are how they should be in my database. It actually works as well, but only to an extent. It only works with whatever record shows first. How do I make it so I can simply change the name at the top...

Hi again, Thank you for your warm welcome. Also, thank you for your assistance with my problem. I have done as you have asked but when I try and add more records of data (a purchase) it gives me this error: 'The changes you requested to the table were not successful becasue they would create...

Hello, I am making a database and I am currently doing my forms. I have been using wizards and so far everything I have wanted to be able to do has been achievable, except for where I am now! I am making a 'purchases' form. What I want to be able to do is make multiple purchases in the one...