Search results

cant you have an event that runs when the user double clicks ona list in the first box. it would then copy data across to whatever table the second listbox is representing and then requery it.

if its bound and the fields are bound to table fields then it should save to the table automatically

run a query?

also try increashing the refresh of acces. think its set at something silly like a minute but u can reduce it to less so it updates the form sooner.

lol acces sux. 1 letter and u resort to hair tearing

thats very messy Dim a, b, c, d as double a = Me.[Quantity_Ordered] b = Me.[Price] c = Me.[Discount] d = ((a*b) - (b*c)) Me.[Line_Item_Cost] = d tidier. not sure where the problem is though...can you post the database to look at?

does the code not work? or sint that what your after? sorry but i dont understand what your after

use =Now() ?

its ok figured it out thanks

Does anyone know if its possible to select all items (that is turn all items black) in a listbox? thanks

why not just make regular backups of your database? common practice

try using an input box instead. on the click event open the input box as parameter entry then open a recordest based on those criteria. Then check to see whether the recordset is empty. oif it is the invoiceID doesnt exist. Dim tempInteger As integer Dim rst As recordset Dim str As string...

noone ever does :)

do you have user levels that prevent normal users from viewing?

change the other forms property to popup

silly question but have you bound the column of the combo box? bound column =?

you need a checkform function i think. This will be called on a save button etc to make sure all necessary fields are filled in. ok the function should look something like this Private Function Checkform() Dim strErrorMessage As String If IsNull(Me.whatever)=True 'can also use =0 =""...

doCmd.setwarnings(False) query here doCmd.setwanrings(True)

would if me.combobox.itemdata(1) = true Me.mytxtbox.visible=true end else Me.mytxtbox.visible=false end if make a difference?

you didnt explain that very well