Recent content by Nick.NZ

Hey guys, Another question. When I click the save button on a form, before it saves the data, is there a way to check null fields, and highlight them? Thanks Nick

Thank you sir, that worked.

Hey guys, I was wondering if there is a way to display blank fields in all the text boxes until a customer has been selected from the combo box? At the moment, when you open the form it just defaults to the first customer. Thanks, Nick

T Thank you, this worked.

Is there a way to embed the code into =[Test4 subform1].[Form]![Text18] ?

Hasn't worked unfortunately. The same goes if i try and change the format with the drop down menu manually. This only works when the event is coming from another text box. But because it's coming from a button with a macro it doesn't seem to change it.

Hi guys, I've got a Save button that once clicked displays the Order total. I'm just not sure how to add the currency (dollars), and round to two decimal places. If it was a text box there is an option in the access interface, since it's a button i presume it needs to go into the code. In the...

Hi there, I'm trying to sort out a macro so if the quantity supplied > quantity ordered, it gives an error, and won't update the quantity supplied field on a sub form with the higher number. If the quantity supplied < quantity ordered, i want it to minus the quantity supplied from the stock...

Yeah will do in future. It was just trying to get the thing working, so i ended up deleting and adding text boxes multiple times. But yeah i realize its good practice to properly name things. Thanks for the feedback.

thanks man, I'll try it that what as well. Thanks for your time

Alright i managed to sort it out. In the sub form footer text box (text28 its called in this case) i put =Sum([QuantitySupplied]*[UnitPrice]) then i put another text box in the main form and just put =[test2 subform].[Form]![Text28] and its all working. Thanks for taking the time to reply guys.

Thanks for replying. Sorry i dont know anything about visual basic, i'm just using the access interface. Thanks for typing up that code. Is there no way around this without writing code?! seems like it should be such a simple thing to do

Okay so the view that i would like is datasheet" because this displays both products on a single page. The issue is for some reason it doesn't show the header or footer if i were to put a text box in there. If i change the view to continuous, i can see the header or footer, but it'll show 1...

So the name of the product total text box is "producttotal" as you can see from the 4th screenshot.

Hey guys, So I've got a very basic problem, but i can't understand for the life of me how to solve it. 1. I have a main form 2. I have a sub form. In the sub form it contains the Unit price, and quantity supplied. I added a text box into the sub form which is the product total. The product...