Search results

i had a similar problem when it came to this when i used linked tables..not sure if thats the reason for the problem but i ended up scrapping the majority and redoing it. Hope you find what your looking for best of luck

cant you just fire an insert query based on the result in the combo box?

are the tables linked?

cant you have a simple if statement after each button press or each update? if listbox1.value = listbox2.value OR listbox1.value = listbox3.value then MsgBox("cant do it") end else whatever you do after end if

shouldnt you be doing it in the after update since your returning the boolean of the result of the checkbox? and dont u need an end if?

I have 3 tables ItemTable, ItemCompositionTable, CompositionTable The user can bundle a few items together from ItemTable and name this item composition which is stored in ItemCompositionTable. They can then bundle these ItemCompositions together to create a "bundle of bundles" so to speak...

a certain foul word was "allegedly" derived from the crime of adultery. when people where placed in stocks for their crimes in ye olde days their crime was carved into the wood above their head. What they called adultery then was too long so instead of "For Unlawful Carnal Knowledge" they...

of nig-nog land

best teaching method? the way i learnt. get given a database with a motherload of problems and get cracking. learnt SQL, VB.Net and XML as well as cracking complex problems using methods i learnt along the way. never looked at a book. in at the deep end as they say.

oh yeah..and Dim the strTemp As String

oops sorry..just typed code and pressed enter. the code i put checks to see whether there is anything in the fields you're using. i put checkforms in all my forms so that all relevant fields are filled in, if not it tells me which ones arent. hope that helps the IsNull problem! good luck

strTemp = Me.CheckForm If strTemp = vbNullString Then Else x = MsgBox("You need to enter a:" & strTemp, vbCritical) Exit Sub End If Public Function CheckForm() As String If IsNull(Me.firstfield) = True Or Me.firstfield = 0 Then CheckForm =...

with regards to the barcode being copied across (your last problem) why not just have the control source for the second text box the same as the first? or am i missing something? or are you after a new record input after it has scanned, it wasnt too clear sorry.

How do you make a Duck play Jazz? Put it in the microwave till it's Bill Withers.

im just going to keep throwing suggestions your way till i run out. how about having your button directly manipulate the table/query the subform is based on? or set your sub-sub forms source to a query which manipulates fields in the subform?

how about changing the record source of the first sub-form to a query that relates to the 3rd form. you could change it when the 1st subform gets the focus, loaded etc. you can jump through subforms by this method and changing the record source.