Recent content by Miller84

Hi, I want to open a new form which is similar to the form it will be opened from. Only difference is the new form I want to open is designed for printing purposes. I'd like to access the this new form by hitting a button that opens the print form for a user given order number. Any ideas if...

If I have a set of address fields looked up by a customer ID number, how can I get acess to copy them into a shipping address field, which can allow the address to be altered if delivery is needed to an address which differs from the billing address? The example I have seen is in the Northwind...

Ignore that last post. I got it working! Thanks for all your help guys!

doing that puts a grandtotal column into the subform which won't work. I've tried everything you guys have suggested but with no luck. Ansentry thanks for the database file. I can't seem to achieve what you have done. When I put the extprice into the detail section of the subform it appears in...

I have a field in a subform called LineTotal which is calculated by multiplying (price1*quantity1)+(price2*quantity2). This works fine and LineTotal displays the correct answer. However I have tried to make a Grand total of the LineTotal using the sumfunction in the subform footer...

Where do I put that command then? Does that command save the record in subform AND update subform2 at the same time? Its essential that subform 2 is updated after an addition to subform 1 has been made.

Hi, After I run a requery command in an Afterupdate event (to update a second subform), the subform in my main form refreshes and returns me to the very first record in the main form. How do make sure that after the requery or refresh, the form keeps me on that record?

Success and my apologies Hi, You did indeed say "subform beforeupdate" my apologies, i didn't read your post closely enough. The code does now work!! However, when the error message appears all i can do is click Ok, i can't remove the new record without the error message appearing, which in...

in the Loans2 form, i have the following code for "bor_currentItemCount" text box: Private Sub bor_currentItemCount_BeforeUpdate(Cancel As Integer) If Me.NewRecord Then If Me.bookcount > 3 Then MsgBox Me.bookcount & " Records already on loan. Please return an item before borrowing...

I did try it and took it out because it didnt work. Where it says "txtCount" does that refer to the name of the text box where I want to place the total count number? Is there anything in that code that would need to be changed to match my database or is it a standard code? I'm very much a...

Here is a copy of the database. I managed to get the count function to work for each loan. However, borrowers can make more than one loan. So it is still possible to make a loan of 3 books and one of 5 books without triggering an error. Any thoughts would be appreciated. Many thanks

How would I do this? What sort coding is needed and where would I put it?

Thanks, but that doesn't actually count anything. I really need to perform a count based on data that is constantly changing. :confused:

Hi, How do I apply a limit to my library database to stop borrowers having anymore than say 7 books at the one time? New loans are recorded via a Loans form which contains a subform allowing the librarian to add new items to the Loan. I need to make sure that no matter how many Loans take...

Cheers! Got that to work with a bit of time.