Search results

Indeed, i've entered the code as you tried it, and yes my 'desktop' (which is where the db is) is a trusted location. Weird!?

Hey there, i really appreciate your help. But for some reason i can't get it work - nothing happens. How do i call a function correctly? I thought that if i put the code into the subform, it should show in the expression builder, and i could choose it. But it doesn't show there. Or if i just...

Thank you so much - yes, it's a continuous form for the subform! Here's the form, for clarity:

Hey, thanks for the reply. That's the bit i'm comfortable with, it's the procedure writing i can't do! Sorry to ask but is it possible to spoon feed me/point me in the right direction a bit more, i'm very rusty when it comes to my VBA! Psuedocode is something like: If ALL...

Hi there I have the following scenario - a form which is basically an 'invoice' - and this contains a subform with one or more items in it, that belong to this invoice. Each of these sub-form items has a 'ItemClearDate', which is marked manually by the user when each of the items is 'cleared'...

Hi guys, I'm doing some simple Access db stuff after many years out of the game. Unfortunately, i've forgotten a lot! I'm making a simple invoicing database with (currently) two tables with a one-to-many relationship: one Invoice can have many InvoiceItems (and each Invoice Item has a price)...

don't worry, i sorted it!

Hey i was just thinking - instead of updating the listbox like so: Is it possible to update the query itself from the VBcode, and then the report would work perfectly? I think i need to use CreateQueryDef function or something? :confused:

Hi there! I have a listbox, (which grabs its data from a stored query) that can be sorted by the user using buttons on the form - eg i have a button which allows the user to sort listbox results by ascending price. There is also a button which lets you print a report, which is generated...

Not sure if this is actually possible but i'm gonna try and find out! Cheers Edd

Thanks for yet another detailed post Wayne I would use subforms but for two reasons: a) i have set OnClick events on the listbox items so that forms pop up containing more/full data is available to the user (for that particular product) and b) i think they look ugly! But i tried a subform in...

i don't really understand the above explanation too well - sorry! i was searching for formus as i need to do the same thing - i have a lsitbox and i'd like to give the user the option of sorting by TradePrice (both ascending and descending) and RetailPrice (again both asc and desc) but this...

you are the absolute man! can't have spaces, but it's much nicer now, i think many thanks!

aww, shucks. that kinda sucks. that makes things messy, as can be seen from the attached pic i'm not sure whether to leave it, or go back and change all queries, tables, code, and forms with new names, typed out 'nicely' i'm a java coder so i'll use lowercase out of habit, plus it's easier to...

Hi there I have a listbox and all is well - the only problem is that the column heads are a little 'ugly' - my column names are usually something like 'catagoryName', 'productType' and 'price' instead of looking pretty, like 'Catagory Name' and 'Product Type' and 'Price' respectively. Is there...

perfecto :) many thanks

Hi there Really simple problem here - i'm trying to open a 'product entry' form with the same 'supplierID' as the current open form (which will be the supplier details form), ready to insert a new product (that is supplied by that supplier). When i don't have the acFormAdd part, the form...

no i didn't :) my default is a network one i use when i'm at work (it's a laptop) i changed it to a pdf995 printer and it doesn't hang any more many thanks, this forum rocks! Edd

Hi there Strange problem, i'm using XP Pro and Access from Office 2003 (both real full versions from work) - and in general use, when the mouse hovers over the 'print' icon (at the top left, undernear file, edit, view, insert, near 'save', 'new', etc), then access will hang for about 20 seconds...

Hi! I just tried me.mylistbox.requery in the 'current' event of the form, and it worked! i shall try it in the afterupdate now It's all coming back... slowly! Thanks!