Search results

Hii, What do you mean by a control on the mainform? A textbox? So there is no way to get the grand total in the subform? Thanks.

Hi, thank you for replying. I have done it the way you suggested in the picture shown. But for some reason it keeps showing up the way it does in the picture :confused:

Hii. I have attached a print screen for you so you can visualize the problem I am having. I'm not good at explaining haha :L http://i41.tinypic.com/15qb05u.png I don't know what is causing it. I could really do with some assistance! Many thanks.

Hiii. I am trying to calculate the grand total in my subform, however it is not showing. The subform is in datasheet view, and the calculation is in the footer of the subform. How come it is not showing up? :( Please help! :(

Thank you for replying. In the subform the fields NoOfHours*Rate gives the total cost. In the database totalcost is a calculated field. What I'm trying to do is do a grand total. The calculation is working, but it doesn't show up. I've placed the grand total calculation in the footer of the...

Hi, I have next to no experience in VB so could with some more help please. I have a table called tblLogin. This stores usernames and passwords. Such a noob here :(

Hii, I am currently trying to produce some code that can be used on a login form within my database. How do I make it so that the login will accept multiple usernames and passwords? There are a couple of member login details stored in the tblLogin, however I don't know how to code it for this...

Hi, I have a booking form with a subform. I have included a sum calculation in the footer of the subform however it is not displaying :s The calculation is used to sum up all of the total costs to make the grand total for the one booking. Why is it not working, when the syntax is actually...

Disregard the last message haha - I managed to validate it and stuff :p Could you give me some help with reports? I want to display all appointments in one week for one solicitor. I'd also like to make another report that just calculates monthly income (so all bookings in one month to calculate...

Hey man, thank you for replying. She told me to just change the field names so that the exam board don't be funny about it :p Btw, could you help me with a few other things? I'd like to wrap this database up pretty soon :) I realised that I need to validate my database, and I've done it but the...

Hello Kiwi. I just wanted to tell you that my teacher said that the subform was right so thanks - she still tried telling me its duplicate data though o_0 I'm trying to do another calculation on the form that adds up the cost of all bookings? How would I go about doing that?

Hey buddy! You wouldn't happen to know how to create a login in Access? I know you can make a query and apply that to an IF macro event thing, or is it best to do it in Visual Basic?

Okk, thank you very much for the informative post! How do I explain to my teacher why I have CPH twice? Because I have this feeling that she will say it's not normalized as it's repeating data :o If she does say it's repeating/un-normalized, is it still possible to do the form/subform with...

Hii, Kiwiman has managed to help me solve my problems :) I'd like to thank you for your willingness to help me. I wish my teachers were as helpful as all you guys! :p This thread can be locked/deleted if needs be.

Wow, I didn't know you could combine two fields in the way you did for the drop down for the name! If I wanted to change the order of the name, I'd just switch forename and surname around? Also, if I wanted the title of the client in the list aswell, would I include that in the query and change...

Okk. Good idea! :) I'll get back to you :) Didn't mean to sound rude/lazy :o

Omg! That's PERFECT!! :D :eek: If it's not asking too much, may you explain what you did, so that I know for future reference?(In a pm would be good, so that I can save it for myself :)) I don't know how I can ever repay you! Just thank you soo soo much! I really wish you lots of good luck and...

Hi, I've tried this and I'm still getting the error :confused: I have uploaded the database for you so you can check it out:) Thanks

AppointmentTypeID is Combo14 I think. I deleted it first and then remade it as a combobox using the recordsource you posted :confused: What should I do? Thanks!

Do you mean like this? http://i42.tinypic.com/34eqqt4.png As far as I'm aware, nothing is populated. Thanks.