Recent content by Thedon123

I need to move a value from a main form to subform so that i can use it in a calculation in the subform. the subform is derived from a table. How can i do this?

How do i remove the close X button from the main database screen. is there a way to do this.

I have database that has a mein form with a subform. the main form has the user details and has 3 primary keys the user id , invoice number and invoice letter. when the user has to enter a specific product for the user he does it in the subform. what i need to do is to get the value of how...

I have records as below a 1 b 1 c 1 a 2 b 2 a 3 i am trying to count the number of records for 1 and the number of records in 2 and the number of records in 3 separately. How can i do this

Thank you very much

I have a button that opens a form a form where i add data. This form "ADD NAMES" is dependant on there being a user selected alraedy in another table. When there are no users in this table it opens the form anyway and causes it to crash. So the question is how do i get the the button when...

I cannot tab from subform to subform that are on one form. Does anybody know how i can get that to work.

I have query with value A B C D E 0 1 2 3 1 0 0 0 0 0 1 2 0 9 0 0 0 0 0 0 0 0 0 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 I need to filter out all the 0 0 0 0 0 records from the query how would i do that. A B C D E repsent trhe different fields

I want to disable the shift +enter on the icon that allows the user to access the database window. how would i do that.

i am using the vbyesno command. when it come up the cursor is positioned on no how do i make yes the default cursor position.

how do i check if there is atleast one record in the table in VB

thanks a lot mate

when i turn the whell on the mouse it changes my record to the next. is there a way to disable the wheel on the mouse for access with locking the field. I would rather it scrolled down the page.

my mistake it is working brilliantly

it doesnt seem to work its asks me for a macro name.